VIEW: APPS.IGS_OR_INST_ADDR

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)