eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: SO_BILL_TO_LOCATIONS_ACTIVE_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RSU.SITE_USE_ID
, RSU.LOCATION
, RSU.GSA_INDICATOR
, RAC.CUSTOMER_ID
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, RA.ADDRESS_ID
, RA.ADDRESS1
, RA.ADDRESS2
, RA.ADDRESS3
, RA.ADDRESS4
, RA.CITY||'
, '||RA.STATE||' '||RA.POSTAL_CODE ADDRESS5
, RA.CITY
, RA.STATE
, RA.POSTAL_CODE
FROM RA_ADDRESSES RA
, RA_SITE_USES RSU
, RA_CUSTOMERS RAC
WHERE RA.STATUS = 'A'
AND RA.ADDRESS_ID = RSU.ADDRESS_ID
AND RSU.STATUS = 'A'
AND RSU.SITE_USE_CODE = 'BILL_TO'
AND RAC.CUSTOMER_ID = RA.CUSTOMER_ID
AND RAC.STATUS = 'A'
AND NVL(RAC.CUSTOMER_PROSPECT_CODE
, 'CUSTOMER') = 'CUSTOMER'

Columns

Name
SITE_USE_ID
LOCATION
GSA_INDICATOR
CUSTOMER_ID
CUSTOMER_NAME
CUSTOMER_NUMBER
ADDRESS_ID
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
ADDRESS5
CITY
STATE
POSTAL_CODE