Product: | CSC - Customer Care |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSC_CUST_ACCT_SITES_V |
SELECT ACCT_SITES.ROWID
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, ACCT_SITES.PARTY_SITE_ID
, ORG_ID
, ACCT_SITES.STATUS
, BILL_TO_FLAG
, MARKET_FLAG
, SHIP_TO_FLAG
, SERVICE_TERRITORY_ID
, TERRITORY_ID
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, COUNTRY
, TERRITORY.TERRITORY_SHORT_NAME
, ACCT_SITES.LAST_UPDATE_DATE
, ACCT_SITES.LAST_UPDATED_BY
, ACCT_SITES.CREATION_DATE
, ACCT_SITES.CREATED_BY
, ACCT_SITES.LAST_UPDATE_LOGIN
, ACCT_SITES.ATTRIBUTE_CATEGORY
, ACCT_SITES.ATTRIBUTE1
, ACCT_SITES.ATTRIBUTE2
, ACCT_SITES.ATTRIBUTE3
, ACCT_SITES.ATTRIBUTE4
, ACCT_SITES.ATTRIBUTE5
, ACCT_SITES.ATTRIBUTE6
, ACCT_SITES.ATTRIBUTE7
, ACCT_SITES.ATTRIBUTE8
, ACCT_SITES.ATTRIBUTE9
, ACCT_SITES.ATTRIBUTE10
, ACCT_SITES.ATTRIBUTE11
, ACCT_SITES.ATTRIBUTE12
, ACCT_SITES.ATTRIBUTE13
, ACCT_SITES.ATTRIBUTE14
, ACCT_SITES.ATTRIBUTE15
, ACCT_SITES.ATTRIBUTE16
, ACCT_SITES.ATTRIBUTE17
, ACCT_SITES.ATTRIBUTE18
, ACCT_SITES.ATTRIBUTE19
, ACCT_SITES.ATTRIBUTE20
, ACCT_SITES.LANGUAGE
, PARTY_SITES.PARTY_SITE_NAME
FROM HZ_CUST_ACCT_SITES ACCT_SITES
, HZ_LOCATIONS LOCATIONS
, HZ_PARTY_SITES PARTY_SITES
, FND_TERRITORIES_VL TERRITORY
WHERE PARTY_SITES.PARTY_SITE_ID = ACCT_SITES.PARTY_SITE_ID
AND LOCATIONS.LOCATION_ID = PARTY_SITES.LOCATION_ID
AND LOCATIONS.COUNTRY = TERRITORY.TERRITORY_CODE