Skip to content
[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 |
APPS.ASO_I_PARTY_SITES_V