View: IGF_SL_LOCAL_INST_V

Product:	IGF - Financial Aid
Description:	Displays the Local School Name, Address details.
Implementation/DBA Data:	APPS.IGF_SL_LOCAL_INST_V

View Text

SELECT HP.PARTY_NAME
, ADDRV.SITE_USE_TYPE
, ADDRV.ADDR_LINE_1
, ADDRV.ADDR_LINE_2
, ADDRV.ADDR_LINE_3
, ADDRV.ADDR_LINE_4
, ADDRV.CITY
, ADDRV.STATE
, ADDRV.PROVINCE
, ADDRV.COUNTY
, ADDRV.COUNTRY
, ADDRV.POSTAL_CODE
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGF_SL_ADDR_V ADDRV
WHERE HP.PARTY_ID = IHP.PARTY_ID
AND IHP.INST_ORG_IND = 'I'
AND IHP.OI_LOCAL_INSTITUTION_IND = 'Y'
AND HP.PARTY_ID = ADDRV.PERSON_ID(+)

Columns