[Home] [Help]
View: XNC_CATALOG_RUN_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(CVL.CATEGORY_NAME
, 1
, 78) LABEL
, 'CATEGORY' NODE_TYPE
, TO_CHAR(H.NODE_ID) NODE_KEY
, NT.ICON_NAME
, 'N' LEAF_FLAG
, DECODE(H.PARENT_NODE_ID
, 0
, 'ROOT'
, 'CATEGORY') PARENT_NODE_TYPE
, DECODE(H.PARENT_NODE_ID
, 0
, 'CATEGS_PRICES'
, TO_CHAR(H.PARENT_NODE_ID)) PARENT_NODE_KEY
FROM JTF_PC_HIERARCHIES H
, JTF_PC_CATEGORIES_VL CVL
, XNC_NAV_NODE_TYPES_V NT
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(H.START_DATE_EFFECTIVE)
AND NVL(H.END_DATE_EFFECTIVE-1
, SYSDATE+1)
AND H.NODE_TYPE = 'CATEGORY_NODE'
AND NT.NODE_TYPE = 'CATEGORY'
AND NT.ROOT_KEY = 'CATEGS_PRICES'
AND CVL.CATEGORY_ID = H.NODE_REFERENCE
AND TRUNC(SYSDATE) BETWEEN TRUNC(CVL.START_DATE_EFFECTIVE)
AND NVL(CVL.END_DATE_EFFECTIVE-1
, SYSDATE+1) UNION SELECT SUBSTRB(PVL.NAME
, 1
, 78) LABEL
, 'PRICELIST' NODE_TYPE
, TO_CHAR(H.NODE_ID) NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'N' LEAF_FLAG
, DECODE(H.PARENT_NODE_ID
, 0
, 'ROOT'
, 'CATEGORY') PARENT_NODE_TYPE
, DECODE(H.PARENT_NODE_ID
, 0
, 'CATEGS_PRICES'
, TO_CHAR(PARENT_NODE_ID)) PARENT_NODE_KEY
FROM JTF_PC_HIERARCHIES H
, QP_LIST_HEADERS_VL PVL
, XNC_NAV_NODE_TYPES_V NT
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(H.START_DATE_EFFECTIVE)
AND NVL(H.END_DATE_EFFECTIVE-1
, SYSDATE+1)
AND H.NODE_TYPE = 'PRICELIST_NODE'
AND NT.NODE_TYPE = 'PRICELIST'
AND NT.ROOT_KEY = 'CATEGS_PRICES'
AND PVL.LIST_HEADER_ID = H.NODE_REFERENCE
AND PVL.ACTIVE_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(PVL.START_DATE_ACTIVE)
, SYSDATE-1)
AND NVL(PVL.END_DATE_ACTIVE-1
, SYSDATE+1)
Columns
| Name |
| LABEL |
| NODE_TYPE |
| NODE_KEY |
| ICON_NAME |
| LEAF_FLAG |
| PARENT_NODE_TYPE |
| PARENT_NODE_KEY |