View: AS_L_SITES_ACTIVE_V

Product:	AS - Sales Foundation
Description:	Account code
Implementation/DBA Data:	APPS.AS_L_SITES_ACTIVE_V

View Text

SELECT ADDR.PARTY_SITE_ID
, CUST.PARTY_ID
, CUST.PARTY_ID
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.STATE || DECODE(ADDR.STATE
, NULL
, NULL
, DECODE(ADDR.PROVINCE
, NULL
, NULL
, '/')) || 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
FROM AS_PARTY_CUSTOMERS_V CUST
, AS_PARTY_ADDRESSES_V ADDR
, FND_TERRITORIES_TL TERR
WHERE ADDR.PARTY_ID = CUST.PARTY_ID
AND ADDR.STATUS = 'A'
AND CUST.CUSTOMER_STATUS_CODE = 'A'
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')

Columns