VIEW: APPS.CN_SRP_COMP_GROUPS_V

Source

View Text - Preformatted

SELECT jrs.org_id, jgm.role_relate_id srp_comp_group_id, jgm.role_relate_id srp_role_id, jgm.group_id comp_group_id, jgm.resource_id, jrs.salesrep_id, jgm.role_id, jgm.role_name, jgm.role_desc, jgm.member_flag, jgm.admin_flag, jgm.manager_flag, jgm.lead_flag, jgm.start_date_active, jgm.end_date_active FROM jtf_rs_group_mbr_role_vl jgm, jtf_rs_salesreps_mo_v jrs, cn_comp_groups ccg, jtf_rs_roles_b rb WHERE (jgm.member_flag='Y' or jgm.manager_flag = 'Y') AND jrs.resource_id=jgm.resource_id and ccg.comp_group_id = jgm.group_id AND rb.role_id = jgm.role_id AND rb.role_type_code = 'SALES_COMP'

View Text - HTML Formatted

SELECT JRS.ORG_ID
, JGM.ROLE_RELATE_ID SRP_COMP_GROUP_ID
, JGM.ROLE_RELATE_ID SRP_ROLE_ID
, JGM.GROUP_ID COMP_GROUP_ID
, JGM.RESOURCE_ID
, JRS.SALESREP_ID
, JGM.ROLE_ID
, JGM.ROLE_NAME
, JGM.ROLE_DESC
, JGM.MEMBER_FLAG
, JGM.ADMIN_FLAG
, JGM.MANAGER_FLAG
, JGM.LEAD_FLAG
, JGM.START_DATE_ACTIVE
, JGM.END_DATE_ACTIVE
FROM JTF_RS_GROUP_MBR_ROLE_VL JGM
, JTF_RS_SALESREPS_MO_V JRS
, CN_COMP_GROUPS CCG
, JTF_RS_ROLES_B RB
WHERE (JGM.MEMBER_FLAG='Y' OR JGM.MANAGER_FLAG = 'Y')
AND JRS.RESOURCE_ID=JGM.RESOURCE_ID
AND CCG.COMP_GROUP_ID = JGM.GROUP_ID
AND RB.ROLE_ID = JGM.ROLE_ID
AND RB.ROLE_TYPE_CODE = 'SALES_COMP'