View: XDP_ACTION_CODES_V

Product:	XDP - Provisioning
Description:
Implementation/DBA Data:	APPS.XDP_ACTION_CODES_V

View Text

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'

Columns