VIEW: APPS.MTL_CROSS_REFERENCES_V

Source

View Text - Preformatted

SELECT MCR.ROW_ID ROW_ID , MCR.INVENTORY_ITEM_ID , MCR.ORGANIZATION_ID , MCR.CROSS_REFERENCE_TYPE , MCR.CROSS_REFERENCE , MCR.LAST_UPDATE_DATE , MCR.LAST_UPDATED_BY , MCR.CREATION_DATE , MCR.CREATED_BY , MCR.LAST_UPDATE_LOGIN , MCR.DESCRIPTION , MCR.ORG_INDEPENDENT_FLAG , MCR.REQUEST_ID , MCR.PROGRAM_APPLICATION_ID , MCR.PROGRAM_ID , MCR.PROGRAM_UPDATE_DATE , MCR.ATTRIBUTE1 , MCR.ATTRIBUTE2 , MCR.ATTRIBUTE3 , MCR.ATTRIBUTE4 , MCR.ATTRIBUTE5 , MCR.ATTRIBUTE6 , MCR.ATTRIBUTE7 , MCR.ATTRIBUTE8 , MCR.ATTRIBUTE9 , MCR.ATTRIBUTE10 , MCR.ATTRIBUTE11 , MCR.ATTRIBUTE12 , MCR.ATTRIBUTE13 , MCR.ATTRIBUTE14 , MCR.ATTRIBUTE15 , MCR.ATTRIBUTE_CATEGORY , MSIK.CONCATENATED_SEGMENTS INV_ITEM_CONCAT_SEGS , MSB_TL.DESCRIPTION ITEM_DESCRIPTION , ORG.ORGANIZATION_NAME ORGANIZATION_NAME , ORG.ORGANIZATION_CODE ORGANIZATION_CODE , MCR.UOM_CODE , MCR.REVISION_ID , UOM.UNIT_OF_MEASURE_TL , REV.REVISION ,MCR.CROSS_REFERENCE_ID ,MCR.EPC_GTIN_SERIAL ,MCR.SOURCE_SYSTEM_ID ,MCR.START_DATE_ACTIVE ,MCR.END_DATE_ACTIVE ,MCR.OBJECT_VERSION_NUMBER FROM MTL_CROSS_REFERENCES_VL MCR , ORG_ORGANIZATION_DEFINITIONS ORG, MTL_SYSTEM_ITEMS_B_KFV MSIK , MTL_SYSTEM_ITEMS_TL MSB_TL, MTL_UNITS_OF_MEASURE_TL UOM , MTL_ITEM_REVISIONS_B REV WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND MCR.ORGANIZATION_ID IS NOT NULL AND MCR.ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND MCR.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND MSB_TL.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND MSB_TL.ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND MSB_TL.LANGUAGE = USERENV('LANG') AND MCR.UOM_CODE = UOM.UOM_CODE ( + ) AND UOM.LANGUAGE ( + ) = userenv ( 'LANG' ) AND MCR.INVENTORY_ITEM_ID = REV.INVENTORY_ITEM_ID ( + ) AND MCR.ORGANIZATION_ID = REV.ORGANIZATION_ID ( + ) AND MCR.REVISION_ID = REV.REVISION_ID ( + ) UNION ALL SELECT UNIQUE MCR.ROW_ID ROW_ID , MCR.INVENTORY_ITEM_ID , MCR.ORGANIZATION_ID , MCR.CROSS_REFERENCE_TYPE , MCR.CROSS_REFERENCE , MCR.LAST_UPDATE_DATE , MCR.LAST_UPDATED_BY , MCR.CREATION_DATE , MCR.CREATED_BY , MCR.LAST_UPDATE_LOGIN , MCR.DESCRIPTION , MCR.ORG_INDEPENDENT_FLAG , MCR.REQUEST_ID , MCR.PROGRAM_APPLICATION_ID , MCR.PROGRAM_ID , MCR.PROGRAM_UPDATE_DATE , MCR.ATTRIBUTE1 , MCR.ATTRIBUTE2 , MCR.ATTRIBUTE3 , MCR.ATTRIBUTE4 , MCR.ATTRIBUTE5 , MCR.ATTRIBUTE6 , MCR.ATTRIBUTE7 , MCR.ATTRIBUTE8 , MCR.ATTRIBUTE9 , MCR.ATTRIBUTE10 , MCR.ATTRIBUTE11 , MCR.ATTRIBUTE12 , MCR.ATTRIBUTE13 , MCR.ATTRIBUTE14 , MCR.ATTRIBUTE15 , MCR.ATTRIBUTE_CATEGORY , MSIK.CONCATENATED_SEGMENTS INV_ITEM_CONCAT_SEGS , ' ' ITEM_DESCRIPTION , ' ' ORGANIZATION_NAME , ' ' ORGANIZATION_CODE , MCR.UOM_CODE , MCR.REVISION_ID , UOM.UNIT_OF_MEASURE_TL , ' ' REVISION_ID , MCR.CROSS_REFERENCE_ID , MCR.EPC_GTIN_SERIAL , MCR.SOURCE_SYSTEM_ID , MCR.START_DATE_ACTIVE , MCR.END_DATE_ACTIVE , MCR.OBJECT_VERSION_NUMBER FROM MTL_CROSS_REFERENCES_VL MCR , MTL_SYSTEM_ITEMS_B_KFV MSIK , MTL_UNITS_OF_MEASURE_TL UOM , MTL_PARAMETERS MP WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND MCR.ORGANIZATION_ID IS NULL AND MP.MASTER_ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.MASTER_ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND MCR.UOM_CODE = UOM.UOM_CODE ( + ) AND UOM.LANGUAGE ( + ) = userenv ( 'LANG' )

View Text - HTML Formatted

SELECT MCR.ROW_ID ROW_ID
, MCR.INVENTORY_ITEM_ID
, MCR.ORGANIZATION_ID
, MCR.CROSS_REFERENCE_TYPE
, MCR.CROSS_REFERENCE
, MCR.LAST_UPDATE_DATE
, MCR.LAST_UPDATED_BY
, MCR.CREATION_DATE
, MCR.CREATED_BY
, MCR.LAST_UPDATE_LOGIN
, MCR.DESCRIPTION
, MCR.ORG_INDEPENDENT_FLAG
, MCR.REQUEST_ID
, MCR.PROGRAM_APPLICATION_ID
, MCR.PROGRAM_ID
, MCR.PROGRAM_UPDATE_DATE
, MCR.ATTRIBUTE1
, MCR.ATTRIBUTE2
, MCR.ATTRIBUTE3
, MCR.ATTRIBUTE4
, MCR.ATTRIBUTE5
, MCR.ATTRIBUTE6
, MCR.ATTRIBUTE7
, MCR.ATTRIBUTE8
, MCR.ATTRIBUTE9
, MCR.ATTRIBUTE10
, MCR.ATTRIBUTE11
, MCR.ATTRIBUTE12
, MCR.ATTRIBUTE13
, MCR.ATTRIBUTE14
, MCR.ATTRIBUTE15
, MCR.ATTRIBUTE_CATEGORY
, MSIK.CONCATENATED_SEGMENTS INV_ITEM_CONCAT_SEGS
, MSB_TL.DESCRIPTION ITEM_DESCRIPTION
, ORG.ORGANIZATION_NAME ORGANIZATION_NAME
, ORG.ORGANIZATION_CODE ORGANIZATION_CODE
, MCR.UOM_CODE
, MCR.REVISION_ID
, UOM.UNIT_OF_MEASURE_TL
, REV.REVISION
, MCR.CROSS_REFERENCE_ID
, MCR.EPC_GTIN_SERIAL
, MCR.SOURCE_SYSTEM_ID
, MCR.START_DATE_ACTIVE
, MCR.END_DATE_ACTIVE
, MCR.OBJECT_VERSION_NUMBER
FROM MTL_CROSS_REFERENCES_VL MCR
, ORG_ORGANIZATION_DEFINITIONS ORG
, MTL_SYSTEM_ITEMS_B_KFV MSIK
, MTL_SYSTEM_ITEMS_TL MSB_TL
, MTL_UNITS_OF_MEASURE_TL UOM
, MTL_ITEM_REVISIONS_B REV
WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MCR.ORGANIZATION_ID IS NOT NULL
AND MCR.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MCR.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND MSB_TL.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MSB_TL.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MSB_TL.LANGUAGE = USERENV('LANG')
AND MCR.UOM_CODE = UOM.UOM_CODE ( + )
AND UOM.LANGUAGE ( + ) = USERENV ( 'LANG' )
AND MCR.INVENTORY_ITEM_ID = REV.INVENTORY_ITEM_ID ( + )
AND MCR.ORGANIZATION_ID = REV.ORGANIZATION_ID ( + )
AND MCR.REVISION_ID = REV.REVISION_ID ( + ) UNION ALL SELECT UNIQUE MCR.ROW_ID ROW_ID
, MCR.INVENTORY_ITEM_ID
, MCR.ORGANIZATION_ID
, MCR.CROSS_REFERENCE_TYPE
, MCR.CROSS_REFERENCE
, MCR.LAST_UPDATE_DATE
, MCR.LAST_UPDATED_BY
, MCR.CREATION_DATE
, MCR.CREATED_BY
, MCR.LAST_UPDATE_LOGIN
, MCR.DESCRIPTION
, MCR.ORG_INDEPENDENT_FLAG
, MCR.REQUEST_ID
, MCR.PROGRAM_APPLICATION_ID
, MCR.PROGRAM_ID
, MCR.PROGRAM_UPDATE_DATE
, MCR.ATTRIBUTE1
, MCR.ATTRIBUTE2
, MCR.ATTRIBUTE3
, MCR.ATTRIBUTE4
, MCR.ATTRIBUTE5
, MCR.ATTRIBUTE6
, MCR.ATTRIBUTE7
, MCR.ATTRIBUTE8
, MCR.ATTRIBUTE9
, MCR.ATTRIBUTE10
, MCR.ATTRIBUTE11
, MCR.ATTRIBUTE12
, MCR.ATTRIBUTE13
, MCR.ATTRIBUTE14
, MCR.ATTRIBUTE15
, MCR.ATTRIBUTE_CATEGORY
, MSIK.CONCATENATED_SEGMENTS INV_ITEM_CONCAT_SEGS
, ' ' ITEM_DESCRIPTION
, ' ' ORGANIZATION_NAME
, ' ' ORGANIZATION_CODE
, MCR.UOM_CODE
, MCR.REVISION_ID
, UOM.UNIT_OF_MEASURE_TL
, ' ' REVISION_ID
, MCR.CROSS_REFERENCE_ID
, MCR.EPC_GTIN_SERIAL
, MCR.SOURCE_SYSTEM_ID
, MCR.START_DATE_ACTIVE
, MCR.END_DATE_ACTIVE
, MCR.OBJECT_VERSION_NUMBER
FROM MTL_CROSS_REFERENCES_VL MCR
, MTL_SYSTEM_ITEMS_B_KFV MSIK
, MTL_UNITS_OF_MEASURE_TL UOM
, MTL_PARAMETERS MP
WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MCR.ORGANIZATION_ID IS NULL
AND MP.MASTER_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.MASTER_ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MCR.UOM_CODE = UOM.UOM_CODE ( + )
AND UOM.LANGUAGE ( + ) = USERENV ( 'LANG' )