Product: | ASO - Order Capture |
---|---|
Description: | Stores the Information about the party addresses |
Implementation/DBA Data: | APPS.ASO_I_PARTY_ADDRESSES_V |
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
, USES.SITE_USE_TYPE
, NULL
FROM HZ_LOCATIONS LOC
, HZ_PARTY_SITES PARTY_SITE
, FND_TERRITORIES_VL TERR
, HZ_PARTY_SITE_USES USES
WHERE PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND LOC.COUNTRY = TERR.TERRITORY_CODE
AND PARTY_SITE.PARTY_SITE_ID = USES.PARTY_SITE_ID