View: OKE_K_ALL_ACCESS_V

Product:	OKE - Project Contracts
Description:	Contract Security Assignment display view
Implementation/DBA Data:	APPS.OKE_K_ALL_ACCESS_V

View Text

SELECT A.ASSIGNMENT_LEVEL
, K.K_HEADER_ID
, K.K_NUMBER_DISP
, A.PERSON_ID
, H.FULL_NAME
, A.ROLE_ID
, R.MEANING
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
FROM OKE_K_ALL_ACCESS_BASIC_V A
, OKE_K_HEADERS K
, PA_PROJECT_ROLE_TYPES R
, PER_ALL_PEOPLE_F H
WHERE K.K_HEADER_ID = A.K_HEADER_ID
AND R.PROJECT_ROLE_ID = A.ROLE_ID
AND H.PERSON_ID = A.PERSON_ID
AND TRUNC(A.CREATION_DATE) BETWEEN TRUNC(H.EFFECTIVE_START_DATE)
AND TRUNC(H.EFFECTIVE_END_DATE)

Columns