View: XDP_OE_ORDER_DETAILS_V

Product:	XDP - Provisioning
Description:	This view contains the details for a particular order.
Implementation/DBA Data:	APPS.XDP_OE_ORDER_DETAILS_V

View Text

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' )

Columns