VIEW: APPS.XDP_ACTION_CODES_V

Source

View Text - Preformatted

SELECT to_char(ott.transaction_type_id) ACTION_CODE , otl.name DISPLAY_NAME , null LOOKUP_TYPE , 'SALES' ACTION_SOURCE , ott.org_id ORG_ID FROM oe_transaction_types_all ott , oe_transaction_types_tl otl WHERE ott.transaction_type_code = 'LINE' AND ott.order_category_code = 'ORDER' AND ott.start_date_active <= sysdate AND NVL(ott.end_date_active,sysdate) >= sysdate AND ott.transaction_type_id = otl.transaction_type_id AND otl.language = userenv('LANG') UNION SELECT xdp.lookup_code ACTION_CODE , xdp.meaning DISPLAY_NAME , xdp.lookup_type LOOKUP_TYPE , 'XDP' ACTION_SOURCE , to_number('') ORG_ID FROM fnd_lookups xdp WHERE xdp.lookup_type = 'XDP_ACTIONS'

View Text - HTML Formatted

SELECT TO_CHAR(OTT.TRANSACTION_TYPE_ID) ACTION_CODE
, OTL.NAME DISPLAY_NAME
, NULL LOOKUP_TYPE
, 'SALES' ACTION_SOURCE
, OTT.ORG_ID ORG_ID
FROM OE_TRANSACTION_TYPES_ALL OTT
, OE_TRANSACTION_TYPES_TL OTL
WHERE OTT.TRANSACTION_TYPE_CODE = 'LINE'
AND OTT.ORDER_CATEGORY_CODE = 'ORDER'
AND OTT.START_DATE_ACTIVE <= SYSDATE
AND NVL(OTT.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND OTT.TRANSACTION_TYPE_ID = OTL.TRANSACTION_TYPE_ID
AND OTL.LANGUAGE = USERENV('LANG') UNION SELECT XDP.LOOKUP_CODE ACTION_CODE
, XDP.MEANING DISPLAY_NAME
, XDP.LOOKUP_TYPE LOOKUP_TYPE
, 'XDP' ACTION_SOURCE
, TO_NUMBER('') ORG_ID
FROM FND_LOOKUPS XDP
WHERE XDP.LOOKUP_TYPE = 'XDP_ACTIONS'