[Home] [Help]
View: XNC_IB_ACTIVE_ACCT_NAV
Product: | XNC - Sales for Communications (Obsolete) |
Description: | This view is used in Install Base Navigator tree to display active accounts. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ACCOUNT LABEL
, 'INSTALL_ACTIVE_ACCOUNTS' NODE_TYPE
, ACCOUNT||'
, '||PARTY_ID NODE_KEY
, 'AFFLDHDR' ICON_NAME
, 'N' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, 'XNC_INSTALL_ACTIVE' PARENT_NODE_KEY
FROM XNC_IB_ACTIVE_ACCT_V
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |