VIEW: APPS.CSC_HZ_EDUCATION_V

Source

View Text - Preformatted

SELECT EDUCATION_ID , COURSE_MAJOR , PARTY_ID , DEGREE_RECEIVED , LAST_DATE_ATTENDED , START_DATE_ATTENDED , SCHOOL_ATTENDED_NAME , TYPE_OF_SCHOOL , al.meaning , he.CREATED_BY , he.CREATION_DATE , he.LAST_UPDATE_LOGIN , he.LAST_UPDATE_DATE , he.LAST_UPDATED_BY , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , WH_UPDATE_DATE , NULL ,OBJECT_VERSION_NUMBER FROM HZ_EDUCATION he, AR_LOOKUPS AL WHERE AL.LOOKUP_TYPE (+)= 'HZ_TYPE_OF_SCHOOL' AND HE.TYPE_OF_SCHOOL = AL.LOOKUP_CODE(+) AND HE.STATUS='A'

View Text - HTML Formatted

SELECT EDUCATION_ID
, COURSE_MAJOR
, PARTY_ID
, DEGREE_RECEIVED
, LAST_DATE_ATTENDED
, START_DATE_ATTENDED
, SCHOOL_ATTENDED_NAME
, TYPE_OF_SCHOOL
, AL.MEANING
, HE.CREATED_BY
, HE.CREATION_DATE
, HE.LAST_UPDATE_LOGIN
, HE.LAST_UPDATE_DATE
, HE.LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, NULL
, OBJECT_VERSION_NUMBER
FROM HZ_EDUCATION HE
, AR_LOOKUPS AL
WHERE AL.LOOKUP_TYPE (+)= 'HZ_TYPE_OF_SCHOOL'
AND HE.TYPE_OF_SCHOOL = AL.LOOKUP_CODE(+)
AND HE.STATUS='A'