[Home] [Help]
View: AS_CUST_ACCOUNT_CODES_ACTIVE_V
Product: | AS - Sales Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ADDR.ADDRESS_ID
, ADDR.ADDRESS_ID
, ADDR.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.POSTAL_CODE
, ADDR.COUNTY
, TERR.TERRITORY_SHORT_NAME
, ADDR.ADDRESS3
, ADDR.ADDRESS4
FROM FND_TERRITORIES_VL TERR
, RA_ADDRESSES ADDR
WHERE ADDR.STATUS = 'A'
AND ADDR.COUNTRY = TERR.TERRITORY_CODE
Columns
Name |
ACCOUNT_CODE |
ADDRESS_ID |
CUSTOMER_ID |
ADDRESS1 |
ADDRESS2 |
CITY |
STATE |
PROVINCE |
STATE_PROVINCE |
POSTAL_CODE |
COUNTY |
COUNTRY |
ADDRESS3 |
ADDRESS4 |