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.PA_RESOURCE_AUTHORITY_V

Source

View Text - Preformatted


SELECT res_denorm.person_id, res_denorm.resource_id, res_denorm.resource_name, res_denorm.resource_effective_start_date, res_denorm.resource_effective_end_date, res_denorm.manager_id, res_denorm.manager_name resource_authority_person_name, 'Resource Manager' from pa_resources_denorm res_denorm WHERE res_denorm.manager_id is not null union select res_denorm.person_Id, res_denorm.resource_id, res_denorm.resource_name, res_denorm.resource_effective_start_date, res_denorm.resource_effective_end_date, per.person_id, per.full_name, 'Staffing Manager (Primary Contact)' from pa_resources_denorm res_denorm, fnd_grants fg, fnd_objects fob, per_people_x per, (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id from dual) prmry_contact_menu where fob.obj_name = 'ORGANIZATION' and fg.instance_pk1_value = to_char(res_denorm.resource_organization_id) and fg.instance_type = 'INSTANCE' and fg.object_id = fob.object_id and fg.grantee_type = 'USER' and fg.menu_id = prmry_contact_menu.menu_id and trunc(SYSDATE) between trunc(fg.start_date) and trunc(NVL(fg.end_date, SYSDATE+1)) and to_char(per.person_id) = substr(fg.grantee_key,5,20) union select res_denorm.person_Id, res_denorm.resource_id, res_denorm.resource_name, res_denorm.resource_effective_start_date, res_denorm.resource_effective_end_date, per.person_id, per.full_name, 'Staffing Manager' from pa_resources_denorm res_denorm, fnd_grants fg, fnd_objects fob, per_people_x per, (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id from dual) res_auth_menu where fob.obj_name = 'ORGANIZATION' and fg.instance_pk1_value = to_char(res_denorm.resource_organization_id) and fg.instance_type = 'INSTANCE' and fg.object_id = fob.object_id and fg.grantee_type = 'USER' and fg.menu_id = res_auth_menu.menu_id and trunc(SYSDATE) between trunc(fg.start_date) and trunc(NVL(fg.end_date, SYSDATE+1)) and to_char(per.person_id) = substr(fg.grantee_key,5,20) and per.person_id <> res_denorm.manager_id and per.person_id not in ( select per2.person_Id from fnd_grants fg2, fnd_objects fob2, (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id from dual) prmry_contact_menu, per_people_x per2 where fob.obj_name = 'ORGANIZATION' and fg2.instance_pk1_value = to_char(res_denorm.resource_organization_id) and fg2.instance_type = 'INSTANCE' and fg2.object_id = fob2.object_id and fg2.grantee_type = 'USER' and fg2.menu_id = prmry_contact_menu.menu_id and trunc(SYSDATE) between trunc(fg2.start_date) and trunc(NVL(fg2.end_date, SYSDATE+1)) and to_char(per2.person_id) = substr(fg2.grantee_key,5,20) )

View Text - HTML Formatted

SELECT RES_DENORM.PERSON_ID
, RES_DENORM.RESOURCE_ID
, RES_DENORM.RESOURCE_NAME
, RES_DENORM.RESOURCE_EFFECTIVE_START_DATE
, RES_DENORM.RESOURCE_EFFECTIVE_END_DATE
, RES_DENORM.MANAGER_ID
, RES_DENORM.MANAGER_NAME RESOURCE_AUTHORITY_PERSON_NAME
, 'RESOURCE MANAGER'
FROM PA_RESOURCES_DENORM RES_DENORM
WHERE RES_DENORM.MANAGER_ID IS NOT NULL UNION SELECT RES_DENORM.PERSON_ID
, RES_DENORM.RESOURCE_ID
, RES_DENORM.RESOURCE_NAME
, RES_DENORM.RESOURCE_EFFECTIVE_START_DATE
, RES_DENORM.RESOURCE_EFFECTIVE_END_DATE
, PER.PERSON_ID
, PER.FULL_NAME
, 'STAFFING MANAGER (PRIMARY CONTACT)'
FROM PA_RESOURCES_DENORM RES_DENORM
, FND_GRANTS FG
, FND_OBJECTS FOB
, PER_PEOPLE_X PER
, (SELECT PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_PRMRY_CONTACT') MENU_ID
FROM DUAL) PRMRY_CONTACT_MENU
WHERE FOB.OBJ_NAME = 'ORGANIZATION'
AND FG.INSTANCE_PK1_VALUE = TO_CHAR(RES_DENORM.RESOURCE_ORGANIZATION_ID)
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND FG.OBJECT_ID = FOB.OBJECT_ID
AND FG.GRANTEE_TYPE = 'USER'
AND FG.MENU_ID = PRMRY_CONTACT_MENU.MENU_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(FG.START_DATE)
AND TRUNC(NVL(FG.END_DATE
, SYSDATE+1))
AND TO_CHAR(PER.PERSON_ID) = SUBSTR(FG.GRANTEE_KEY
, 5
, 20) UNION SELECT RES_DENORM.PERSON_ID
, RES_DENORM.RESOURCE_ID
, RES_DENORM.RESOURCE_NAME
, RES_DENORM.RESOURCE_EFFECTIVE_START_DATE
, RES_DENORM.RESOURCE_EFFECTIVE_END_DATE
, PER.PERSON_ID
, PER.FULL_NAME
, 'STAFFING MANAGER'
FROM PA_RESOURCES_DENORM RES_DENORM
, FND_GRANTS FG
, FND_OBJECTS FOB
, PER_PEOPLE_X PER
, (SELECT PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_AUTH') MENU_ID
FROM DUAL) RES_AUTH_MENU
WHERE FOB.OBJ_NAME = 'ORGANIZATION'
AND FG.INSTANCE_PK1_VALUE = TO_CHAR(RES_DENORM.RESOURCE_ORGANIZATION_ID)
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND FG.OBJECT_ID = FOB.OBJECT_ID
AND FG.GRANTEE_TYPE = 'USER'
AND FG.MENU_ID = RES_AUTH_MENU.MENU_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(FG.START_DATE)
AND TRUNC(NVL(FG.END_DATE
, SYSDATE+1))
AND TO_CHAR(PER.PERSON_ID) = SUBSTR(FG.GRANTEE_KEY
, 5
, 20)
AND PER.PERSON_ID <> RES_DENORM.MANAGER_ID
AND PER.PERSON_ID NOT IN ( SELECT PER2.PERSON_ID
FROM FND_GRANTS FG2
, FND_OBJECTS FOB2
, (SELECT PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_PRMRY_CONTACT') MENU_ID
FROM DUAL) PRMRY_CONTACT_MENU
, PER_PEOPLE_X PER2
WHERE FOB.OBJ_NAME = 'ORGANIZATION'
AND FG2.INSTANCE_PK1_VALUE = TO_CHAR(RES_DENORM.RESOURCE_ORGANIZATION_ID)
AND FG2.INSTANCE_TYPE = 'INSTANCE'
AND FG2.OBJECT_ID = FOB2.OBJECT_ID
AND FG2.GRANTEE_TYPE = 'USER'
AND FG2.MENU_ID = PRMRY_CONTACT_MENU.MENU_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(FG2.START_DATE)
AND TRUNC(NVL(FG2.END_DATE
, SYSDATE+1))
AND TO_CHAR(PER2.PERSON_ID) = SUBSTR(FG2.GRANTEE_KEY
, 5
, 20) )