View: PA_PEOPLE_ROLE_ON_ORGS_V

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

View Text

SELECT PPRT.PROJECT_ROLE_ID
, PPRT.PROJECT_ROLE_TYPE
, PPRT.MEANING
, FG.INSTANCE_PK1_VALUE
, HAOU.NAME
, PE.PERSON_ID
, PE.FULL_NAME PARTY_NAME
, FG.START_DATE
, FG.END_DATE
FROM PA_PROJECT_ROLE_TYPES PPRT
, PER_PEOPLE_F PE
, HR_ALL_ORGANIZATION_UNITS HAOU
, FND_GRANTS FG
, FND_OBJECTS FO
WHERE PPRT.MENU_ID = FG.MENU_ID
AND FO.OBJ_NAME = 'ORGANIZATION'
AND FG.OBJECT_ID = FO.OBJECT_ID
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND FG.GRANTEE_TYPE ='USER'
AND SUBSTR(FG.GRANTEE_KEY
, INSTR(FG.GRANTEE_KEY
, ':')+1) = PE.PARTY_ID
AND HAOU.ORGANIZATION_ID = INSTANCE_PK1_VALUE
AND FG.START_DATE BETWEEN TRUNC(PE.EFFECTIVE_START_DATE)
AND TRUNC(PE.EFFECTIVE_END_DATE)

Columns