VIEW: APPS.XDP_ORU_ORDERS_V

Source

View Text - Preformatted

SELECT FRT.RESUBMISSION_JOB_ID , FRT.WORKITEM_INSTANCE_ID , FRT.FA_INSTANCE_ID , FRT.STATUS_CODE , OHR.EXTERNAL_ORDER_NUMBER, OHR.EXTERNAL_ORDER_VERSION , FWT.ORDER_ID , FWT.WORKITEM_ID, FRT.FULFILLMENT_ACTION_ID , FRT.FE_ID, FRT.START_PROVISIONING_DATE , FRT.COMPLETION_DATE, OLM.LINE_NUMBER, OLM.LINE_ITEM_NAME, FAW.DISPLAY_NAME, WIW.DISPLAY_NAME FROM XDP_FA_RUNTIME_LIST FRT , XDP_FULFILL_WORKLIST FWT , XDP_ORDER_HEADERS OHR , XDP_ORDER_LINE_ITEMS OLM , XDP_FULFILL_ACTIONS_VL FAW , XDP_WORKITEMS_VL WIW WHERE FRT.WORKITEM_INSTANCE_ID = FWT.WORKITEM_INSTANCE_ID AND OHR.ORDER_ID = OLM.ORDER_ID AND FWT.ORDER_ID = OHR.ORDER_ID AND FWT.LINE_ITEM_ID = OLM.LINE_ITEM_ID AND FRT.FULFILLMENT_ACTION_ID = FAW.FULFILLMENT_ACTION_ID AND FWT.WORKITEM_ID = WIW.WORKITEM_ID

View Text - HTML Formatted

SELECT FRT.RESUBMISSION_JOB_ID
, FRT.WORKITEM_INSTANCE_ID
, FRT.FA_INSTANCE_ID
, FRT.STATUS_CODE
, OHR.EXTERNAL_ORDER_NUMBER
, OHR.EXTERNAL_ORDER_VERSION
, FWT.ORDER_ID
, FWT.WORKITEM_ID
, FRT.FULFILLMENT_ACTION_ID
, FRT.FE_ID
, FRT.START_PROVISIONING_DATE
, FRT.COMPLETION_DATE
, OLM.LINE_NUMBER
, OLM.LINE_ITEM_NAME
, FAW.DISPLAY_NAME
, WIW.DISPLAY_NAME
FROM XDP_FA_RUNTIME_LIST FRT
, XDP_FULFILL_WORKLIST FWT
, XDP_ORDER_HEADERS OHR
, XDP_ORDER_LINE_ITEMS OLM
, XDP_FULFILL_ACTIONS_VL FAW
, XDP_WORKITEMS_VL WIW
WHERE FRT.WORKITEM_INSTANCE_ID = FWT.WORKITEM_INSTANCE_ID
AND OHR.ORDER_ID = OLM.ORDER_ID
AND FWT.ORDER_ID = OHR.ORDER_ID
AND FWT.LINE_ITEM_ID = OLM.LINE_ITEM_ID
AND FRT.FULFILLMENT_ACTION_ID = FAW.FULFILLMENT_ACTION_ID
AND FWT.WORKITEM_ID = WIW.WORKITEM_ID