VIEW: APPS.XDP_ADAPTER_JOB_QUEUE_V

Source

View Text - Preformatted

SELECT job_id ,fe_id ,order_id ,workitem_instance_id ,fa_instance_id ,queued_on FROM xdp_adapter_job_queue AJQ1 WHERE queued_on = (SELECT MAX(AJQ2.queued_on) FROM xdp_adapter_job_queue AJQ2 where AJQ2.order_id = AJQ1.order_id and AJQ2.fe_id = AJQ1.fe_id and AJQ2.workitem_instance_id = AJQ1.workitem_instance_id)

View Text - HTML Formatted

SELECT JOB_ID
, FE_ID
, ORDER_ID
, WORKITEM_INSTANCE_ID
, FA_INSTANCE_ID
, QUEUED_ON
FROM XDP_ADAPTER_JOB_QUEUE AJQ1
WHERE QUEUED_ON = (SELECT MAX(AJQ2.QUEUED_ON)
FROM XDP_ADAPTER_JOB_QUEUE AJQ2
WHERE AJQ2.ORDER_ID = AJQ1.ORDER_ID
AND AJQ2.FE_ID = AJQ1.FE_ID
AND AJQ2.WORKITEM_INSTANCE_ID = AJQ1.WORKITEM_INSTANCE_ID)