Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get AR Transaction line coresponded unit cost

edited Jul 27, 2020 12:40PM in Costing 5 comments

Summary

How to get AR Transaction line coresponded unit cost

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!