EGP_CROSS_REFERENCES

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

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, MIA.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 WHERE MIA.item_relationship_TYPE = 'ITEM_XREF' AND TL.ITEM_RELATIONSHIP_ID = MIA.ITEM_RELATIONSHIP_ID AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT MIA.ROWID ROW_ID,

MIA.ITEM_RELATIONSHIP_ID,

MIA.INVENTORY_ITEM_ID, MIA.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 WHERE MIA.item_relationship_TYPE = 'ITEM_XREF' AND TL.ITEM_RELATIONSHIP_ID = MIA.ITEM_RELATIONSHIP_ID AND TL.LANGUAGE = USERENV('LANG')