VIEW: APPS.XDP_ADAPTER_TYPE_REQ_TYPES_V

Source

View Text - Preformatted

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)))

View Text - HTML Formatted

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)))