VIEW: APPS.INVBV_CUSTOMER_ITEM_XREFS

Source

View Text - Preformatted

SELECT CUIT.CUSTOMER_ITEM_NUMBER ,'_KF:INV:MSTK:SY' , AL.NAME , PA.ORGANIZATION_CODE , CUITXR.PREFERENCE_NUMBER , '_LA:CUITXR.INACTIVE_FLAG:FND_LOOKUPS:YES_NO_REVERSE:MEANING' , CUITXR.CUSTOMER_ITEM_ID , CUITXR.INVENTORY_ITEM_ID , CUITXR.MASTER_ORGANIZATION_ID , CUITXR.CREATION_DATE , CUITXR.CREATED_BY , CUITXR.LAST_UPDATE_DATE , CUITXR.LAST_UPDATED_BY FROM MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, MTL_SYSTEM_ITEMS SY, MTL_CUSTOMER_ITEMS CUIT, MTL_CUSTOMER_ITEM_XREFS CUITXR WHERE CUITXR.CUSTOMER_ITEM_ID = CUIT.CUSTOMER_ITEM_ID AND CUITXR.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND CUITXR.MASTER_ORGANIZATION_ID = SY.ORGANIZATION_ID AND CUITXR.MASTER_ORGANIZATION_ID = AL.ORGANIZATION_ID AND CUITXR.MASTER_ORGANIZATION_ID = PA.ORGANIZATION_ID AND '_SEC:cuitxr.master_organization_id' is not null with read only

View Text - HTML Formatted

SELECT CUIT.CUSTOMER_ITEM_NUMBER
, '_KF:INV:MSTK:SY'
, AL.NAME
, PA.ORGANIZATION_CODE
, CUITXR.PREFERENCE_NUMBER
, '_LA:CUITXR.INACTIVE_FLAG:FND_LOOKUPS:YES_NO_REVERSE:MEANING'
, CUITXR.CUSTOMER_ITEM_ID
, CUITXR.INVENTORY_ITEM_ID
, CUITXR.MASTER_ORGANIZATION_ID
, CUITXR.CREATION_DATE
, CUITXR.CREATED_BY
, CUITXR.LAST_UPDATE_DATE
, CUITXR.LAST_UPDATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MTL_CUSTOMER_ITEMS CUIT
, MTL_CUSTOMER_ITEM_XREFS CUITXR
WHERE CUITXR.CUSTOMER_ITEM_ID = CUIT.CUSTOMER_ITEM_ID
AND CUITXR.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND CUITXR.MASTER_ORGANIZATION_ID = SY.ORGANIZATION_ID
AND CUITXR.MASTER_ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CUITXR.MASTER_ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:CUITXR.MASTER_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY