[Home] [Help]
View: XNC_ORD_IB_PRODUCT_NAV
| Product: | XNC - Sales for Communications (Obsolete) |
|---|
| Description: | View used to define the attribute fields for an AK object for construction of the Installed Base tree |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT B.DESCRIPTION LABEL
, 'INSTALL_ALL_PRODUCTS' NODE_TYPE
, INSTANCE_ID||'
, '||ACCOUNT||'
, '||PARTY_ID NODE_KEY
, DECODE(XNC_IB_ACTIVE_PRODUCTS.XNC_INSTANCE(INSTANCE_ID)
, 0
, 'AFCLPS'
, 3
, 'AFCLPS'
, 'AFFLDHDR') ICON_NAME
, DECODE(XNC_IB_ACTIVE_PRODUCTS.XNC_INSTANCE(INSTANCE_ID)
, 0
, 'Y'
, 3
, 'Y'
, 'N') LEAF_FLAG
, DECODE(XNC_IB_ACTIVE_PRODUCTS.XNC_INSTANCE(INSTANCE_ID)
, 0
, 'INSTALL_ALL_SYSTEMS'
, 1
, 'INSTALL_ALL_SYSTEMS'
, 'INSTALL_ALL_PRODUCTS') PARENT_NODE_TYPE
, DECODE(XNC_IB_ACTIVE_PRODUCTS.XNC_PARENT_ID(INSTANCE_ID)
, NULL
, DECODE(SYSTEM_ID
, NULL
, DECODE(XNC_IB_ACTIVE_PRODUCTS.XNC_SYSTEM_ID(INSTANCE_ID)
, NULL
, 'NO_SYSTEM'
, XNC_IB_ACTIVE_PRODUCTS.XNC_SYSTEM_ID(INSTANCE_ID))
, SYSTEM_ID)
, XNC_IB_ACTIVE_PRODUCTS.XNC_PARENT_ID(INSTANCE_ID))||'
, '||ACCOUNT||'
, '||PARTY_ID PARENT_NODE_KEY
FROM XNC_PARTY_ACCT_INSTANCE_H A
, MTL_SYSTEM_ITEMS_VL B
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID =B.ORGANIZATION_ID
Columns
| Name |
| LABEL |
| NODE_TYPE |
| NODE_KEY |
| ICON_NAME |
| LEAF_FLAG |
| PARENT_NODE_TYPE |
| PARENT_NODE_KEY |