VIEW: APPS.IGS_PS_USO_CM_GRP_V

Source

View Text - Preformatted

SELECT cmg.rowid row_id, cmg.class_meet_group_id class_meet_group_id, cmg.class_meet_group_name class_meet_group_name, cmg.cal_type cal_type, cmg.ci_sequence_number ci_sequence_number, ci.alternate_code alternate_code, ci.start_dt start_dt, ci.end_dt end_dt, cmg.created_by created_by, cmg.creation_date creation_date, cmg.last_updated_by last_updated_by, cmg.last_update_date last_update_date, cmg.last_update_login last_update_login, cmg.max_enr_group, cmg.max_ovr_group FROM igs_ps_uso_cm_grp cmg, igs_ca_inst ci WHERE cmg.cal_type = ci.cal_type AND cmg.CI_SEQUENCE_NUMBER = ci.sequence_number

View Text - HTML Formatted

SELECT CMG.ROWID ROW_ID
, CMG.CLASS_MEET_GROUP_ID CLASS_MEET_GROUP_ID
, CMG.CLASS_MEET_GROUP_NAME CLASS_MEET_GROUP_NAME
, CMG.CAL_TYPE CAL_TYPE
, CMG.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.START_DT START_DT
, CI.END_DT END_DT
, CMG.CREATED_BY CREATED_BY
, CMG.CREATION_DATE CREATION_DATE
, CMG.LAST_UPDATED_BY LAST_UPDATED_BY
, CMG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CMG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CMG.MAX_ENR_GROUP
, CMG.MAX_OVR_GROUP
FROM IGS_PS_USO_CM_GRP CMG
, IGS_CA_INST CI
WHERE CMG.CAL_TYPE = CI.CAL_TYPE
AND CMG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER