View: AMS_DS_ACCESSES_ALL_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_DS_ACCESSES_ALL_V

View Text

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

Columns