EGP_CUSTOMER_ITEM_XREFS

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name

ITEM_RELATIONSHIP_ID CUSTOMER_ITEM_ID INVENTORY_ITEM_ID MASTER_ORGANIZATION_ID PREFERENCE_NUMBER DESCRIPTION START_DATE_ACTIVE END_DATE_ACTIVE INACTIVE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID

Query

SQL_Statement

SELECT MIA.ITEM_RELATIONSHIP_ID, MIA.TP_ITEM_ID CUSTOMER_ITEM_ID, MIA.INVENTORY_ITEM_ID, MIA.MASTER_ORGANIZATION_ID, MIA.PREFERENCE_NUMBER, MITL.DESCRIPTION, MIA.START_DATE_ACTIVE, MIA.END_DATE_ACTIVE, MIA.INACTIVE_FLAG, MIA.LAST_UPDATE_DATE, MIA.LAST_UPDATED_BY, MIA.CREATION_DATE, MIA.CREATED_BY, MIA.LAST_UPDATE_LOGIN, 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 FROM EGP_ITEM_RELATIONSHIPS_B MIA, EGP_ITEM_RELATIONSHIPS_TL MITL WHERE MIA.item_relationship_TYPE = 'CUSTOMER_ITEM_XREF' AND MIA.ITEM_RELATIONSHIP_ID = MITL.ITEM_RELATIONSHIP_ID AND MITL.LANGUAGE = USERENV('LANG')