VIEW: APPS.CN_COMP_GROUP_SEARCH

Source

View Text - Preformatted

SELECT ccg1.comp_group_id, ccg1.name name, ccgh.parent_comp_group_id, ccg2.name parent_name, ccg1.start_date_active, ccg1.end_date_active, s.salesrep_id, s.name salesrep_name from cn_comp_group_hier ccgh, cn_comp_groups ccg1, cn_comp_groups ccg2, cn_salesreps s, jtf_rs_group_members gm WHERE ccg1.comp_group_id = ccgh.comp_group_id (+) and ccgh.parent_comp_group_id = ccg2.comp_group_id(+) and s.resource_id = gm.resource_id and gm.group_id = ccg1.comp_group_id and gm.delete_flag = 'N'

View Text - HTML Formatted

SELECT CCG1.COMP_GROUP_ID
, CCG1.NAME NAME
, CCGH.PARENT_COMP_GROUP_ID
, CCG2.NAME PARENT_NAME
, CCG1.START_DATE_ACTIVE
, CCG1.END_DATE_ACTIVE
, S.SALESREP_ID
, S.NAME SALESREP_NAME
FROM CN_COMP_GROUP_HIER CCGH
, CN_COMP_GROUPS CCG1
, CN_COMP_GROUPS CCG2
, CN_SALESREPS S
, JTF_RS_GROUP_MEMBERS GM
WHERE CCG1.COMP_GROUP_ID = CCGH.COMP_GROUP_ID (+)
AND CCGH.PARENT_COMP_GROUP_ID = CCG2.COMP_GROUP_ID(+)
AND S.RESOURCE_ID = GM.RESOURCE_ID
AND GM.GROUP_ID = CCG1.COMP_GROUP_ID
AND GM.DELETE_FLAG = 'N'