EGP_SEARCH_TPI_CUST_XREFS_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name

ITEM_RELATIONSHIP_ID CUSTOMER_ID TP_ITEM_ID CUSTOMER_ITEM_NUM INVENTORY_ITEM_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ORGANIZATION_ID MASTER_ORGANIZATION_ID MRP_PLANNING_CODE DESCRIPTION ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID START_DATE_ACTIVE END_DATE_ACTIVE VERSION_ID VERSION_START_DATE VERSION_END_DATE IMPLEMENTATION_DATE CHANGE_BIT_MAP ACD_TYPE CHANGE_LINE_ID STATUS_CODE

Query

SQL_Statement

SELECT MIA.ITEM_RELATIONSHIP_ID, TPI.TRADING_PARTNER_ID CUSTOMER_ID, TPI.TP_ITEM_ID, TPI.TP_ITEM_NUMBER CUSTOMER_ITEM_NUM, MIA.INVENTORY_ITEM_ID, MIA.LAST_UPDATE_DATE, MIA.LAST_UPDATED_BY, MIA.CREATION_DATE, MIA.CREATED_BY, MIA.LAST_UPDATE_LOGIN, MIA.ORGANIZATION_ID, MIA.MASTER_ORGANIZATION_ID, MIA.MRP_PLANNING_CODE, MITL.DESCRIPTION, MIA.ATTRIBUTE_CATEGORY, MIA.ATTRIBUTE1, MIA.ATTRIBUTE2, MIA.ATTRIBUTE3, MIA.ATTRIBUTE4, MIA.ATTRIBUTE5, MIA.ATTRIBUTE6, MIA.ATTRIBUTE7, MIA.ATTRIBUTE8, MIA.ATTRIBUTE9, MIA.ATTRIBUTE10, MIA.ATTRIBUTE11, MIA.ATTRIBUTE12, MIA.ATTRIBUTE13, MIA.ATTRIBUTE14, MIA.ATTRIBUTE15, MIA.REQUEST_ID, MIA.START_DATE_ACTIVE, MIA.END_DATE_ACTIVE, MIA.VERSION_ID , MIA.VERSION_START_DATE, MIA.VERSION_END_DATE , MIA.IMPLEMENTATION_DATE, MIA.CHANGE_BIT_MAP , MIA.ACD_TYPE , MIA.CHANGE_LINE_ID , MIA.STATUS_CODE FROM EGP_ITEM_RELATIONSHIPS_B MIA, EGP_ITEM_RELATIONSHIPS_TL MITL, EGP_TRADING_PARTNER_ITEMS TPI WHERE MIA.item_relationship_TYPE = 'CUSTOMER_ITEM_XREF' AND MIA.ITEM_RELATIONSHIP_ID = MITL.ITEM_RELATIONSHIP_ID AND MITL.LANGUAGE = USERENV('LANG') AND MIA.TP_ITEM_ID = TPI.TP_ITEM_ID