VIEW: APPS.XDP_OE_ORDER_DETAILS_V

Source

View Text - Preformatted

SELECT XOEH.ORDER_NUMBER ORDER_NUMBER, XOEH.ORDER_VERSION ORDER_VERSION, XOEL.LINE_NUMBER LINE_NUMBER, XOEL.LINE_ITEM_NAME LINE_ITEM_NAME, XOEL.LINE_ITEM_VERSION LINE_ITEM_VERSION, XOEL.LINE_ITEM_TYPE LINE_ITEM_TYPE, XOEL.IS_WORKITEM_FLAG IS_WORK_ITEM_FLAG, XOEL.PROVISIONING_REQUIRED_FLAG PROVISIONING_REQUIRED_FLAG, XOEH.PROVISIONING_DATE ORDER_PROVISIONING_DATE, XOEL.PROVISIONING_DATE LINE_PROVISIONING_DATE, XOEL.PROVISIONING_SEQUENCE PROVISIONING_SEQUENCE, XOEH.ORDER_TYPE ORDER_TYPE, XOEH.ORDER_ACTION ORDER_ACTION, XOEL.LINE_ITEM_ACTION LINE_ITEM_ACTION, XOEH.ORDER_SOURCE ORDER_SOURCE, XOEH.PRIORITY ORDER_PRIORITY, XOEL.PRIORITY LINE_PRIORITY, XOEH.STATUS ORDER_STATUS, XOEL.STATUS LINE_STATUS, XOEH.SDP_ORDER_ID SDP_ORDER_ID, XOEH.DUE_DATE ORDER_DUE_DATE, XOEL.DUE_DATE LINE_DUE_DATE, XOEH.CUSTOMER_REQUIRED_DATE ORDER_CUSTOMER_REQUIRED_DATE, XOEL.CUSTOMER_REQUIRED_DATE LINE_CUSTOMER_REQUIRED_DATE, XOEH.CUSTOMER_NAME CUSTOMER_NAME, XOEH.CUSTOMER_ID CUSTOMER_ID, XOEH.ORG_ID ORG_ID, XOEH.SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID, XOEH.TELEPHONE_NUMBER TELEPHONE_NUMBER, XOEH.RELATED_ORDER_ID RELATED_ORDER_ID, XOEH.SP_ORDER_NUMBER SP_ORDER_NUMBER, XOEH.SP_USERID SP_USERID, XOEH.ORDER_REF_NAME ORDER_REF_NAME, XOEH.ORDER_REF_VALUE ORDER_REF_VALUE, XOEL.STARTING_NUMBER STARTING_NUMBER, XOEL.ENDING_NUMBER ENDING_NUMBER FROM XDP_OE_ORDER_HEADERS XOEH, XDP_OE_ORDER_LINES XOEL WHERE XOEH.ORDER_NUMBER = XOEL.ORDER_NUMBER AND NVL( XOEH.ORDER_VERSION, 'X' ) = NVL( XOEL.ORDER_VERSION, 'X' )

View Text - HTML Formatted

SELECT XOEH.ORDER_NUMBER ORDER_NUMBER
, XOEH.ORDER_VERSION ORDER_VERSION
, XOEL.LINE_NUMBER LINE_NUMBER
, XOEL.LINE_ITEM_NAME LINE_ITEM_NAME
, XOEL.LINE_ITEM_VERSION LINE_ITEM_VERSION
, XOEL.LINE_ITEM_TYPE LINE_ITEM_TYPE
, XOEL.IS_WORKITEM_FLAG IS_WORK_ITEM_FLAG
, XOEL.PROVISIONING_REQUIRED_FLAG PROVISIONING_REQUIRED_FLAG
, XOEH.PROVISIONING_DATE ORDER_PROVISIONING_DATE
, XOEL.PROVISIONING_DATE LINE_PROVISIONING_DATE
, XOEL.PROVISIONING_SEQUENCE PROVISIONING_SEQUENCE
, XOEH.ORDER_TYPE ORDER_TYPE
, XOEH.ORDER_ACTION ORDER_ACTION
, XOEL.LINE_ITEM_ACTION LINE_ITEM_ACTION
, XOEH.ORDER_SOURCE ORDER_SOURCE
, XOEH.PRIORITY ORDER_PRIORITY
, XOEL.PRIORITY LINE_PRIORITY
, XOEH.STATUS ORDER_STATUS
, XOEL.STATUS LINE_STATUS
, XOEH.SDP_ORDER_ID SDP_ORDER_ID
, XOEH.DUE_DATE ORDER_DUE_DATE
, XOEL.DUE_DATE LINE_DUE_DATE
, XOEH.CUSTOMER_REQUIRED_DATE ORDER_CUSTOMER_REQUIRED_DATE
, XOEL.CUSTOMER_REQUIRED_DATE LINE_CUSTOMER_REQUIRED_DATE
, XOEH.CUSTOMER_NAME CUSTOMER_NAME
, XOEH.CUSTOMER_ID CUSTOMER_ID
, XOEH.ORG_ID ORG_ID
, XOEH.SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID
, XOEH.TELEPHONE_NUMBER TELEPHONE_NUMBER
, XOEH.RELATED_ORDER_ID RELATED_ORDER_ID
, XOEH.SP_ORDER_NUMBER SP_ORDER_NUMBER
, XOEH.SP_USERID SP_USERID
, XOEH.ORDER_REF_NAME ORDER_REF_NAME
, XOEH.ORDER_REF_VALUE ORDER_REF_VALUE
, XOEL.STARTING_NUMBER STARTING_NUMBER
, XOEL.ENDING_NUMBER ENDING_NUMBER
FROM XDP_OE_ORDER_HEADERS XOEH
, XDP_OE_ORDER_LINES XOEL
WHERE XOEH.ORDER_NUMBER = XOEL.ORDER_NUMBER
AND NVL( XOEH.ORDER_VERSION
, 'X' ) = NVL( XOEL.ORDER_VERSION
, 'X' )