[Home] [Help]
View: AST_L_CONTACT_ADDR_V
View Text
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')
Columns
Name |
CUSTOMER_ID |
PARTY_ID |
CUSTOMER_NAME |
ADDRESS_ID |
PARTY_SITE_ID |
ADDRESS_TYPE |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
POSTAL_CODE |
STATE |
COUNTY |
COUNTRY |
COUNTRY_CODE |