View: OKE_K_ROLES_V

Product:	OKE - Project Contracts
Description:	Security Role View
Implementation/DBA Data:	APPS.OKE_K_ROLES_V

View Text

SELECT PRT.PROJECT_ROLE_ID
, PRT.PROJECT_ROLE_TYPE
, PRT.MEANING
, PRT.DESCRIPTION
, PRT.START_DATE_ACTIVE
, PRT.END_DATE_ACTIVE
FROM PA_PROJECT_ROLE_TYPES PRT
, PA_ROLE_CONTROLS RC
WHERE RC.PROJECT_ROLE_ID = PRT.PROJECT_ROLE_ID
AND RC.ROLE_CONTROL_CODE = 'ALLOW_AS_CONTRACT_MEMBER'

Columns