View: INVFV_EXTERNAL_ITEM_XREFS

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INVFV_EXTERNAL_ITEM_XREFS

View Text

SELECT AL.NAME
, CR.CROSS_REFERENCE_TYPE
, CR.CROSS_REFERENCE
, '_KF:INV:MSTK:SY'
, CR.DESCRIPTION
, '_LA:CR.ORG_INDEPENDENT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:INV:MTL_CROSS_REFERENCES:CR'
, CR.INVENTORY_ITEM_ID
, CR.ORGANIZATION_ID
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATED_BY
, CR.CREATION_DATE
, CR.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MTL_CROSS_REFERENCES CR
WHERE CR.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND SY.ORGANIZATION_ID IN (SELECT ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS SY2
WHERE SY2.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND ROWNUM = 1)
AND CR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND '_SEC:CR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns