VIEW: APPS.AST_L_CONTACT_ADDR_V

Source

View Text - Preformatted

SELECT CUST.PARTY_ID , CUST.PARTY_ID , CUST.CUSTOMER_NAME , ADDR.ADDRESS_ID , ADDR.PARTY_SITE_ID , ADDR.ADDRESS_TYPE , ADDR.ADDRESS1 , ADDR.ADDRESS2 , ADDR.ADDRESS3 , ADDR.ADDRESS4 , ADDR.CITY , ADDR.POSTAL_CODE , ADDR.STATE , ADDR.COUNTY , TERR.TERRITORY_SHORT_NAME , ADDR.COUNTRY FROM FND_TERRITORIES_TL TERR, JTF_PARTY_ADDRESSES_V ADDR , AS_PARTY_CUSTOMERS_V CUST WHERE CUST.PARTY_ID = ADDR.PARTY_ID AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+) AND terr.language(+) = userenv('LANG') AND CUST.PARTY_TYPE IN ('PEOPLE','ORGANIZATION')

View Text - HTML Formatted

SELECT CUST.PARTY_ID
, CUST.PARTY_ID
, CUST.CUSTOMER_NAME
, ADDR.ADDRESS_ID
, ADDR.PARTY_SITE_ID
, ADDR.ADDRESS_TYPE
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.POSTAL_CODE
, ADDR.STATE
, ADDR.COUNTY
, TERR.TERRITORY_SHORT_NAME
, ADDR.COUNTRY
FROM FND_TERRITORIES_TL TERR
, JTF_PARTY_ADDRESSES_V ADDR
, AS_PARTY_CUSTOMERS_V CUST
WHERE CUST.PARTY_ID = ADDR.PARTY_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
AND CUST.PARTY_TYPE IN ('PEOPLE'
, 'ORGANIZATION')