[Home] [Help]
View: XNC_ORD_QUOTENUMS_NAV
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | View used to define the attribute fields for an AK object for construction of the Quote Navigator tree |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SUBSTRB(TO_CHAR(A.QUOTE_NUMBER)||' ('|| TRIM(AQS.MEANING)||')'
, 1
, 78) LABEL
, 'QUOTE_NUMBER' NODE_TYPE
, TO_CHAR(A.ORG_ID)||'
, '|| TO_CHAR(A.PARTY_ID)||'
, '|| TO_CHAR(A.QUOTE_NUMBER) NODE_KEY
, NT.ICON_NAME
, 'Y' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, NT.ROOT_KEY PARENT_NODE_KEY
FROM XNC_NAV_NODE_TYPES_V NT
, ASO_QUOTE_STATUSES_VL AQS
, ASO_QUOTE_HEADERS_ALL_V A
WHERE NT.NODE_TYPE = 'QUOTE_NUMBER'
AND NT.ROOT_KEY = 'XNC_QUOTES_NUMBER'
AND A.QUOTE_STATUS_ID = AQS.QUOTE_STATUS_ID
AND A.QUOTE_VERSION = ( SELECT MAX(B.QUOTE_VERSION)
FROM ASO_QUOTE_HEADERS_ALL_V B
WHERE B.QUOTE_NUMBER = A.QUOTE_NUMBER ) ORDER BY A.QUOTE_NUMBER DESC
Columns
| Name |
| LABEL |
| NODE_TYPE |
| NODE_KEY |
| ICON_NAME |
| LEAF_FLAG |
| PARENT_NODE_TYPE |
| PARENT_NODE_KEY |