[Home] [Help]
View: XNC_ORD_IB_ACCT_ACT_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 DISTINCT SUBSTRB(RTRIM(LKP.MEANING)||' '||ACCOUNT_NUMBER
, 1
, 78) LABEL
, NT.NODE_TYPE NODE_TYPE
, TO_CHAR(CCP.ORG_ID)||'
, '|| TO_CHAR(HCA.PARTY_ID)||'
, '|| TO_CHAR(HCA.CUST_ACCOUNT_ID) NODE_KEY
, NT.ICON_NAME
, 'N' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, NT.ROOT_KEY PARENT_NODE_KEY
FROM FND_LOOKUP_VALUES_VL LKP
, HZ_CUST_ACCOUNTS HCA
, CS_CUSTOMER_PRODUCTS CCP
, CS_CUSTOMER_PRODUCT_STATUSES CCPS
, XNC_NAV_NODE_TYPES_V NT
WHERE NT.NODE_TYPE = 'INSTALL_ACTIVE_ACCOUNTS'
AND NT.ROOT_KEY = 'XNC_INSTALL_ACCT_A'
AND CCP.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND CCP.CUSTOMER_PRODUCT_STATUS_ID = CCPS.CUSTOMER_PRODUCT_STATUS_ID
AND CCPS.CANCELLED_FLAG = 'N'
AND CCPS.TERMINATED_FLAG = 'N'
AND CCPS.STATUS_CHANGE_ALLOWED_FLAG = 'Y'
AND CCPS.INCIDENT_ALLOWED_FLAG = 'Y'
AND CCPS.SERVICE_ORDER_ALLOWED_FLAG = 'Y'
AND LKP.VIEW_APPLICATION_ID = 532
AND LKP.LOOKUP_TYPE = 'XNC_DISPLAY_TYPE'
AND LKP.LOOKUP_CODE = 'ACCT'
Columns
| Name |
| LABEL |
| NODE_TYPE |
| NODE_KEY |
| ICON_NAME |
| LEAF_FLAG |
| PARENT_NODE_TYPE |
| PARENT_NODE_KEY |