VIEW: APPS.XDP_ADAPTER_AUDIT_V

Source

View Text - Preformatted

SELECT aud.channel_name , (SELECT meaning FROM xdp_adapter_type_req_types_v WHERE lookup_code = aud.request_type AND adapter_type = aud.adapter_type) request_type , (SELECT FL.MEANING FROM FND_LOOKUPS FL WHERE FL.LOOKUP_TYPE = 'XDP_REQUEST_STATUS' AND FL.LOOKUP_CODE = aud.request_status ) request_status , aud.requested_by_user , aud.adapter_name , (SELECT FL.MEANING FROM FND_LOOKUPS FL WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_STATUS' AND FL.LOOKUP_CODE = aud.adapter_status ) adapter_status , (SELECT FL.MEANING FROM FND_LOOKUPS FL WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_TYPE' AND FL.LOOKUP_CODE = aud.adapter_type ) adapter_type , aud.service_instance_id , aud.completion_date , aud.connect_on_demand_flag , aud.max_idle_time_minutes , aud.cmd_line_options , aud.cmd_line_args , aud.log_file_name , aud.application_id FROM xdp_adapter_audit aud

View Text - HTML Formatted

SELECT AUD.CHANNEL_NAME
, (SELECT MEANING
FROM XDP_ADAPTER_TYPE_REQ_TYPES_V
WHERE LOOKUP_CODE = AUD.REQUEST_TYPE
AND ADAPTER_TYPE = AUD.ADAPTER_TYPE) REQUEST_TYPE
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_REQUEST_STATUS'
AND FL.LOOKUP_CODE = AUD.REQUEST_STATUS ) REQUEST_STATUS
, AUD.REQUESTED_BY_USER
, AUD.ADAPTER_NAME
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_STATUS'
AND FL.LOOKUP_CODE = AUD.ADAPTER_STATUS ) ADAPTER_STATUS
, (SELECT FL.MEANING
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'XDP_ADAPTER_TYPE'
AND FL.LOOKUP_CODE = AUD.ADAPTER_TYPE ) ADAPTER_TYPE
, AUD.SERVICE_INSTANCE_ID
, AUD.COMPLETION_DATE
, AUD.CONNECT_ON_DEMAND_FLAG
, AUD.MAX_IDLE_TIME_MINUTES
, AUD.CMD_LINE_OPTIONS
, AUD.CMD_LINE_ARGS
, AUD.LOG_FILE_NAME
, AUD.APPLICATION_ID
FROM XDP_ADAPTER_AUDIT AUD