VIEW: APPS.AS_L_SITES_ACTIVE_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')