[Home] [Help]
View: AS_ACCOUNT_CODES_ACTIVE_V
| Product: | AS - Sales Foundation |
|---|
| Description: | Account codes |
|---|
| 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.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
FROM RA_ADDRESSES ADDR
, FND_TERRITORIES_VL TERR
, RA_CUSTOMERS CUST
WHERE ADDR.CUSTOMER_ID = CUST.CUSTOMER_ID
AND ADDR.STATUS = 'A'
AND CUST.STATUS = 'A'
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
Columns
| Name |
| ACCOUNT_CODE |
| CUSTOMER_ID |
| ADDRESS1 |
| ADDRESS2 |
| CITY |
| STATE |
| PROVINCE |
| STATE_PROVINCE |
| COUNTY |
| POSTAL_CODE |
| COUNTRY |
| ADDRESS3 |
| ADDRESS4 |
| CUSTOMER_NAME |
| CUSTOMER_NUMBER |
| ADDRESS_ID |