View: OKE_K_ACCESS_V

Product:	OKE - Project Contracts
Description:	Security Assignments view
Implementation/DBA Data:	APPS.OKE_K_ACCESS_V

View Text

SELECT PP.ROWID
, PP.RECORD_VERSION_NUMBER
, PP.PROJECT_PARTY_ID
, PP.OBJECT_ID
, PP.OBJECT_TYPE
, KH.K_NUMBER_DISP
, PP.RESOURCE_ID
, PP.RESOURCE_TYPE_ID
, PP.RESOURCE_SOURCE_ID
, 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_K_HEADERS KH
WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID
AND PP.OBJECT_TYPE = 'OKE_K_HEADERS'
AND PP.OBJECT_ID = KH.K_HEADER_ID
AND PP.RESOURCE_TYPE_ID = 101 UNION ALL SELECT PP.ROWID
, PP.RECORD_VERSION_NUMBER
, PP.PROJECT_PARTY_ID
, DECODE( PP.OBJECT_ID
, 0
, TO_NUMBER(NULL)
, PP.OBJECT_ID)
, DECODE( PP.OBJECT_ID
, 0
, 'SITE'
, PP.OBJECT_TYPE)
, PG.PROGRAM_NUMBER
, PP.RESOURCE_ID
, PP.RESOURCE_TYPE_ID
, PP.RESOURCE_SOURCE_ID
, 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
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

Columns