View: OKE_K_ROLE_ASSIGN_V

Product:	OKE - Project Contracts
Description:
Implementation/DBA Data:	APPS.OKE_K_ROLE_ASSIGN_V

View Text

SELECT PP.ROWID
, PP.RECORD_VERSION_NUMBER
, PP.PROJECT_PARTY_ID
, PP.OBJECT_ID
, PP.OBJECT_TYPE
, KH.CONTRACT_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
, OKC_K_HEADERS_B KH
, PER_ALL_PEOPLE_F EMP
WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID
AND PP.OBJECT_TYPE = 'OKE_K_HEADERS'
AND PP.OBJECT_ID = KH.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

Columns