VIEW: APPS.IGS_AD_SCHL_APLY_TO_V

Source

View Text - Preformatted

SELECT sat.rowid row_id, sat.school_applying_to, sat.sch_apl_to_id, sat.description, sat.org_unit_cd, sat.closed_ind, sat.created_by, sat.creation_date, sat.last_updated_by, sat.last_update_date, sat.last_update_login, iou.party_id, iou.org_status FROM igs_ad_schl_aply_to sat, igs_or_unit iou WHERE IOU.ORG_UNIT_CD = SAT.ORG_UNIT_CD

View Text - HTML Formatted

SELECT SAT.ROWID ROW_ID
, SAT.SCHOOL_APPLYING_TO
, SAT.SCH_APL_TO_ID
, SAT.DESCRIPTION
, SAT.ORG_UNIT_CD
, SAT.CLOSED_IND
, SAT.CREATED_BY
, SAT.CREATION_DATE
, SAT.LAST_UPDATED_BY
, SAT.LAST_UPDATE_DATE
, SAT.LAST_UPDATE_LOGIN
, IOU.PARTY_ID
, IOU.ORG_STATUS
FROM IGS_AD_SCHL_APLY_TO SAT
, IGS_OR_UNIT IOU
WHERE IOU.ORG_UNIT_CD = SAT.ORG_UNIT_CD