VIEW: APPS.XDP_ORDER_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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