VIEW: APPS.XDP_READY_FAS_V

Source

View Text - Preformatted

SELECT XDP_SYSCN_UTIL.GET_Q_DATA_NUM( FQ.USER_DATA, 'FA_INSTANCE_ID' ) FANAME ,FRL.WORKITEM_INSTANCE_ID WORKITEM ,OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID ,OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION ,FW.ORDER_ID INTERNAL_ORDER_ID ,FQ.ENQ_TIME QUEUED_ON ,FW.DUE_DATE DUE_DATE ,FW.PROVISIONING_DATE PROVISIONING_DATE ,FQ.PRIORITY PRIORITY ,XWVL.DISPLAY_NAME WORKITEM_DISPLAY ,XFAVL.DISPLAY_NAME FANAME_DISPLAY FROM XDP_FULFILL_ACTIONS_VL XFAVL ,XDP_WORKITEMS_VL XWVL ,XDP_ORDER_HEADERS OH ,XDP_FULFILL_WORKLIST FW ,XDP_FA_RUNTIME_LIST FRL ,XDP_FA_QTAB FQ WHERE FRL.FA_INSTANCE_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM( FQ.USER_DATA, 'FA_INSTANCE_ID' ) AND FQ.MSGID = FRL.MSGID AND FW.WORKITEM_INSTANCE_ID = FRL.WORKITEM_INSTANCE_ID AND OH.ORDER_ID = FW.ORDER_ID AND XWVL.WORKITEM_ID = FW.WORKITEM_ID AND XFAVL.FULFILLMENT_ACTION_ID = FRL.FULFILLMENT_ACTION_ID

View Text - HTML Formatted

SELECT XDP_SYSCN_UTIL.GET_Q_DATA_NUM( FQ.USER_DATA
, 'FA_INSTANCE_ID' ) FANAME
, FRL.WORKITEM_INSTANCE_ID WORKITEM
, OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID
, OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION
, FW.ORDER_ID INTERNAL_ORDER_ID
, FQ.ENQ_TIME QUEUED_ON
, FW.DUE_DATE DUE_DATE
, FW.PROVISIONING_DATE PROVISIONING_DATE
, FQ.PRIORITY PRIORITY
, XWVL.DISPLAY_NAME WORKITEM_DISPLAY
, XFAVL.DISPLAY_NAME FANAME_DISPLAY
FROM XDP_FULFILL_ACTIONS_VL XFAVL
, XDP_WORKITEMS_VL XWVL
, XDP_ORDER_HEADERS OH
, XDP_FULFILL_WORKLIST FW
, XDP_FA_RUNTIME_LIST FRL
, XDP_FA_QTAB FQ
WHERE FRL.FA_INSTANCE_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM( FQ.USER_DATA
, 'FA_INSTANCE_ID' )
AND FQ.MSGID = FRL.MSGID
AND FW.WORKITEM_INSTANCE_ID = FRL.WORKITEM_INSTANCE_ID
AND OH.ORDER_ID = FW.ORDER_ID
AND XWVL.WORKITEM_ID = FW.WORKITEM_ID
AND XFAVL.FULFILLMENT_ACTION_ID = FRL.FULFILLMENT_ACTION_ID