VIEW: APPS.XDP_WAITING_FES_V

Source

View Text - Preformatted

SELECT AJQ.FE_ID FE_ID ,XFEVL.FULFILLMENT_ELEMENT_NAME FENAME ,AJQ.FA_INSTANCE_ID FANAME ,AJQ.WORKITEM_INSTANCE_ID WORKITEM ,OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID ,OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION ,AJQ.ORDER_ID INTERNAL_ORDER_ID ,AJQ.QUEUED_ON QUEUED_ON ,FW.DUE_DATE DUE_DATE ,XWVL.DISPLAY_NAME WORKITEM_DISPLAY ,XFAVL.DISPLAY_NAME FANAME_DISPLAY ,XFEVL.DISPLAY_NAME FENAME_DISPLAY FROM XDP_FES_VL XFEVL ,XDP_FULFILL_ACTIONS_VL XFAVL ,XDP_WORKITEMS_VL XWVL ,XDP_ORDER_HEADERS OH ,XDP_FULFILL_WORKLIST FW ,XDP_ADAPTER_JOB_QUEUE AJQ ,XDP_FA_RUNTIME_LIST XFARL WHERE FW.WORKITEM_INSTANCE_ID = AJQ.WORKITEM_INSTANCE_ID AND OH.ORDER_ID = FW.ORDER_ID AND OH.ORDER_ID = AJQ.ORDER_ID AND XWVL.WORKITEM_ID = FW.WORKITEM_ID AND XFAVL.FULFILLMENT_ACTION_ID = XFARL.FULFILLMENT_ACTION_ID AND XFARL.FA_INSTANCE_ID = AJQ.FA_INSTANCE_ID AND XFEVL.FE_ID = AJQ.FE_ID

View Text - HTML Formatted

SELECT AJQ.FE_ID FE_ID
, XFEVL.FULFILLMENT_ELEMENT_NAME FENAME
, AJQ.FA_INSTANCE_ID FANAME
, AJQ.WORKITEM_INSTANCE_ID WORKITEM
, OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID
, OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION
, AJQ.ORDER_ID INTERNAL_ORDER_ID
, AJQ.QUEUED_ON QUEUED_ON
, FW.DUE_DATE DUE_DATE
, XWVL.DISPLAY_NAME WORKITEM_DISPLAY
, XFAVL.DISPLAY_NAME FANAME_DISPLAY
, XFEVL.DISPLAY_NAME FENAME_DISPLAY
FROM XDP_FES_VL XFEVL
, XDP_FULFILL_ACTIONS_VL XFAVL
, XDP_WORKITEMS_VL XWVL
, XDP_ORDER_HEADERS OH
, XDP_FULFILL_WORKLIST FW
, XDP_ADAPTER_JOB_QUEUE AJQ
, XDP_FA_RUNTIME_LIST XFARL
WHERE FW.WORKITEM_INSTANCE_ID = AJQ.WORKITEM_INSTANCE_ID
AND OH.ORDER_ID = FW.ORDER_ID
AND OH.ORDER_ID = AJQ.ORDER_ID
AND XWVL.WORKITEM_ID = FW.WORKITEM_ID
AND XFAVL.FULFILLMENT_ACTION_ID = XFARL.FULFILLMENT_ACTION_ID
AND XFARL.FA_INSTANCE_ID = AJQ.FA_INSTANCE_ID
AND XFEVL.FE_ID = AJQ.FE_ID