VIEW: APPS.AS_RPT_ADMINS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')