eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AS_L_SITES_V

Product:	AS - Sales Foundation
Description:	Account code
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ADDR.PARTY_SITE_ID
, CUST.CUSTOMER_ID
, CUST.PARTY_ID
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.COUNTY
, ADDR.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, ADDR.ADDRESS_ID
, ADDR.PARTY_SITE_ID
, CUST.CUSTOMER_STATUS_CODE
, ADDR.STATUS
FROM FND_TERRITORIES_TL TERR
, AS_PARTY_CUSTOMERS_V CUST
, AS_PARTY_ADDRESSES_V ADDR
WHERE ADDR.PARTY_ID = CUST.PARTY_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')

Columns

Name
SITE_CODE
CUSTOMER_ID
PARTY_ID
ADDRESS1
ADDRESS2
CITY
STATE
PROVINCE
COUNTY
POSTAL_CODE
COUNTRY
ADDRESS3
ADDRESS4
CUSTOMER_NAME
CUSTOMER_NUMBER
ADDRESS_ID
PARTY_SITE_ID
CUSTOMER_STATUS_CODE
ADDRESS_STATUS