Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT IPO.ROWID
, PE2.PARTY_NUMBER
, PE1.PARTY_NUMBER
, IPO.COURSE_CD
, IPO.VERSION_NUMBER
, IPO.CAL_TYPE
, IPO.CI_SEQUENCE_NUMBER
, IPO.LOCATION_CD
, IPO.ATTENDANCE_MODE
, IPO.ATTENDANCE_TYPE
, IPO.COP_ID
, IPO.COO_ID
, IPO.OFFERED_IND
, IPO.CONFIRMED_OFFERING_IND
, IPO.ENTRY_POINT_IND
, IPO.PRE_ENROL_UNITS_IND
, IPO.ENROLLABLE_IND
, IPO.IVRS_AVAILABLE_IND
, IPO.MIN_ENTRY_ASS_SCORE
, IPO.GUARANTEED_ENTRY_ASS_SCR
, IPO.MAX_CROSS_FACULTY_CP
, IPO.MAX_CROSS_LOCATION_CP
, IPO.MAX_CROSS_MODE_CP
, IPO.MAX_HIST_CROSS_FACULTY_CP
, IPO.ADM_ASS_OFFICER_PERSON_ID
, IPO.ADM_CONTACT_PERSON_ID
, IPO.GRADING_SCHEMA_CD
, IPO.GS_VERSION_NUMBER
, IPO.CREATED_BY
, IPO.CREATION_DATE
, IPO.LAST_UPDATED_BY
, IPO.LAST_UPDATE_DATE
, IPO.LAST_UPDATE_LOGIN
, IPO.REQUEST_ID
, IPO.PROGRAM_APPLICATION_ID
, IPO.PROGRAM_ID
, IPO.PROGRAM_UPDATE_DATE
FROM HZ_PARTIES PE1
, HZ_PARTIES PE2
, IGS_PS_OFR_PAT IPO
WHERE PE1.PARTY_ID(+) =IPO.ADM_ASS_OFFICER_PERSON_ID
AND PE2.PARTY_ID(+) = IPO.ADM_CONTACT_PERSON_ID