VIEW: APPS.IGSFV_INSTITUTION_PARTY

Source

View Text - Preformatted

SELECT HP.PARTY_ID, PHP.OSS_ORG_UNIT_CD INSTITUTION_CODE, HP.PARTY_NUMBER TCA_PARTY_NUMBER, HP.PARTY_NAME, '_LA:PHP.OI_LOCAL_INSTITUTION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:PHP.OI_OS_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:PHP.OI_GOVT_INSTITUTION_CD:IGS_LOOKUP_VALUES:OR_INST_GOV_CD:MEANING', '_LA:PHP.OI_INST_CONTROL_TYPE:IGS_LOOKUP_VALUES:OR_INST_CTL_TYPE:MEANING', PHP.OI_INSTITUTION_TYPE, PHP.OI_INSTITUTION_STATUS, PHP.INST_EPS_CODE, PHP.INST_PHONE_COUNTRY_CODE, PHP.INST_PHONE_AREA_CODE, PHP.INST_PHONE_NUMBER, PHP.ADV_STUDIES_CLASSES, PHP.HONORS_CLASSES, PHP.CLASS_SIZE, PHP.SEC_SCHOOL_LOCATION_ID, PHP.PERCENT_PLAN_HIGHER_EDU, '_LA:PHP.INST_PRIORITY_CD:IGS_LOOKUP_VALUES:OR_INST_PRIORITY_CD:MEANING', OIT.DESCRIPTION, INS.DESCRIPTION, PHP.CREATED_BY, PHP.CREATION_DATE, PHP.LAST_UPDATED_BY, PHP.LAST_UPDATE_DATE, PHP.LAST_UPDATE_LOGIN FROM IGS_PE_HZ_PARTIES PHP, HZ_PARTIES HP, IGS_OR_ORG_INST_TYPE_ALL OIT, IGS_OR_INST_STAT INS WHERE HP.PARTY_ID = PHP.PARTY_ID AND PHP.OI_INSTITUTION_TYPE = OIT.INSTITUTION_TYPE(+) AND PHP.OI_INSTITUTION_STATUS = INS.INSTITUTION_STATUS(+) AND HP.PARTY_TYPE = 'ORGANIZATION' AND PHP.INST_ORG_IND = 'I' WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_ID
, PHP.OSS_ORG_UNIT_CD INSTITUTION_CODE
, HP.PARTY_NUMBER TCA_PARTY_NUMBER
, HP.PARTY_NAME
, '_LA:PHP.OI_LOCAL_INSTITUTION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.OI_OS_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.OI_GOVT_INSTITUTION_CD:IGS_LOOKUP_VALUES:OR_INST_GOV_CD:MEANING'
, '_LA:PHP.OI_INST_CONTROL_TYPE:IGS_LOOKUP_VALUES:OR_INST_CTL_TYPE:MEANING'
, PHP.OI_INSTITUTION_TYPE
, PHP.OI_INSTITUTION_STATUS
, PHP.INST_EPS_CODE
, PHP.INST_PHONE_COUNTRY_CODE
, PHP.INST_PHONE_AREA_CODE
, PHP.INST_PHONE_NUMBER
, PHP.ADV_STUDIES_CLASSES
, PHP.HONORS_CLASSES
, PHP.CLASS_SIZE
, PHP.SEC_SCHOOL_LOCATION_ID
, PHP.PERCENT_PLAN_HIGHER_EDU
, '_LA:PHP.INST_PRIORITY_CD:IGS_LOOKUP_VALUES:OR_INST_PRIORITY_CD:MEANING'
, OIT.DESCRIPTION
, INS.DESCRIPTION
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.LAST_UPDATED_BY
, PHP.LAST_UPDATE_DATE
, PHP.LAST_UPDATE_LOGIN
FROM IGS_PE_HZ_PARTIES PHP
, HZ_PARTIES HP
, IGS_OR_ORG_INST_TYPE_ALL OIT
, IGS_OR_INST_STAT INS
WHERE HP.PARTY_ID = PHP.PARTY_ID
AND PHP.OI_INSTITUTION_TYPE = OIT.INSTITUTION_TYPE(+)
AND PHP.OI_INSTITUTION_STATUS = INS.INSTITUTION_STATUS(+)
AND HP.PARTY_TYPE = 'ORGANIZATION'
AND PHP.INST_ORG_IND = 'I' WITH READ ONLY