[Home] [Help]
View: XNC_ORDER_LINE_STATUS_V
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | This view gives distinct order line statuses for an Order . |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT OOL.ORDER_NUMBER ORDER_NUMBER
, DECODE(CPS.NAME
, 'LATEST'
, '2-OPEN'
, 'PREPROVISION REQUESTED'
, '2-OPEN'
, 'PREPROVISION SUCCEEDED'
, '2-OPEN'
, 'PROVISION REQUESTED'
, '2-OPEN'
, 'PROVISION SUCCEEDED'
, '2-OPEN'
, 'BILLING REQUESTED'
, '2-OPEN'
, 'BILLING SUCCEEDED'
, '2-OPEN'
, 'COMPLETE'
, '5-CLOSED'
, 'PREPROVISION FAILED'
, '6-ERROR'
, 'PROVISION FAILED'
, '6-ERROR'
, 'BILLING FAILED'
, '6-ERROR'
, '1-NEW') STATUS
FROM CS_CUSTOMER_PRODUCTS_ALL CP
, ASO_I_OE_ORDER_LINES_V AOL
, CS_CP_REVISIONS R
, CS_CUSTOMER_PRODUCT_STATUSES CPS
, OE_ORDER_HEADERS_ALL OOL
WHERE CP.MOST_RECENT_FLAG = 'Y'
AND CP.CUSTOMER_PRODUCT_ID = R.CUSTOMER_PRODUCT_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID
AND AOL.LINE_ID = NVL(R.ORDER_LINE_ID
, CP.ORIGINAL_ORDER_LINE_ID)
AND OOL.HEADER_ID =AOL.HEADER_ID
Columns