View: XDP_ORDER_DETAILS_V

Product:	XDP - Provisioning
Description:	This view contains an order details such as line items, work items, services and packages.
Implementation/DBA Data:	APPS.XDP_ORDER_DETAILS_V

View Text

SELECT XOH.ORDER_ID ORDER_ID
, XOH.EXTERNAL_ORDER_NUMBER ORDER_NUMBER
, XOH.EXTERNAL_ORDER_VERSION ORDER_VERSION
, XOLI.LINE_ITEM_ID LINE_ITEM_ID
, XOLI.LINE_NUMBER LINE_NUMBER
, XOLI.LINE_ITEM_NAME LINE_ITEM_NAME
, XOLI.VERSION LINE_VERSION
, XOLI.LINE_ITEM_ACTION_CODE LINE_ITEM_ACTION_CODE
, XFWL.WORKITEM_INSTANCE_ID WORKITEM_INSTANCE_ID
, XFWL.WORKITEM_ID WORKITEM_ID
, XWI.WORKITEM_NAME WORKITEM_NAME
, XWI.VERSION WORKITEM_VERSION
, XWI.WI_TYPE_CODE WI_TYPE_CODE
, XOH.STATUS_CODE ORDER_STATUS_CODE
, NULL ORDER_STATE
, XOLI.STATUS_CODE LINE_STATUS_CODE
, NULL LINE_STATE
, XFWL.STATUS_CODE WORKITEM_STATUS_CODE
, XFWL.STATE WORKITEM_STATE
, XOLI.LINE_SEQUENCE LINE_SEQUENCE
, XOLI.SEQ_IN_PACKAGE SEQ_IN_PACKAGE
, XOLI.ORGANIZATION_ID ORGANIZATION_ID
, XOLI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, XOH.PROVISIONING_DATE ORDER_PROVISIONING_DATE
, XOLI.PROVISIONING_DATE LINE_PROVISIONING_DATE
, XOH.ACTUAL_PROVISIONING_DATE ACTUAL_PROVISIONING_DATE
, XOH.COMPLETION_DATE ORDER_COMPLETION_DATE
, XOLI.COMPLETION_DATE LINE_COMPLETION_DATE
, XFWL.COMPLETION_DATE WORKITEM_COMPLETION_DATE
, XOH.CANCEL_PROVISIONING_DATE ORDER_CANCEL_PROVISIONING_DATE
, XOH.CANCELED_BY ORDER_CANCELED_BY
, XOLI.CANCEL_PROVISIONING_DATE LINE_CANCEL_PROVISIONING_DATE
, XOLI.CANCELED_BY LINE_CANCELED_BY
, XOH.HOLD_PROVISIONING_DATE ORDER_HOLD_PROVISIONING_DATE
, XOH.HELD_BY ORDER_HELD_BY
, XOLI.HOLD_PROVISIONING_DATE LINE_HOLD_PROVISIONING_DATE
, XOLI.HELD_BY LINE_HELD_BY
, XOH.RESUME_PROVISIONING_DATE ORDER_RESUME_PROVISIONING_DATE
, XOH.RESUMED_BY ORDER_RESUMED_BY
, XOLI.RESUME_PROVISIONING_DATE LINE_RESUME_PROVISIONING_DATE
, XOLI.RESUMED_BY LINE_RESUMED_BY
, XOH.DUE_DATE ORDER_DUE_DATE
, XOH.CUSTOMER_REQUIRED_DATE ORDER_CUSTOMER_REQUIRED_DATE
, XOLI.DUE_DATE LINE_DUE_DATE
, XOLI.CUSTOMER_REQUIRED_DATE LINE_CUSTOMER_REQUIRED_DATE
, NULL ORDER_ACTION
, XOH.ORDER_SOURCE ORDER_SOURCE
, XOH.CUSTOMER_ID CUSTOMER_ID
, XOH.CUSTOMER_NAME CUSTOMER_NAME
, XOH.ORG_ID ORG_ID
, NULL SERVICE_PROVIDER_ID
, XOH.TELEPHONE_NUMBER TELEPHONE_NUMBER
, XOH.PRIORITY ORDER_PRIORITY
, XOLI.PRIORITY LINE_PRIORITY
, XOH.RELATED_ORDER_ID RELATED_ORDER_ID
, XOH.ORDER_TYPE ORDER_TYPE
, XOH.NEXT_ORDER_ID NEXT_ORDER_ID
, XOH.PREVIOUS_ORDER_ID PREVIOUS_ORDER_ID
, XOH.ORDER_REF_NAME ORDER_REF_NAME
, XOH.ORDER_REF_VALUE ORDER_REF_VALUE
, NULL SP_ORDER_NUMBER
, NULL SP_USERID
, XOLI.STARTING_NUMBER STARTING_NUMBER
, XOLI.ENDING_NUMBER ENDING_NUMBER
, XWI.USER_WF_PROCESS_NAME USER_WF_PROCESS_NAME
, XFWL.WF_ITEM_TYPE WF_ITEM_TYPE
, XFWL.WF_ITEM_KEY WF_ITEM_KEY
FROM XDP_ORDER_HEADERS XOH
, XDP_ORDER_LINE_ITEMS XOLI
, XDP_FULFILL_WORKLIST XFWL
, XDP_WORKITEMS XWI
WHERE XOH.ORDER_ID = XOLI.ORDER_ID
AND XOLI.LINE_ITEM_ID = XFWL.LINE_ITEM_ID
AND XOLI.LINE_NUMBER = XFWL.LINE_NUMBER
AND XOLI.ORDER_ID = XFWL.ORDER_ID
AND XFWL.WORKITEM_ID = XWI.WORKITEM_ID

Columns