View: OE_AK_ITEM_IDENTIFIER_TYPE_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AK_ITEM_IDENTIFIER_TYPE_V

View Text

SELECT CROSS_REFERENCE_TYPE
, CROSS_REFERENCE_TYPE
FROM MTL_CROSS_REFERENCE_TYPES UNION SELECT LOOKUP_CODE
, MEANING
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'ITEM_IDENTIFIER_TYPE'
AND LOOKUP_CODE IN ('INT'
, 'CUST')
AND ENABLED_FLAG = 'Y'

Columns