EGP_SEARCH_CROSS_REFERENCES_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name

ROW_ID ITEM_RELATIONSHIP_ID INVENTORY_ITEM_ID ORGANIZATION_ID CROSS_REFERENCE_TYPE CROSS_REFERENCE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DESCRIPTION ORG_INDEPENDENT_FLAG REQUEST_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY UOM_CODE REVISION_ID CROSS_REFERENCE_ID EPC_GTIN_SERIAL SOURCE_SYSTEM_ID START_DATE_ACTIVE END_DATE_ACTIVE OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT MIA.ROWID ROW_ID, MIA.ITEM_RELATIONSHIP_ID, MIA.INVENTORY_ITEM_ID, ITEMS.ORGANIZATION_ID, MIA.SUB_TYPE CROSS_REFERENCE_TYPE, MIA.CROSS_REFERENCE, MIA.LAST_UPDATE_DATE, MIA.LAST_UPDATED_BY, MIA.CREATION_DATE, MIA.CREATED_BY, MIA.LAST_UPDATE_LOGIN, TL.DESCRIPTION, MIA.ORG_INDEPENDENT_FLAG, MIA.REQUEST_ID, 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.ATTRIBUTE_CATEGORY, MIA.UOM_CODE, MIA.REVISION_ID, MIA.ITEM_RELATIONSHIP_ID CROSS_REFERENCE_ID, MIA.EPC_GTIN_SERIAL, MIA.SOURCE_SYSTEM_ID, MIA.START_DATE_ACTIVE, MIA.END_DATE_ACTIVE, MIA.OBJECT_VERSION_NUMBER FROM EGP_ITEM_RELATIONSHIPS_B MIA, EGP_ITEM_RELATIONSHIPS_TL TL, EGP_SYSTEM_ITEMS_ALL_V ITEMS WHERE MIA.item_relationship_TYPE = 'ITEM_XREF' AND TL.ITEM_RELATIONSHIP_ID = MIA.ITEM_RELATIONSHIP_ID AND TL.LANGUAGE = USERENV('LANG') AND ITEMS.INVENTORY_ITEM_ID = MIA.INVENTORY_ITEM_ID AND (MIA.ORG_INDEPENDENT_FLAG = 'Y' OR ITEMS.ORGANIZATION_ID = MIA.ORGANIZATION_ID)