VIEW: APPS.AMS_DS_ACCESSES_ALL_V

Source

View Text - Preformatted

SELECT acc.CUSTOMER_ID, acc.SALESFORCE_ID, grp.GROUP_ID, grp.GROUP_NAME, extns.resource_id, extns.resource_name from PER_PEOPLE_X people , JTF_RS_RESOURCE_EXTNS_vl extns , AS_ACCESSES_ALL acc , JTF_RS_GROUPS_VL grp WHERE acc.person_id = people.person_id(+) and acc.salesforce_id = extns.resource_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 ACC.CUSTOMER_ID
, ACC.SALESFORCE_ID
, GRP.GROUP_ID
, GRP.GROUP_NAME
, EXTNS.RESOURCE_ID
, EXTNS.RESOURCE_NAME
FROM PER_PEOPLE_X PEOPLE
, JTF_RS_RESOURCE_EXTNS_VL EXTNS
, AS_ACCESSES_ALL ACC
, JTF_RS_GROUPS_VL GRP
WHERE ACC.PERSON_ID = PEOPLE.PERSON_ID(+)
AND ACC.SALESFORCE_ID = EXTNS.RESOURCE_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