[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 |