VIEW: APPS.IGS_EN_OR_UNIT_WLST_V

Source

View Text - Preformatted

SELECT ouw.rowid row_id, ouw.org_unit_wlst_id org_unit_wlst_id, ouw.org_unit_cd org_unit_cd, ouw.start_dt org_start_dt, hp.party_name description, ouw.cal_type cal_type, NULL sequence_number, ct.description, NULL waitlist_alwd, NULL max_wlst_per_stud, ouw.max_stud_per_wlst max_stud_per_wlst, ouw.smtanus_wlst_unit_enr_alwd smtanus_wlst_unit_enr_alwd, ouw.asses_chrg_for_wlst_stud asses_chrg_for_wlst_stud, ouw.created_by created_by, ouw.creation_date creation_date, ouw.last_updated_by last_updated_by, ouw.last_update_date last_update_date, ouw.last_update_login last_update_login, ouw.closed_flag closed_flag FROM igs_ca_type ct, hz_parties hp, igs_pe_hz_parties ihp, igs_en_or_unit_wlst ouw WHERE ouw.cal_type = ct.cal_type AND hp.party_id = ihp.party_id AND ihp.inst_org_ind = 'O' AND ouw.org_unit_cd = ihp.oss_org_unit_cd AND ouw.start_dt = ihp.ou_start_dt AND ct.s_cal_cat = 'LOAD'

View Text - HTML Formatted

SELECT OUW.ROWID ROW_ID
, OUW.ORG_UNIT_WLST_ID ORG_UNIT_WLST_ID
, OUW.ORG_UNIT_CD ORG_UNIT_CD
, OUW.START_DT ORG_START_DT
, HP.PARTY_NAME DESCRIPTION
, OUW.CAL_TYPE CAL_TYPE
, NULL SEQUENCE_NUMBER
, CT.DESCRIPTION
, NULL WAITLIST_ALWD
, NULL MAX_WLST_PER_STUD
, OUW.MAX_STUD_PER_WLST MAX_STUD_PER_WLST
, OUW.SMTANUS_WLST_UNIT_ENR_ALWD SMTANUS_WLST_UNIT_ENR_ALWD
, OUW.ASSES_CHRG_FOR_WLST_STUD ASSES_CHRG_FOR_WLST_STUD
, OUW.CREATED_BY CREATED_BY
, OUW.CREATION_DATE CREATION_DATE
, OUW.LAST_UPDATED_BY LAST_UPDATED_BY
, OUW.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OUW.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OUW.CLOSED_FLAG CLOSED_FLAG
FROM IGS_CA_TYPE CT
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGS_EN_OR_UNIT_WLST OUW
WHERE OUW.CAL_TYPE = CT.CAL_TYPE
AND HP.PARTY_ID = IHP.PARTY_ID
AND IHP.INST_ORG_IND = 'O'
AND OUW.ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD
AND OUW.START_DT = IHP.OU_START_DT
AND CT.S_CAL_CAT = 'LOAD'