View: XDP_ADAPTER_JOB_QUEUE_V

Product:	XDP - Provisioning
Description:	This view is used as an internal queue table. When the Fulfillment Action(FA) workflow tries to execute a fulfillment procedure(FP) for fulfillment on a fulfillment element(FE), the workflow has to first allocate a free adapter for the t
Implementation/DBA Data:	APPS.XDP_ADAPTER_JOB_QUEUE_V

View Text

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)

Columns