VIEW: APPS.AMS_DS_GROUP_ACCESSES_ALL_V

Source

View Text - Preformatted

SELECT DISTINCT acc.CUSTOMER_ID, grp.GROUP_ID, grp.GROUP_NAME from PER_PEOPLE_X people , AS_ACCESSES_ALL acc , JTF_RS_GROUPS_VL grp WHERE acc.person_id = people.person_id(+) and trunc(sysdate) between people.effective_start_date(+) and people.effective_end_date(+) and acc.sales_group_id = grp.group_id and acc.lead_id is null and acc.sales_lead_id is null

View Text - HTML Formatted

SELECT DISTINCT ACC.CUSTOMER_ID
, GRP.GROUP_ID
, GRP.GROUP_NAME
FROM PER_PEOPLE_X PEOPLE
, AS_ACCESSES_ALL ACC
, JTF_RS_GROUPS_VL GRP
WHERE ACC.PERSON_ID = PEOPLE.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+)
AND PEOPLE.EFFECTIVE_END_DATE(+)
AND ACC.SALES_GROUP_ID = GRP.GROUP_ID
AND ACC.LEAD_ID IS NULL
AND ACC.SALES_LEAD_ID IS NULL