Product: | XDP - Provisioning |
---|---|
Description: | Stores configuration data pertaining to all Adapters |
Implementation/DBA Data: |
![]() |
SELECT ADP.CHANNEL_NAME
, ADP.ADAPTER_NAME
, ADP.ADAPTER_DISPLAY_NAME
, FE.FE_ID
, FE.FULFILLMENT_ELEMENT_NAME
, FE.DISPLAY_NAME
, FND.TARGET_NODE
, ADP.PROCESS_ID
, ADP.ADAPTER_STATUS
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_STATUS'
AND FL.LOOKUP_CODE = ADP.ADAPTER_STATUS ) ADAPTER_STATUS_DISPLAY
, ADP.WF_ITEM_TYPE
, ADP.WF_ITEM_KEY
, ADP.WF_ACTIVITY_NAME
, ADP.CONNECT_ON_DEMAND_FLAG
, ADP.MAX_IDLE_TIME_MINUTES
, ADP.LOG_FILE_NAME
, ADT.ADAPTER_TYPE
, ADT.DISPLAY_NAME ADAPTER_TYPE_DISPLAY
, ADP.ADAPTER_STATUS
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_STATUS'
AND FL.LOOKUP_CODE = ADP.ADAPTER_STATUS ) STATUS_MEANING
, ADP.USAGE_CODE
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_USAGE_CODE'
AND FL.LOOKUP_CODE = ADP.USAGE_CODE ) USAGE_CODE_DISPAY
, ADP.STARTUP_MODE
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_STARTUP_MODE'
AND FL.LOOKUP_CODE = ADP.STARTUP_MODE ) STARTUP_MODE_DISPLAY
, ADP.LOG_LEVEL
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'AFLOG_LEVELS'
AND FL.LOOKUP_CODE = ADP.LOG_LEVEL) LOG_LEVEL_DISPLAY
, ADP.SEQ_IN_FE
, ADP.SERVICE_INSTANCE_ID
, ADP.CMD_LINE_OPTIONS
, ADP.CMD_LINE_ARGS
, ADP.LAST_VERIFIED_TIME
, ADP.STATUS_ACTIVE_TIME
, ADP.APPLICATION_ID
, ADP.OBJECT_VERSION_NUMBER
FROM XDP_ADAPTER_REG ADP
, XDP_FES_VL FE
, XDP_ADAPTER_TYPES_VL ADT
, FND_CONCURRENT_QUEUES FND
WHERE ADP.FE_ID = FE.FE_ID
AND ADP.ADAPTER_TYPE = ADT.ADAPTER_TYPE
AND ADP.SERVICE_INSTANCE_ID = FND.CONCURRENT_QUEUE_ID
AND ADP.APPLICATION_ID = FND.APPLICATION_ID