eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JTF_TTY_ALL_RESOURCES_V

Source

View Text - Preformatted


SELECT rsc.resource_name resource_name , rsc.resource_id resource_id , grps.group_name group_name, grps.group_id, j1.role_name role_name, j1.role_code role_code, j1.MANAGER_FLAG manager_flag FROM jtf_rs_resource_extns_vl rsc, jtf_rs_groups_vl grps, jtf_rs_roles_vl j1, jtf_rs_group_mbr_role_vl j2 WHERE SYSDATE between rsc.start_date_active and nvl(rsc.end_date_active, sysdate) AND SYSDATE BETWEEN j2.start_date_active AND NVL(j2.end_date_active, SYSDATE+1) AND j1.role_id = j2.role_id AND j1.active_flag = 'Y' AND (j1.role_type_code = 'SALES' OR j1.role_type_code = 'TELESALES' OR j1.role_type_code = 'FIELDSALES' ) AND j2.group_id = grps.group_id AND j2.resource_id = rsc.resource_id

View Text - HTML Formatted

SELECT RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.RESOURCE_ID RESOURCE_ID
, GRPS.GROUP_NAME GROUP_NAME
, GRPS.GROUP_ID
, J1.ROLE_NAME ROLE_NAME
, J1.ROLE_CODE ROLE_CODE
, J1.MANAGER_FLAG MANAGER_FLAG
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
, JTF_RS_GROUPS_VL GRPS
, JTF_RS_ROLES_VL J1
, JTF_RS_GROUP_MBR_ROLE_VL J2
WHERE SYSDATE BETWEEN RSC.START_DATE_ACTIVE
AND NVL(RSC.END_DATE_ACTIVE
, SYSDATE)
AND SYSDATE BETWEEN J2.START_DATE_ACTIVE
AND NVL(J2.END_DATE_ACTIVE
, SYSDATE+1)
AND J1.ROLE_ID = J2.ROLE_ID
AND J1.ACTIVE_FLAG = 'Y'
AND (J1.ROLE_TYPE_CODE = 'SALES' OR J1.ROLE_TYPE_CODE = 'TELESALES' OR J1.ROLE_TYPE_CODE = 'FIELDSALES' )
AND J2.GROUP_ID = GRPS.GROUP_ID
AND J2.RESOURCE_ID = RSC.RESOURCE_ID