[Home] [Help]
View: XNC_ORD_QUOTETYP_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 DISTINCT SUBSTRB(AQS.MEANING
, 1
, 78) LABEL
, 'QUOTE_TYPE' NODE_TYPE
, TO_CHAR(AQH.ORG_ID)||'
, '|| TO_CHAR(AQH.PARTY_ID)||'
, '|| TO_CHAR(AQH.QUOTE_STATUS_ID) NODE_KEY
, NT.ICON_NAME
, 'N' 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 AQH
WHERE NT.NODE_TYPE = 'QUOTE_TYPE'
AND NT.ROOT_KEY = 'XNC_QUOTES_STATUS'
AND AQH.QUOTE_STATUS_ID = AQS.QUOTE_STATUS_ID ORDER BY LABEL
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |