Product: | AS - Sales Foundation |
---|---|
Description: | This view shows the sales reporting hierarchy information for admin |
Implementation/DBA Data: | APPS.AS_RPT_ADMINS_V |
SELECT RES.SOURCE_ID
, MEM.GROUP_ID
, GD.PARENT_GROUP_ID
, GD.IMMEDIATE_PARENT_FLAG
, GD.START_DATE_ACTIVE
, GD.END_DATE_ACTIVE
, RES.RESOURCE_ID
, RES.CATEGORY
, ROLE.ROLE_ID
, ROLE.ROLE_CODE
, ROLE.ROLE_TYPE_CODE
, ROLE.MEMBER_FLAG
, ROLE.ADMIN_FLAG
, ROLE.MANAGER_FLAG
, RREL.START_DATE_ACTIVE
, RREL.END_DATE_ACTIVE
FROM JTF_RS_RESOURCE_EXTNS RES
, JTF_RS_GROUP_MEMBERS MEM
, JTF_RS_ROLES_B ROLE
, JTF_RS_ROLE_RELATIONS RREL
, JTF_RS_GROUPS_DENORM GD
WHERE GD.GROUP_ID = MEM.GROUP_ID
AND MEM.RESOURCE_ID = RES.RESOURCE_ID
AND MEM.GROUP_MEMBER_ID = RREL.ROLE_RESOURCE_ID
AND RREL.ROLE_RESOURCE_TYPE = 'RS_GROUP_MEMBER'
AND RREL.ROLE_ID = ROLE.ROLE_ID
AND ROLE.ROLE_TYPE_CODE IN ('SALES'
, 'TELESALES'
, 'FIELDSALES'
, 'PRM')
AND (ROLE.MEMBER_FLAG = 'Y' OR ROLE.MANAGER_FLAG = 'Y')