VIEW: APPS.CN_PLAN_ELEMENTS_NAV

Source

View Text - Preformatted

SELECT substrb(q.name,1,78) label, nt.node_type node_type, '"' || q.quota_id || '"' node_key, nt.icon_name icon_name, 'Y' leaf_flag, 'COMP_PLAN' parent_node_type, '"' || qa.comp_plan_id || '"' parent_node_key from cn_quotas q, cn_quota_assigns qa, cn_nav_node_types nt WHERE q.quota_id = qa.quota_id and nt.root_key = 'CN_COMP_PLAN_ROOT' and nt.node_type = 'PLAN_ELEMENT' UNION ALL select substrb(q.name,1,78) label, nt.node_type node_type, '"' || q.quota_id || '"' node_key, nt.icon_name icon_name, 'Y' leaf_flag, 'ROOT' parent_node_type, nt.root_key parent_node_key from cn_quotas q, cn_nav_node_types nt where nt.root_key = 'CN_PLAN_ELEMENT_ROOT' and nt.node_type = 'PLAN_ELEMENT' order by label

View Text - HTML Formatted

SELECT SUBSTRB(Q.NAME
, 1
, 78) LABEL
, NT.NODE_TYPE NODE_TYPE
, '"' || Q.QUOTA_ID || '"' NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'Y' LEAF_FLAG
, 'COMP_PLAN' PARENT_NODE_TYPE
, '"' || QA.COMP_PLAN_ID || '"' PARENT_NODE_KEY
FROM CN_QUOTAS Q
, CN_QUOTA_ASSIGNS QA
, CN_NAV_NODE_TYPES NT
WHERE Q.QUOTA_ID = QA.QUOTA_ID
AND NT.ROOT_KEY = 'CN_COMP_PLAN_ROOT'
AND NT.NODE_TYPE = 'PLAN_ELEMENT' UNION ALL SELECT SUBSTRB(Q.NAME
, 1
, 78) LABEL
, NT.NODE_TYPE NODE_TYPE
, '"' || Q.QUOTA_ID || '"' NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'Y' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, NT.ROOT_KEY PARENT_NODE_KEY
FROM CN_QUOTAS Q
, CN_NAV_NODE_TYPES NT
WHERE NT.ROOT_KEY = 'CN_PLAN_ELEMENT_ROOT'
AND NT.NODE_TYPE = 'PLAN_ELEMENT' ORDER BY LABEL