VIEW: APPS.XDP_READY_FES_V

Source

View Text - Preformatted

SELECT FE.FULFILLMENT_ELEMENT_NAME FENAME ,FE.FE_ID FE_ID ,FARL.FA_INSTANCE_ID FANAME ,FARL.WORKITEM_INSTANCE_ID WORKITEM ,OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID ,OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION ,OH.ORDER_ID INTERNAL_ORDER_ID ,WCQ.ENQ_TIME QUEUED_ON ,FW.DUE_DATE DUE_DATE ,WCQ.PRIORITY PRIORITY ,XWVL.DISPLAY_NAME WORKITEM_DISPLAY ,XFAVL.DISPLAY_NAME FANAME_DISPLAY ,FE.DISPLAY_NAME FENAME_DISPLAY FROM XDP_FULFILL_ACTIONS_VL XFAVL ,XDP_WORKITEMS_VL XWVL ,XDP_FULFILL_WORKLIST FW ,XDP_ORDER_HEADERS OH ,XDP_FA_RUNTIME_LIST FARL ,XDP_FES_VL FE ,XDP_WF_CHANNEL_QTAB WCQ WHERE FE.FULFILLMENT_ELEMENT_NAME = XDP_SYSCN_UTIL.GET_Q_DATA_CHAR(WCQ.USER_DATA, 'FE_NAME') AND FARL.FA_INSTANCE_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM(WCQ.USER_DATA,'FA_INSTANCE_ID') AND FARL.WORKITEM_INSTANCE_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM(WCQ.USER_DATA,'WORKITEM_INSTANCE_ID') AND OH.ORDER_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM(WCQ.USER_DATA,'ORDER_ID') AND FW.WORKITEM_INSTANCE_ID = FARL.WORKITEM_INSTANCE_ID AND XWVL.WORKITEM_ID = FW.WORKITEM_ID AND XFAVL.FULFILLMENT_ACTION_ID = FARL.FULFILLMENT_ACTION_ID

View Text - HTML Formatted

SELECT FE.FULFILLMENT_ELEMENT_NAME FENAME
, FE.FE_ID FE_ID
, FARL.FA_INSTANCE_ID FANAME
, FARL.WORKITEM_INSTANCE_ID WORKITEM
, OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID
, OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION
, OH.ORDER_ID INTERNAL_ORDER_ID
, WCQ.ENQ_TIME QUEUED_ON
, FW.DUE_DATE DUE_DATE
, WCQ.PRIORITY PRIORITY
, XWVL.DISPLAY_NAME WORKITEM_DISPLAY
, XFAVL.DISPLAY_NAME FANAME_DISPLAY
, FE.DISPLAY_NAME FENAME_DISPLAY
FROM XDP_FULFILL_ACTIONS_VL XFAVL
, XDP_WORKITEMS_VL XWVL
, XDP_FULFILL_WORKLIST FW
, XDP_ORDER_HEADERS OH
, XDP_FA_RUNTIME_LIST FARL
, XDP_FES_VL FE
, XDP_WF_CHANNEL_QTAB WCQ
WHERE FE.FULFILLMENT_ELEMENT_NAME = XDP_SYSCN_UTIL.GET_Q_DATA_CHAR(WCQ.USER_DATA
, 'FE_NAME')
AND FARL.FA_INSTANCE_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM(WCQ.USER_DATA
, 'FA_INSTANCE_ID')
AND FARL.WORKITEM_INSTANCE_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM(WCQ.USER_DATA
, 'WORKITEM_INSTANCE_ID')
AND OH.ORDER_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM(WCQ.USER_DATA
, 'ORDER_ID')
AND FW.WORKITEM_INSTANCE_ID = FARL.WORKITEM_INSTANCE_ID
AND XWVL.WORKITEM_ID = FW.WORKITEM_ID
AND XFAVL.FULFILLMENT_ACTION_ID = FARL.FULFILLMENT_ACTION_ID