VIEW: APPS.IGS_OR_INST_HIST

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.org_id org_id, tab.institution_cd institution_cd, tab.hist_start_dt hist_start_dt, tab.hist_end_dt hist_end_dt, tab.hist_who hist_who, tab.name name, tab.inst_phone_country_code inst_phone_country_code, tab.inst_phone_area_code inst_phone_area_code, tab.inst_phone_number inst_phone_number, tab.inst_priority_cd inst_priority_cd, tab.eps_code eps_code, tab.institution_status institution_status, tab.local_institution_ind local_institution_ind, tab.os_ind os_ind, tab.govt_institution_cd govt_institution_cd, tab.institution_type institution_type, tab.description description, tab.inst_control_type inst_control_type, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login FROM igs_or_inst_hist_all tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.INSTITUTION_CD INSTITUTION_CD
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.NAME NAME
, TAB.INST_PHONE_COUNTRY_CODE INST_PHONE_COUNTRY_CODE
, TAB.INST_PHONE_AREA_CODE INST_PHONE_AREA_CODE
, TAB.INST_PHONE_NUMBER INST_PHONE_NUMBER
, TAB.INST_PRIORITY_CD INST_PRIORITY_CD
, TAB.EPS_CODE EPS_CODE
, TAB.INSTITUTION_STATUS INSTITUTION_STATUS
, TAB.LOCAL_INSTITUTION_IND LOCAL_INSTITUTION_IND
, TAB.OS_IND OS_IND
, TAB.GOVT_INSTITUTION_CD GOVT_INSTITUTION_CD
, TAB.INSTITUTION_TYPE INSTITUTION_TYPE
, TAB.DESCRIPTION DESCRIPTION
, TAB.INST_CONTROL_TYPE INST_CONTROL_TYPE
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_OR_INST_HIST_ALL TAB