[Home] [Help]
View: XNC_ORD_ORDNUMBR_NAV
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | View used to define the attribute fields for an AK object for construction of the Order Navigator tree |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT TO_CHAR(AIV.ORDER_NUMBER) ||'('|| DECODE(AIV.BOOKED_FLAG||AIV.OPEN_FLAG||AIV.CANCELLED_FLAG
, 'NYN'
, 'NEW'
, 'YYN'
, 'OPEN'
, 'YNN'
, NVL(SUBSTR(OS.STATUS
, 3
, 1)||LOWER(SUBSTR(OS.STATUS
, 4
, (LENGTH(OS.STATUS)- 3)))
, 'ERROR')
, 'NNN'
, 'INVALID'
, 'CANCELLED') ||')'LABEL
, 'ORD_NUMBER' NODE_TYPE
, TO_CHAR(AIV.ORG_ID)||'
, '||TO_CHAR(ACCT.PARTY_ID)||'
, '||TO_CHAR(AIV.HEADER_ID) NODE_KEY
, 'ROOT' PARENT_NODE_TYPE
, 'AFFLDHDR' ICON_NAME
, 'XNC_ORDERS_NUMBER' PARENT_NODE_KEY
, 'Y' LEAF_FLAG
FROM OE_ORDER_HEADERS_ALL AIV
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
, HZ_CUST_ACCOUNT_ROLES HCAR
, XNC_ORDER_STATUS_V OS
WHERE OS.ORDER_NUMBER (+) = AIV.ORDER_NUMBER
AND AIV.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID
AND AIV.SOLD_TO_CONTACT_ID = HCAR.CUST_ACCOUNT_ROLE_ID (+)
AND NVL(AIV.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) ORDER BY AIV.ORDER_NUMBER DESC
Columns
| Name |
| LABEL |
| NODE_TYPE |
| NODE_KEY |
| PARENT_NODE_TYPE |
| ICON_NAME |
| PARENT_NODE_KEY |
| LEAF_FLAG |