[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 |
APPS.AST_L_CONTACT_ADDR_V