[Home] [Help]
View: POBV_MC_RECEIVING_TRANSACTIONS
View Text
SELECT MT.SET_OF_BOOKS_ID
, SB.NAME
, MT.TRANSACTION_ID
, '_LA:RT.TRANSACTION_TYPE:PO_LOOKUP_CODES:RCV TRANSACTION TYPE:DISPLAYED_FIELD'
, MT.CURRENCY_CONVERSION_DATE
, MT.CURRENCY_CONVERSION_RATE
, MT.CURRENCY_CONVERSION_TYPE
, RT.PO_UNIT_PRICE
FROM RCV_MC_TRANSACTIONS MT
, GL_SETS_OF_BOOKS SB
, RCV_TRANSACTIONS RT
WHERE MT.TRANSACTION_ID = RT.TRANSACTION_ID
AND MT.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID WITH READ ONLY
Columns
Name |
SET_OF_BOOKS_ID |
SET_OF_BOOKS_NAME |
TRANSACTION_ID |
"_LA:TRANSACTION_TYPE" |
CURRENCY_CONVERSION_RATE_DATE |
CURRENCY_CONVERSION_RATE |
CURRENCY_CONVERSION_RATE_TYPE |
PO_UNIT_PRICE |