VIEW: APPS.OE_AK_ITEM_IDENTIFIER_TYPE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'