[Home] [Help]
View: XNC_PRICELINES_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(MSV.PADDED_CONCATENATED_SEGMENTS
, 1
, 78) LABEL
, 'PRICELINE' NODE_TYPE
, '"'||MSV.ORGANIZATION_ID||'"
, "'||MSV.INVENTORY_ITEM_ID||'"
, "'||LA.LIST_LINE_ID||'"
, "' ||H.NODE_ID||'"' NODE_KEY
, NT.ICON_NAME
, 'Y' LEAF_FLAG
, 'PRICELIST' PARENT_NODE_TYPE
, TO_CHAR(H.NODE_ID) PARENT_NODE_KEY
FROM QP_LIST_ATTRIBUTES_V LA
, JTF_PC_HIERARCHIES H
, MTL_SYSTEM_ITEMS_KFV MSV
, XNC_NAV_NODE_TYPES_V NT
WHERE TRUNC(SYSDATE) BETWEEN NVL(TRUNC(LA.QPL_START_DATE_ACTIVE)
, SYSDATE-1)
AND NVL(LA.QPL_END_DATE_ACTIVE-1
, SYSDATE+1)
AND H.NODE_REFERENCE = LA.LIST_HEADER_ID
AND LA.LIST_TYPE_CODE = 'PRL'
AND LA.LIST_LINE_TYPE_CODE = 'PLL'
AND LA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND MSV.CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
AND MSV.INVENTORY_ITEM_ID = NVL(TO_NUMBER(LA.PRODUCT_ATTR_VALUE)
, -1)
AND NT.ROOT_KEY = 'CATEGS_PRICES'
AND NT.NODE_TYPE = 'PRICELINE'
Columns
| Name |
| LABEL |
| NODE_TYPE |
| NODE_KEY |
| ICON_NAME |
| LEAF_FLAG |
| PARENT_NODE_TYPE |
| PARENT_NODE_KEY |