[Home] [Help]
View: XNC_PL_ALL_NAV
Product: | XNC - Sales for Communications (Obsolete) |
Description: | View used to define the attribute fields for an AK object for construction of the Runtime Product Catalog Navigator tree |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUBSTRB(QLH.NAME
, 1
, 78) LABEL
, 'PRICELIST_ALL' NODE_TYPE
, QLH.LIST_HEADER_ID NODE_KEY
, NT.ICON_NAME
, 'N' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, 'PRICE_LISTS' PARENT_NODE_KEY
FROM QP_LIST_HEADERS_VL QLH
, XNC_NAV_NODE_TYPES_V NT
WHERE NT.NODE_TYPE = 'PRICELIST_ALL'
AND NT.ROOT_KEY = 'PRICE_LISTS'
AND LIST_TYPE_CODE = 'PRL'
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |