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_CR_V

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

View Text

SELECT RSU.SITE_USE_ID
, RSU.LOCATION
, DECODE(RSU.STATUS
, 'A'
, '*'
, '') SITE_ACTIVE
, RSU.GSA_INDICATOR
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, DECODE(RAC.STATUS
, 'A'
, '*'
, '') CUSTOMER_ACTIVE
, RAC.CUSTOMER_ID
, 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
, DECODE(RA.STATUS
, 'A'
, '*'
, '') ADDRESS_ACTIVE
, RCR.RELATED_CUSTOMER_ID
FROM RA_ADDRESSES RA
, RA_SITE_USES RSU
, RA_CUSTOMERS RAC
, RA_CUSTOMER_RELATIONSHIPS RCR
WHERE RA.ADDRESS_ID = RSU.ADDRESS_ID
AND RSU.SITE_USE_CODE = 'BILL_TO'
AND RAC.CUSTOMER_ID = RA.CUSTOMER_ID
AND NVL(RAC.CUSTOMER_PROSPECT_CODE
, 'CUSTOMER') = 'CUSTOMER'
AND RAC.CUSTOMER_ID = RCR.CUSTOMER_ID(+)

Columns

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