VIEW: APPS.CN_TOP_GROUPS_NAV

Source

View Text - Preformatted

SELECT g.group_id node_key, 'COMP_GROUP' node_type, g.group_name label, null icon_name, 'N' leaf_flag, null parent_node_key, null parent_node_type, g.start_date_active child_start_date, g.end_date_active child_end_date, null parent_start_date, null parent_end_date FROM jtf_rs_groups_vl g, jtf_rs_group_usages u WHERE g.group_id = u.group_id and u.usage='SALES_COMP'

View Text - HTML Formatted

SELECT G.GROUP_ID NODE_KEY
, 'COMP_GROUP' NODE_TYPE
, G.GROUP_NAME LABEL
, NULL ICON_NAME
, 'N' LEAF_FLAG
, NULL PARENT_NODE_KEY
, NULL PARENT_NODE_TYPE
, G.START_DATE_ACTIVE CHILD_START_DATE
, G.END_DATE_ACTIVE CHILD_END_DATE
, NULL PARENT_START_DATE
, NULL PARENT_END_DATE
FROM JTF_RS_GROUPS_VL G
, JTF_RS_GROUP_USAGES U
WHERE G.GROUP_ID = U.GROUP_ID
AND U.USAGE='SALES_COMP'