How to get AR Transaction line coresponded unit cost
Summary
How to get AR Transaction line coresponded unit costContent
I am trying to get the AR Transaction line item unit cost ( Transaction Source = Distributed Order Orchestration )
i have tried the following sql but i can't connect to the CST_TRANSACTION_COSTS table
SELECT
RCTA.TRX_NUMBER,
ESIV.ITEM_NUMBER,
ESIV.ORGANIZATION_ID--,
--CTC.UNIT_COST
FROM
RA_CUSTOMER_TRX_ALL RCTA,
RA_CUSTOMER_TRX_LINES_ALL RCTL,
CST_INV_TRANSACTIONS CIT,
CST_TRANSACTIONS CT,
--CST_TRANSACTION_COSTS CTC,
EGP_SYSTEM_ITEMS_V ESIV
WHERE 1=1
AND RCTA.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID
AND RCTL.INTERFACE_LINE_ATTRIBUTE5 = CIT.DOO_FULLFILL_LINE_ID
Tagged:
0