[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | IGS_OR_INST_ADDR is used to capture the address of the institution. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HPS.ROWID ROW_ID
, HP.PARTY_NUMBER TCA_PARTY_NUMBER
, IHP.OSS_ORG_UNIT_CD INSTITUTION_CD
, IGSPS.START_DATE START_DT
, IGSPS.START_DATE EFFECTIVE_DT
, IGSPS.END_DATE END_DT
, PSU.SITE_USE_TYPE
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4 /*
, HL.ADDR_LINE_5*/
, HL.CREATED_BY
, HL.CREATION_DATE
, HL.LAST_UPDATED_BY
, HL.LAST_UPDATE_DATE
, HL.LAST_UPDATE_LOGIN
, TO_DATE (NULL) DATE_LAST_VERIFIED
, HPS.IDENTIFYING_ADDRESS_FLAG
, HL.CITY
, HL.STATE
, HL.PROVINCE
, HL.COUNTY
, HL.COUNTRY
, HL.POSTAL_CODE
, HL.DELIVERY_POINT_CODE
, NULL OTHER_DETAILS_1
, NULL OTHER_DETAILS_2
, NULL OTHER_DETAILS_3
, HL.REQUEST_ID
, HL.PROGRAM_APPLICATION_ID
, HL.PROGRAM_ID
, HL.PROGRAM_UPDATE_DATE
, HPS.STATUS
FROM HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, IGS_PE_HZ_PTY_SITES IGSPS
, HZ_LOCATIONS HL
, HZ_PARTY_SITE_USES PSU
, IGS_PE_HZ_PARTIES IHP
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HP.PARTY_ID = IHP.PARTY_ID(+)
AND HPS.LOCATION_ID = HL.LOCATION_ID
AND HPS.PARTY_SITE_ID = PSU.PARTY_SITE_ID(+)
AND HPS.PARTY_SITE_ID = IGSPS.PARTY_SITE_ID (+)