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.

[Home] [Help]

View: PA_RES_APRVL_ROLES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_RES_APRVL_ROLES_V

View Text

SELECT RES.RESOURCE_ID
, RES.RESOURCE_NAME
, RES.RESOURCE_JOB_LEVEL
, ORG.NAME
, RES.RESOURCE_ORGANIZATION_ID
, RES.RESOURCE_CITY
, RES.RESOURCE_COUNTRY_CODE
, RES.RESOURCE_REGION
, ASGN.ASSIGNMENT_ID
, ASGN.ASSIGNMENT_NAME
, ASGN.ASSIGNMENT_TYPE
, ASGN.START_DATE
, ASGN.END_DATE
, ASGN.APPRVL_STATUS_CODE
, RES.MANAGER_NAME
, RES.MANAGER_ID
, RES.MANAGER_ID
, NTF.GROUP_ID
, NVL(ASGN.NO_OF_ACTIVE_CANDIDATES
, 0)
FROM PA_RESOURCES_DENORM RES
, PA_PROJECT_ASSIGNMENTS ASGN
, PA_WF_NTF_PERFORMERS NTF
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE NTF.ROUTING_ORDER = 1
AND ASGN.ASSIGNMENT_ID = NTF.OBJECT_ID1
AND RES.RESOURCE_ID = ASGN.RESOURCE_ID
AND ORG.ORGANIZATION_ID = RES.RESOURCE_ORGANIZATION_ID
AND ASGN.START_DATE BETWEEN RES.RESOURCE_EFFECTIVE_START_DATE
AND RES.RESOURCE_EFFECTIVE_END_DATE
AND RES.SCHEDULABLE_FLAG = 'Y' UNION ALL SELECT RES.RESOURCE_ID
, RES.RESOURCE_NAME
, RES.RESOURCE_JOB_LEVEL
, ORG.NAME
, RES.RESOURCE_ORGANIZATION_ID
, RES.RESOURCE_CITY
, RES.RESOURCE_COUNTRY_CODE
, RES.RESOURCE_REGION
, ASGN.ASSIGNMENT_ID
, ASGN.ASSIGNMENT_NAME
, ASGN.ASSIGNMENT_TYPE
, ASGN.START_DATE
, ASGN.END_DATE
, ASGN.APPRVL_STATUS_CODE
, RES.MANAGER_NAME
, RES.MANAGER_ID
, PER.PERSON_ID
, NTF.GROUP_ID
, NVL(ASGN.NO_OF_ACTIVE_CANDIDATES
, 0)
FROM FND_GRANTS FG
, PER_ALL_PEOPLE_F PER
, WF_ROLES WFR
, FND_OBJECTS FOB
, PA_RESOURCES_DENORM RES
, (SELECT PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_PRMRY_CONTACT') MENU_ID
FROM DUAL) TEMP
, PA_PROJECT_ASSIGNMENTS ASGN
, PA_WF_NTF_PERFORMERS NTF
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE NTF.ROUTING_ORDER = 1
AND ASGN.ASSIGNMENT_ID = NTF.OBJECT_ID1
AND RES.RESOURCE_ID = ASGN.RESOURCE_ID
AND FG.INSTANCE_PK1_VALUE = RES.RESOURCE_ORGANIZATION_ID
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND FG.OBJECT_ID = FOB.OBJECT_ID
AND FOB.OBJ_NAME = 'ORGANIZATION'
AND FG.MENU_ID = TEMP.MENU_ID
AND FG.GRANTEE_TYPE = 'USER'
AND FG.GRANTEE_KEY = WFR.NAME
AND WFR.ORIG_SYSTEM = 'HZ_PARTY'
AND PER.PARTY_ID = WFR.ORIG_SYSTEM_ID
AND SYSDATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND ORG.ORGANIZATION_ID = RES.RESOURCE_ORGANIZATION_ID
AND ASGN.START_DATE BETWEEN RES.RESOURCE_EFFECTIVE_START_DATE
AND RES.RESOURCE_EFFECTIVE_END_DATE
AND RES.SCHEDULABLE_FLAG = 'Y'

Columns

Name
RESOURCE_ID
RESOURCE_NAME
JOB_LEVEL
ORGANIZATION_NAME
ORGANIZATION_ID
RESOURCE_CITY
RESOURCE_COUNTRY_CODE
RESOURCE_REGION
ASSIGNMENT_ID
ASSIGNMENT_NAME
ASSIGNMENT_TYPE
ASSIGNMENT_START_DATE
ASSIGNMENT_END_DATE
APPROVAL_STATUS
RESOURCE_MANAGER_NAME
RESOURCE_MANAGER_ID
NOTIFIED_ID
GROUP_ID
NO_OF_ACTIVE_CANDIDATES