[Home] [Help]
View: XNC_ORD_LINE_STATUS_V
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | This view gives order line statuses for an Order . |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AOL.LINE_ID
, DECODE(CCPM.CP_STATUS
, 'LATEST'
, 'OPEN'
, 'PREPROVISION REQUESTED'
, 'OPEN'
, 'PREPROVISION SUCCEEDED'
, 'OPEN'
, 'PROVISION REQUESTED'
, 'OPEN'
, 'PROVISION SUCCEEDED'
, 'OPEN'
, 'BILLING REQUESTED'
, 'OPEN'
, 'BILLING SUCCEEDED'
, 'OPEN'
, 'COMPLETE'
, 'CLOSED'
, 'PREPROVISION FAILED'
, 'ERROR'
, 'PROVISION FAILED'
, 'ERROR'
, 'BILLING FAILED'
, 'ERROR'
, 'NEW') STATUS
FROM CS_CUSTOMER_PRODUCTS_MAINT_V CCPM
, ASO_I_OE_ORDER_LINES_V AOL
, CS_CP_REVISIONS_MAINT_V CCR
WHERE CCPM.MOST_RECENT_FLAG = 'Y'
AND AOL.LINE_ID = NVL(CCR.ORDER_LINE_ID
, CCPM.ORIGINAL_ORDER_LINE_ID)
AND CCPM.CURRENT_CP_REVISION_ID = CCR.CP_REVISION_ID(+)
Columns