[Home] [Help]
View: ASO_I_PARTY_SITES_V
View Text
SELECT PARTY_SITE.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, LOC.LOCATION_ID
, PARTY_SITE.IDENTIFYING_ADDRESS_FLAG
, PARTY_SITE.START_DATE_ACTIVE
, PARTY_SITE.END_DATE_ACTIVE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, LOC.COUNTRY COUNTRY_CODE
, TERR.TERRITORY_SHORT_NAME
FROM HZ_LOCATIONS LOC
, HZ_PARTY_SITES PARTY_SITE
, FND_TERRITORIES_VL TERR
WHERE PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND LOC.COUNTRY = TERR.TERRITORY_CODE
Columns
Name |
PARTY_ID |
PARTY_SITE_ID |
LOCATION_ID |
IDENTIFYING_ADDRESS_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
POSTAL_CODE |
STATE |
PROVINCE |
COUNTY |
COUNTRY_CODE |
COUNTRY |