[Home] [Help]
View: RHX_DP_L_BILLTO_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RAA.ADDRESS_ID
, SUBSTR( RAA.ADDRESS_ID|| RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER')|| RAA.ADDRESS1
, 1
, 240)
FROM RA_ADDRESSES_ALL RAA
, RA_SITE_USES_ALL SU
WHERE RAA.ADDRESS_ID = SU.ADDRESS_ID
AND SU.SITE_USE_CODE = 'BILL_TO'
Columns
Name |
BILL_TO_ADDRESS_ID |
BILL_TO_ADDRESS1 |