VIEW: APPS.IGSFV_ORG_EXTENSIONS

Source

View Text - Preformatted

SELECT HP.PARTY_NUMBER INST_ORG_CODE, PHP.INST_ORG_IND INST_ORG_INDICATOR, PHP.INSTITUTION_CD INSTITUTION_CODE, PHP.OU_START_DT ORG_START_DATE, PHP.OU_END_DT ORG_END_DATE, '_LA:PHP.OU_MEMBER_TYPE:IGS_LOOKUP_VALUES:OR_MEMBER_TYPE:MEANING', PHP.OU_ORG_STATUS ORG_STATUS, '_LA:PHP.OU_ORG_TYPE:IGS_LOOKUP_VALUES:OR_ORG_TYPE:MEANING', PHP.OI_LOCAL_INSTITUTION_IND LOCAL_INSTITUTION_INDICATOR, PHP.OI_OS_IND OVERSEAS_INDICATOR, '_LA:PHP.OI_GOVT_INSTITUTION_CD:IGS_LOOKUP_VALUES:OR_INST_GOVT_CD:MEANING', '_LA:PHP.OI_INST_CONTROL_TYPE:IGS_LOOKUP_VALUES:OR_INST_CTL_TYPE:MEANING', '_LA:PHP.INST_PRIORITY_CD:IGS_LOOKUP_VALUES:OR_INST_PRIORITY_CD:MEANING', PHP.OI_INSTITUTION_TYPE INSTITUTION_TYPE, PHP.OI_INSTITUTION_STATUS INSTITUTION_STATUS, PHP.INST_EPS_CODE INST_MARKET_CODE, PHP.INST_PHONE_COUNTRY_CODE, PHP.INST_PHONE_AREA_CODE, PHP.INST_PHONE_NUMBER, OST.DESCRIPTION ORG_STATUS_DESC, OIT.DESCRIPTION INSTITUTION_TYPE_DESC, OIS.DESCRIPTION INSTITUTION_STATUS_DESC, CC2.NAME SEC_SCHOOL_LOCATION, CC2.DESCRIPTION SEC_SCHOOL_LOCATION_DESC, PHP.ADV_STUDIES_CLASSES, PHP.HONORS_CLASSES, PHP.CLASS_SIZE, PHP.PERCENT_PLAN_HIGHER_EDU, PHP.PARTY_ID, PHP.SEC_SCHOOL_LOCATION_ID, PHP.CREATED_BY, PHP.CREATION_DATE, PHP.LAST_UPDATED_BY, PHP.LAST_UPDATE_DATE FROM IGS_PE_HZ_PARTIES PHP, HZ_PARTIES HP, IGS_OR_STATUS OST, IGS_OR_ORG_INST_TYPE OIT, IGS_OR_INST_STAT OIS, IGS_AD_CODE_CLASSES CC2 WHERE PHP.PARTY_ID = HP.PARTY_ID AND PHP.INST_ORG_IND IN('I','O') AND PHP.OU_ORG_STATUS = OST.ORG_STATUS(+) AND PHP.OI_INSTITUTION_TYPE = OIT.INSTITUTION_TYPE(+) AND PHP.OI_INSTITUTION_STATUS = OIS.INSTITUTION_STATUS(+) AND PHP.SEC_SCHOOL_LOCATION_ID = CC2.CODE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NUMBER INST_ORG_CODE
, PHP.INST_ORG_IND INST_ORG_INDICATOR
, PHP.INSTITUTION_CD INSTITUTION_CODE
, PHP.OU_START_DT ORG_START_DATE
, PHP.OU_END_DT ORG_END_DATE
, '_LA:PHP.OU_MEMBER_TYPE:IGS_LOOKUP_VALUES:OR_MEMBER_TYPE:MEANING'
, PHP.OU_ORG_STATUS ORG_STATUS
, '_LA:PHP.OU_ORG_TYPE:IGS_LOOKUP_VALUES:OR_ORG_TYPE:MEANING'
, PHP.OI_LOCAL_INSTITUTION_IND LOCAL_INSTITUTION_INDICATOR
, PHP.OI_OS_IND OVERSEAS_INDICATOR
, '_LA:PHP.OI_GOVT_INSTITUTION_CD:IGS_LOOKUP_VALUES:OR_INST_GOVT_CD:MEANING'
, '_LA:PHP.OI_INST_CONTROL_TYPE:IGS_LOOKUP_VALUES:OR_INST_CTL_TYPE:MEANING'
, '_LA:PHP.INST_PRIORITY_CD:IGS_LOOKUP_VALUES:OR_INST_PRIORITY_CD:MEANING'
, PHP.OI_INSTITUTION_TYPE INSTITUTION_TYPE
, PHP.OI_INSTITUTION_STATUS INSTITUTION_STATUS
, PHP.INST_EPS_CODE INST_MARKET_CODE
, PHP.INST_PHONE_COUNTRY_CODE
, PHP.INST_PHONE_AREA_CODE
, PHP.INST_PHONE_NUMBER
, OST.DESCRIPTION ORG_STATUS_DESC
, OIT.DESCRIPTION INSTITUTION_TYPE_DESC
, OIS.DESCRIPTION INSTITUTION_STATUS_DESC
, CC2.NAME SEC_SCHOOL_LOCATION
, CC2.DESCRIPTION SEC_SCHOOL_LOCATION_DESC
, PHP.ADV_STUDIES_CLASSES
, PHP.HONORS_CLASSES
, PHP.CLASS_SIZE
, PHP.PERCENT_PLAN_HIGHER_EDU
, PHP.PARTY_ID
, PHP.SEC_SCHOOL_LOCATION_ID
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.LAST_UPDATED_BY
, PHP.LAST_UPDATE_DATE
FROM IGS_PE_HZ_PARTIES PHP
, HZ_PARTIES HP
, IGS_OR_STATUS OST
, IGS_OR_ORG_INST_TYPE OIT
, IGS_OR_INST_STAT OIS
, IGS_AD_CODE_CLASSES CC2
WHERE PHP.PARTY_ID = HP.PARTY_ID
AND PHP.INST_ORG_IND IN('I'
, 'O')
AND PHP.OU_ORG_STATUS = OST.ORG_STATUS(+)
AND PHP.OI_INSTITUTION_TYPE = OIT.INSTITUTION_TYPE(+)
AND PHP.OI_INSTITUTION_STATUS = OIS.INSTITUTION_STATUS(+)
AND PHP.SEC_SCHOOL_LOCATION_ID = CC2.CODE_ID(+) WITH READ ONLY