[Home] [Help]
View: RHX_DP_R_CSTCLASS_CUSTOMER_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT CSTCLS.CUSTOMER_CLASS
, CST.CUSTOMER
, CST.CUSTOMER_ID
FROM RHX_DP_L_CSTCLASS_V CSTCLS
, RHX_DP_L_CUSTOMER_V CST
, RA_CUSTOMERS RA
WHERE NVL(RA.CUSTOMER_CLASS_CODE
, 'UNASSIGNED') = CSTCLS.CUSTOMER_CLASS
AND RA.CUSTOMER_ID = CST.CUSTOMER_ID
Columns
Name |
CUSTOMER_CLASS |
CUSTOMER |
CUSTOMER_ID |