[Home] [Help]
View: IGF_SL_LOCAL_INST_V
Product: | IGF - Financial Aid (Obsolete) |
Description: | Displays the Local School Name, Address details. |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
SCHOOL_NAME |
ADDR_USE_TYPE |
ADDR_LINE_1 |
ADDR_LINE_2 |
ADDR_LINE_3 |
ADDR_LINE_4 |
CITY |
STATE |
PROVINCE |
COUNTY |
COUNTRY |
POSTAL_CODE |