[Home] [Help]
View: POBV_MC_INBOUND_SHIPMENTS
View Text
SELECT MH.SET_OF_BOOKS_ID
, SB.NAME
, MH.SHIPMENT_HEADER_ID
, RH.SHIPMENT_NUM
, RH.RECEIPT_NUM
, MH.CONVERSION_DATE
, MH.CONVERSION_RATE
, MH.CONVERSION_RATE_TYPE
FROM RCV_MC_SHIPMENT_HEADERS MH
, GL_SETS_OF_BOOKS SB
, RCV_SHIPMENT_HEADERS RH
WHERE MH.SHIPMENT_HEADER_ID = RH.SHIPMENT_HEADER_ID
AND MH.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID WITH READ ONLY
Columns
Name |
SET_OF_BOOKS_ID |
SET_OF_BOOKS_NAME |
SHIPMENT_ID |
SHIPMENT_NUMBER |
RECEIPT_NUMBER |
CURRENCY_CONVERSION_RATE_DATE |
CURRENCY_CONVERSION_RATE |
CURRENCY_CONVERSION_RATE_TYPE |