Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_EDUCATION_V |
SELECT HED.ROWID
, HED.EDUCATION_ID
, HED.COURSE_MAJOR
, HED.PARTY_ID
, HED.DEGREE_RECEIVED
, HED.LAST_DATE_ATTENDED
, HED.START_DATE_ATTENDED
, HED.SCHOOL_ATTENDED_NAME
, HED.TYPE_OF_SCHOOL
, ALK.MEANING TYPE_OF_SCHOOL_MEANING
, HED.CREATED_BY
, HED.CREATION_DATE
, HED.LAST_UPDATE_LOGIN
, HED.LAST_UPDATE_DATE
, HED.LAST_UPDATED_BY
, HED.REQUEST_ID
, HED.PROGRAM_APPLICATION_ID
, HED.PROGRAM_ID
, HED.PROGRAM_UPDATE_DATE
, HED.OBJECT_VERSION_NUMBER
, HED.APPLICATION_ID
, HED.CREATED_BY_MODULE FROM HZ_EDUCATION HED
, AR_LOOKUPS ALK
WHERE HED.TYPE_OF_SCHOOL = ALK.LOOKUP_CODE(+) AND ALK.LOOKUP_TYPE(+)='HZ_TYPE_OF_SCHOOL'