VIEW: APPS.IGS_OR_ADDR

Source

View Text - Preformatted

SELECT HPS.ROWID ROW_ID , HP.PARTY_NUMBER , HP.START_DT OU_START_DT , IGSPS.START_DATE START_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 IGS_OR_INST_ORG_BASE_V HP, HZ_PARTY_SITES HPS, IGS_PE_HZ_PTY_SITES IGSPS, HZ_LOCATIONS HL, HZ_PARTY_SITE_USES PSU WHERE HP.PARTY_ID = HPS.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
, HP.START_DT OU_START_DT
, IGSPS.START_DATE START_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 IGS_OR_INST_ORG_BASE_V HP
, HZ_PARTY_SITES HPS
, IGS_PE_HZ_PTY_SITES IGSPS
, HZ_LOCATIONS HL
, HZ_PARTY_SITE_USES PSU
WHERE HP.PARTY_ID = HPS.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 (+)