View: AMS_DS_GROUP_ACCESSES_ALL_V

Product:	AMS - Marketing
Description:	This view gives details regarding sales group access.
Implementation/DBA Data:	APPS.AMS_DS_GROUP_ACCESSES_ALL_V

View Text

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

Columns