View: XDP_ORU_ORDERS_V

Product:	XDP - Provisioning
Description:	This view contains the details of resubmitted orders.
Implementation/DBA Data:	APPS.XDP_ORU_ORDERS_V

View Text

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

Columns