[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 |
APPS.WSH_CARRIER_SITE_DETAILS_V