VIEW: APPS.IGS_OR_INSTITUTION_V

Source

View Text - Preformatted

SELECT ROW_ID ,PARTY_ID ,INSTITUTION_CD , NAME ,INSTITUTION_STATUS ,LOCAL_INSTITUTION_IND ,OS_IND ,GOVT_INSTITUTION_CD , INSTITUTION_TYPE , DESCRIPTION ,INST_CONTROL_TYPE , CTRL_DESCRIPTION ,pref_inst_id_type ,pref_inst_alt_id ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,CREATED_BY ,CREATION_DATE ,LAST_UPDATE_LOGIN ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,EPS_CODE ,INSTITUTION_PRIORITY ,PRIORITY_DESCRIPTION ,INST_PHONE_COUNTRY_CODE ,INST_PHONE_AREA_CODE ,INST_PHONE_NUMBER ,ADV_STUDIES_CLASSES ,HONORS_CLASSES ,CLASS_SIZE ,SEC_SCHOOL_LOCATION_ID ,SEC_SCHOOL_LOCATION_CODE ,SEC_SCHOOL_LOCATION_DESC ,PERCENT_PLAN_HIGHER_EDU FROM IGS_OR_INSTITUTION

View Text - HTML Formatted

SELECT ROW_ID
, PARTY_ID
, INSTITUTION_CD
, NAME
, INSTITUTION_STATUS
, LOCAL_INSTITUTION_IND
, OS_IND
, GOVT_INSTITUTION_CD
, INSTITUTION_TYPE
, DESCRIPTION
, INST_CONTROL_TYPE
, CTRL_DESCRIPTION
, PREF_INST_ID_TYPE
, PREF_INST_ALT_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, EPS_CODE
, INSTITUTION_PRIORITY
, PRIORITY_DESCRIPTION
, INST_PHONE_COUNTRY_CODE
, INST_PHONE_AREA_CODE
, INST_PHONE_NUMBER
, ADV_STUDIES_CLASSES
, HONORS_CLASSES
, CLASS_SIZE
, SEC_SCHOOL_LOCATION_ID
, SEC_SCHOOL_LOCATION_CODE
, SEC_SCHOOL_LOCATION_DESC
, PERCENT_PLAN_HIGHER_EDU
FROM IGS_OR_INSTITUTION