[Home] [Help]
View: ICX_SO_BILL_TO_ADDRESSES_V
| Product: | ICX - Oracle iProcurement |
|---|
| Description: | Order Entry Bill-to Address View |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT RA.CUSTOMER_ID
, RA.ADDRESS1
, RA.ADDRESS2
, RA.ADDRESS3
, RA.ADDRESS4
, RA.CITY||'
, '||RA.STATE||' '||RA.POSTAL_CODE ADDRESS5
, RA.CITY
, RA.STATE
, RA.POSTAL_CODE
, RA.ADDRESS_ID
, RSU.LOCATION
, RSU.SITE_USE_ID
, RSU.GSA_INDICATOR
FROM RA_ADDRESSES RA
, RA_SITE_USES RSU
WHERE RA.STATUS = 'A'
AND RA.ADDRESS_ID = RSU.ADDRESS_ID
AND RSU.STATUS = 'A'
AND RSU.SITE_USE_CODE = 'BILL_TO'
Columns
| Name |
| CUSTOMER_ID |
| ADDRESS1 |
| ADDRESS2 |
| ADDRESS3 |
| ADDRESS4 |
| ADDRESS5 |
| CITY |
| STATE |
| POSTAL_CODE |
| ADDRESS_ID |
| LOCATION |
| SITE_USE_ID |
| GSA_INDICATOR |