VIEW: APPS.IGS_PS_SCH_OCR_CFIG_V

Source

View Text - Preformatted

SELECT soc.rowid row_id, soc.ocr_cfig_id ocr_cfig_id, soc.to_be_announced_roll_flag to_be_announced_roll_flag, soc.day_roll_flag day_roll_flag, soc.time_roll_flag time_roll_flag, soc.instructor_roll_flag instructor_roll_flag, soc.facility_roll_flag facility_roll_flag, soc.schd_not_rqd_roll_flag schd_not_rqd_roll_flag, soc.ref_cd_roll_flag ref_cd_roll_flag, soc.preferred_bld_roll_flag preferred_bld_roll_flag, soc.preferred_room_roll_flag preferred_room_roll_flag, soc.dedicated_bld_roll_flag dedicated_bld_roll_flag, soc.dedicated_room_roll_flag dedicated_room_roll_flag, soc.scheduled_bld_roll_flag scheduled_bld_roll_flag, soc.scheduled_room_roll_flag scheduled_room_roll_flag, soc.preferred_region_roll_flag preferred_region_roll_flag, soc.occur_flexfield_roll_flag occur_flexfield_roll_flag, soc.inc_ins_change_notfy_roll_flag inc_ins_change_notfy_roll_flag, soc.date_ovrd_flag date_ovrd_flag, soc.day_ovrd_flag day_ovrd_flag, soc.time_ovrd_flag time_ovrd_flag, soc.instructor_ovrd_flag instructor_ovrd_flag, soc.scheduled_bld_ovrd_flag scheduled_bld_ovrd_flag, soc.scheduled_room_ovrd_flag scheduled_room_ovrd_flag, soc.created_by created_by, soc.creation_date creation_date, soc.last_updated_by last_updated_by, soc.last_update_date last_update_date, soc.last_update_login last_update_login FROM IGS_PS_SCH_OCR_CFIG soc

View Text - HTML Formatted

SELECT SOC.ROWID ROW_ID
, SOC.OCR_CFIG_ID OCR_CFIG_ID
, SOC.TO_BE_ANNOUNCED_ROLL_FLAG TO_BE_ANNOUNCED_ROLL_FLAG
, SOC.DAY_ROLL_FLAG DAY_ROLL_FLAG
, SOC.TIME_ROLL_FLAG TIME_ROLL_FLAG
, SOC.INSTRUCTOR_ROLL_FLAG INSTRUCTOR_ROLL_FLAG
, SOC.FACILITY_ROLL_FLAG FACILITY_ROLL_FLAG
, SOC.SCHD_NOT_RQD_ROLL_FLAG SCHD_NOT_RQD_ROLL_FLAG
, SOC.REF_CD_ROLL_FLAG REF_CD_ROLL_FLAG
, SOC.PREFERRED_BLD_ROLL_FLAG PREFERRED_BLD_ROLL_FLAG
, SOC.PREFERRED_ROOM_ROLL_FLAG PREFERRED_ROOM_ROLL_FLAG
, SOC.DEDICATED_BLD_ROLL_FLAG DEDICATED_BLD_ROLL_FLAG
, SOC.DEDICATED_ROOM_ROLL_FLAG DEDICATED_ROOM_ROLL_FLAG
, SOC.SCHEDULED_BLD_ROLL_FLAG SCHEDULED_BLD_ROLL_FLAG
, SOC.SCHEDULED_ROOM_ROLL_FLAG SCHEDULED_ROOM_ROLL_FLAG
, SOC.PREFERRED_REGION_ROLL_FLAG PREFERRED_REGION_ROLL_FLAG
, SOC.OCCUR_FLEXFIELD_ROLL_FLAG OCCUR_FLEXFIELD_ROLL_FLAG
, SOC.INC_INS_CHANGE_NOTFY_ROLL_FLAG INC_INS_CHANGE_NOTFY_ROLL_FLAG
, SOC.DATE_OVRD_FLAG DATE_OVRD_FLAG
, SOC.DAY_OVRD_FLAG DAY_OVRD_FLAG
, SOC.TIME_OVRD_FLAG TIME_OVRD_FLAG
, SOC.INSTRUCTOR_OVRD_FLAG INSTRUCTOR_OVRD_FLAG
, SOC.SCHEDULED_BLD_OVRD_FLAG SCHEDULED_BLD_OVRD_FLAG
, SOC.SCHEDULED_ROOM_OVRD_FLAG SCHEDULED_ROOM_OVRD_FLAG
, SOC.CREATED_BY CREATED_BY
, SOC.CREATION_DATE CREATION_DATE
, SOC.LAST_UPDATED_BY LAST_UPDATED_BY
, SOC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SOC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_SCH_OCR_CFIG SOC