FND Design Data [Home] [Help]

View: RHX_DP_R_CUSTOMER_SHIPTO_V

Product: MRP - Master Scheduling/MRP
Description: - Retrofitted
Implementation/DBA Data: Not implemented in this database
View Text

SELECT CST.CUSTOMER_ID
, CST.CUSTOMER
, STO.SHIP_TO_ADDRESS1
, STO.SHIP_TO_ADDRESS_ID
FROM RHX_DP_L_CUSTOMER_V CST
, RHX_DP_L_SHIPTO_V STO
, RA_ADDRESSES_ALL RA
WHERE RA.CUSTOMER_ID = CST.CUSTOMER_ID
AND RA.ADDRESS_ID = STO.SHIP_TO_ADDRESS_ID

Columns

Name
CUSTOMER_ID
CUSTOMER
SHIP_TO
SHIP_TO_ADDRESS_ID