VIEW: APPS.OKE_P_ROLE_ASSIGN_V

Source

View Text - Preformatted

SELECT PP.ROWID , PP.RECORD_VERSION_NUMBER , PP.PROJECT_PARTY_ID , PP.OBJECT_ID , PP.OBJECT_TYPE , PG.PROGRAM_NUMBER , PP.RESOURCE_ID , PP.RESOURCE_TYPE_ID , PP.RESOURCE_SOURCE_ID , EMP.FULL_NAME , PP.PROJECT_ROLE_ID , PR.MEANING , PP.START_DATE_ACTIVE , PP.END_DATE_ACTIVE , PP.CREATION_DATE , PP.CREATED_BY , PP.LAST_UPDATE_DATE , PP.LAST_UPDATED_BY , PP.LAST_UPDATE_LOGIN FROM PA_PROJECT_PARTIES PP , PA_PROJECT_ROLE_TYPES PR , OKE_PROGRAMS PG , PER_ALL_PEOPLE_F EMP WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID AND PP.OBJECT_TYPE = 'OKE_PROGRAMS' AND PP.OBJECT_ID = PG.PROGRAM_ID AND PP.RESOURCE_TYPE_ID = 101 AND EMP.PERSON_ID = PP.RESOURCE_SOURCE_ID AND Trunc(PP.CREATION_DATE) BETWEEN EMP.EFFECTIVE_START_DATE AND EMP.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PP.ROWID
, PP.RECORD_VERSION_NUMBER
, PP.PROJECT_PARTY_ID
, PP.OBJECT_ID
, PP.OBJECT_TYPE
, PG.PROGRAM_NUMBER
, PP.RESOURCE_ID
, PP.RESOURCE_TYPE_ID
, PP.RESOURCE_SOURCE_ID
, EMP.FULL_NAME
, PP.PROJECT_ROLE_ID
, PR.MEANING
, PP.START_DATE_ACTIVE
, PP.END_DATE_ACTIVE
, PP.CREATION_DATE
, PP.CREATED_BY
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.LAST_UPDATE_LOGIN
FROM PA_PROJECT_PARTIES PP
, PA_PROJECT_ROLE_TYPES PR
, OKE_PROGRAMS PG
, PER_ALL_PEOPLE_F EMP
WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID
AND PP.OBJECT_TYPE = 'OKE_PROGRAMS'
AND PP.OBJECT_ID = PG.PROGRAM_ID
AND PP.RESOURCE_TYPE_ID = 101
AND EMP.PERSON_ID = PP.RESOURCE_SOURCE_ID
AND TRUNC(PP.CREATION_DATE) BETWEEN EMP.EFFECTIVE_START_DATE
AND EMP.EFFECTIVE_END_DATE