VIEW: APPS.XDP_ADAPTER_REG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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