View: MTL_CROSS_REFERENCES_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_CROSS_REFERENCES_V

View Text

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' )

Columns