[Home] [Help]
View: IGS_AD_SCHL_APLY_TO_V
Product: | IGS - Student System (Obsolete) |
Description: | This view is a base view to display all records from IGS_AD_SCHOOL_APPLY_TO table |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
ROW_ID |
SCHOOL_APPLYING_TO |
SCH_APL_TO_ID |
DESCRIPTION |
ORG_UNIT_CD |
CLOSED_IND |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
PARTY_ID |
ORG_STATUS |