[Home] [Help]
View: SO_CUSTOMERS_ACTIVE_V
Product: | OE - Order Entry |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_ID
, NVL(GSA_INDICATOR
, 'N') GSA_INDICATOR
FROM RA_CUSTOMERS
WHERE STATUS = 'A'
AND NVL(CUSTOMER_PROSPECT_CODE
, 'CUSTOMER') = 'CUSTOMER'
Columns
Name |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_ID |
GSA_INDICATOR |