[Home] [Help]
View: WSH_CARRIER_SITE_DETAILS_V
View Text
SELECT HP.PARTY_ID
, HPS.PARTY_SITE_ID
, HPS.PARTY_SITE_NUMBER
, HPS.LOCATION_ID
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.POSTAL_CODE
, HL.STATE
, HL.PROVINCE
, HL.COUNTRY
, HL.COUNTY
, HPS.IDENTIFYING_ADDRESS_FLAG
, HPS.STATUS
FROM HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID
Columns
Name |
CARRIER_ID |
CARRIER_SITE_ID |
CARRIER_SITE_NUMBER |
LOCATION_ID |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
POSTAL_CODE |
STATE |
PROVINCE |
COUNTRY |
COUNTY |
PRIMARY |
ACTIVE |