[Home] [Help]
View: XNC_ORD_ORDERNUM_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) LABEL
, 'ORDER_NUMBER' NODE_TYPE
, TO_CHAR(AIV.ORG_ID)||'
, '||TO_CHAR(ACCT.PARTY_ID)||'
, '||TO_CHAR(AIV.HEADER_ID) NODE_KEY
, 'ORDER_TYPE' PARENT_NODE_TYPE
, 'AFFLDHDR' ICON_NAME
, DECODE(AIV.BOOKED_FLAG||AIV.OPEN_FLAG||AIV.CANCELLED_FLAG
, 'NYN'
, '1-NEW'
, 'YYN'
, '2-OPEN'
, 'YNN'
, NVL(OS.STATUS
, '3-ERROR')
, 'NNN'
, '5-INVALID'
, '4-CANCELLED') 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 AIV.ORDER_NUMBER = OS.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 |