eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_RCV_TRANSACTIONS_V2

Product:	AX - Global Accounting Engine
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TO_CHAR(RCV.TRANSACTION_ID)
, RCV.TRANSACTION_DATE
, RCV.DESTINATION_TYPE_CODE
FROM RCV_TRANSACTIONS RCV
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE (MMT.RCV_TRANSACTION_ID (+) = RCV.TRANSACTION_ID
AND RCV.DESTINATION_TYPE_CODE = 'EXPENSE') UNION SELECT TO_CHAR(RCV.TRANSACTION_ID)
, RCV.TRANSACTION_DATE
, RCV.DESTINATION_TYPE_CODE
FROM RCV_TRANSACTIONS RCV
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.RCV_TRANSACTION_ID = RCV.TRANSACTION_ID
AND MMT.TRANSACTION_TYPE_ID IN (18
, 36
, 71) MINUS SELECT SLH.REFERENCE_3
, RCV.TRANSACTION_DATE
, RCV.DESTINATION_TYPE_CODE
FROM AX_SLE_HEADERS SLH
, RCV_TRANSACTIONS RCV
WHERE SLH.REFERENCE_4 IN ('INV_EVENT_1F'
, 'INV_EVENT_27F'
, 'INV_EVENT_29F')
AND RCV.TRANSACTION_ID = SLH.REFERENCE_3

Columns

Name
RCV_TRANSACTION_ID
TRANSACTION_DATE
DESTINATION_TYPE_CODE