[Home] [Help]
View: ONT_PRT_BILL_TO_ADDR_V
| Product: | ONT - Order Management |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT RA.CUSTOMER_ID CUSTOMER_ID
, RA.ADDRESS1 ADDRESS1
, RA.ADDRESS2 ADDRESS2
, RA.ADDRESS3 ADDRESS3
, RA.ADDRESS4 ADDRESS4
, RA.CITY||'
, '||RA.STATE||' '||RA.POSTAL_CODE ADDRESS5
, RA.CITY CITY
, RA.STATE STATE
, RA.POSTAL_CODE
, RA.ADDRESS_ID ADDRESS_ID
, RSU.LOCATION LOCATION
, RSU.SITE_USE_ID SITE_USE_ID
, RSU.GSA_INDICATOR 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 |