[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 |