VIEW: APPS.IGS_PS_USO_INSTRCTRS_V

Source

View Text - Preformatted

SELECT ins.rowid row_id, ins.uso_instructor_id uso_instructor_id, ins.unit_section_occurrence_id unit_section_occurrence_id, ins.instructor_id instructor_id, hz.party_number person_number, hz.party_name person_name, ins.created_by created_by, ins.creation_date creation_date, ins.last_updated_by last_updated_by, ins.last_update_date last_update_date, ins.last_update_login last_update_login FROM igs_ps_uso_instrctrs ins, hz_parties hz WHERE ins.instructor_id = hz.party_id

View Text - HTML Formatted

SELECT INS.ROWID ROW_ID
, INS.USO_INSTRUCTOR_ID USO_INSTRUCTOR_ID
, INS.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, INS.INSTRUCTOR_ID INSTRUCTOR_ID
, HZ.PARTY_NUMBER PERSON_NUMBER
, HZ.PARTY_NAME PERSON_NAME
, INS.CREATED_BY CREATED_BY
, INS.CREATION_DATE CREATION_DATE
, INS.LAST_UPDATED_BY LAST_UPDATED_BY
, INS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USO_INSTRCTRS INS
, HZ_PARTIES HZ
WHERE INS.INSTRUCTOR_ID = HZ.PARTY_ID