[Home] [Help]
View: AS_INVALID_ADDR_ACCOUNT_V
Product: | AS - Sales Foundation |
Description: | View of accounts with invalid addresses |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ADDR.ADDRESS_ID
, CUST.CUSTOMER_ID
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.COUNTY
, ADDR.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CUST.STATUS
, ADDR.STATUS
FROM FND_TERRITORIES_TL TERR
, RA_CUSTOMERS CUST
, RA_ADDRESSES ADDR
, AS_INVALID_ADDR INADDR
WHERE ADDR.CUSTOMER_ID = CUST.CUSTOMER_ID
AND ADDR.CUSTOMER_ID > 0
AND ADDR.ADDRESS_ID = INADDR.ADDRESS_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
Columns
Name |
ADDRESS_ID |
CUSTOMER_ID |
ADDRESS1 |
ADDRESS2 |
CITY |
STATE |
PROVINCE |
COUNTY |
POSTAL_CODE |
COUNTRY |
ADDRESS3 |
ADDRESS4 |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_STATUS |
ADDRESS_STATUS |