VIEW: APPS.OKE_K_ALL_ACCESS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)