View: XDP_ADAPTER_TYPE_REQ_TYPES_V

Product:	XDP - Provisioning
Description:	Provides a view of the valid request/control operations for every adapter type
Implementation/DBA Data:	APPS.XDP_ADAPTER_TYPE_REQ_TYPES_V

View Text

SELECT SUBSTR(LOOKUP_CODE
, INSTR(LOOKUP_CODE
, ':') + 1) LOOKUP_CODE
, MEANING
, ADAPTER_TYPE
FROM FND_LOOKUPS
, XDP_ADAPTER_TYPES_B XAT
WHERE LOOKUP_TYPE = 'XDP_REQUEST_TYPE'
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)
AND (SUBSTR(LOOKUP_CODE
, 1
, INSTR(LOOKUP_CODE
, ':') - 1) IN (SELECT ADAPTER_TYPE
FROM XDP_ADAPTER_TYPES_B START WITH ADAPTER_TYPE = XAT.ADAPTER_TYPE CONNECT BY PRIOR BASE_ADAPTER_TYPE = ADAPTER_TYPE) OR LOOKUP_CODE IN ('STARTUP'
, 'SHUTDOWN'
, 'VERIFY'
, 'TERMINATE'
, 'SUSPEND'
, 'RESUME') OR (LOOKUP_CODE IN ('OPEN'
, 'CLOSE')
AND 1 = (SELECT COUNT(*)
FROM XDP_ADAPTER_TYPES_B
WHERE CONNECTION_REQUIRED_FLAG = 'Y'
AND ADAPTER_TYPE = XAT.ADAPTER_TYPE)))

Columns