Product: | OKE - Project Contracts |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKE_P_ROLE_ASSIGN_V |
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 PP.CREATION_DATE BETWEEN EMP.EFFECTIVE_START_DATE
AND EMP.EFFECTIVE_END_DATE