[Home] [Help]
View: RHX_DP_R_CUSTOMER_BILLTO_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CST.CUSTOMER_ID
, CST.CUSTOMER
, BTO.BILL_TO_ADDRESS1
, BTO.BILL_TO_ADDRESS_ID
FROM RHX_DP_L_CUSTOMER_V CST
, RHX_DP_L_BILLTO_V BTO
, RA_ADDRESSES_ALL RA
WHERE RA.CUSTOMER_ID = CST.CUSTOMER_ID
AND RA.ADDRESS_ID = BTO.BILL_TO_ADDRESS_ID
Columns
Name |
CUSTOMER_ID |
CUSTOMER |
BILL_TO |
BILL_TO_ADDRESS_ID |