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

Where can I get the field of Transaction Type from Transaction History

edited Dec 20, 2024 12:26PM in Manufacturing 5 comments

Summary

I am trying to identify the transaction type from the transaction history.

I have attached a picture here for your reference


So far, I have determined how to obtain the "Operation Completion" and "Resource Charging" details by combining data from the tables WIE_OPERATION_TRANSACTIONS and WIE_RESOURCE_TRANSACTIONS with FND_LOOKUP_VALUES_VL. However, I am unsure how to find the transaction type for "Material issue" While I can locate it in FND_LOOKUP_VALUES_VL using lookup_type values such as 'ORA_CSE_ENTITLE_TYPE' or 'ORA_WIE_MTL_TXN_TYPE', I still do not know which transaction table records

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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