[Home] [Help]
View: XNC_ORD_ORDERTYP_NAV
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | View used to define the attribute fields for an AK object for construction of the Order Navigator tree |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT '1-NEW' NODE_KEY
, 'NEW ORDERS' LABEL
, 'ORDER_TYPE' NODE_TYPE
, 'ROOT' PARENT_NODE_TYPE
, NT.ICON_NAME
, NT.ROOT_KEY PARENT_NODE_KEY
, 'N' LEAF_FLAG
FROM XNC_NAV_NODE_TYPES_V NT
, DUAL
WHERE NT.NODE_TYPE = 'ORDER_TYPE'
AND NT.ROOT_KEY = 'XNC_ORDERS_STATUS' UNION SELECT '2-OPEN' NODE_KEY
, 'OPEN ORDERS' LABEL
, 'ORDER_TYPE' NODE_TYPE
, 'ROOT' PARENT_NODE_TYPE
, NT.ICON_NAME
, NT.ROOT_KEY PARENT_NODE_KEY
, 'N' LEAF_FLAG
FROM XNC_NAV_NODE_TYPES_V NT
, DUAL
WHERE NT.NODE_TYPE = 'ORDER_TYPE'
AND NT.ROOT_KEY = 'XNC_ORDERS_STATUS' UNION SELECT '3-ERROR' NODE_KEY
, 'ERROR ORDERS' LABEL
, 'ORDER_TYPE' NODE_TYPE
, 'ROOT' PARENT_NODE_TYPE
, NT.ICON_NAME
, NT.ROOT_KEY PARENT_NODE_KEY
, 'N' LEAF_FLAG
FROM XNC_NAV_NODE_TYPES_V NT
, DUAL
WHERE NT.NODE_TYPE = 'ORDER_TYPE'
AND NT.ROOT_KEY = 'XNC_ORDERS_STATUS' UNION SELECT '4-CANCELLED' NODE_KEY
, 'CANCELLED ORDERS' LABEL
, 'ORDER_TYPE' NODE_TYPE
, 'ROOT' PARENT_NODE_TYPE
, NT.ICON_NAME
, NT.ROOT_KEY PARENT_NODE_KEY
, 'N' LEAF_FLAG
FROM XNC_NAV_NODE_TYPES_V NT
, DUAL
WHERE NT.NODE_TYPE = 'ORDER_TYPE'
AND NT.ROOT_KEY = 'XNC_ORDERS_STATUS' UNION SELECT '5-CLOSED' NODE_KEY
, 'CLOSED ORDERS' LABEL
, 'ORDER_TYPE' NODE_TYPE
, 'ROOT' PARENT_NODE_TYPE
, NT.ICON_NAME
, NT.ROOT_KEY PARENT_NODE_KEY
, 'N' LEAF_FLAG
FROM XNC_NAV_NODE_TYPES_V NT
, DUAL
WHERE NT.NODE_TYPE = 'ORDER_TYPE'
AND NT.ROOT_KEY = 'XNC_ORDERS_STATUS'
Columns
| Name |
| NODE_KEY |
| LABEL |
| NODE_TYPE |
| PARENT_NODE_TYPE |
| ICON_NAME |
| PARENT_NODE_KEY |
| LEAF_FLAG |