Home » Applications » Oracle Fusion Apps & E-Business Suite » Inventory - How do transactions make it to MTL_Material_Transactions table
Inventory - How do transactions make it to MTL_Material_Transactions table [message #227085] Tue, 27 March 2007 05:30 Go to next message
inforeqd51
Messages: 24
Registered: February 2007
Junior Member
Hi,

The project we're doing requires, as Step#1, to track how the following transactions make it to the MTL_material_transactions table

Step#1
--------------------------------
Miscellaneous Issues & Receipts
RMA Receipts
PO Receipts
Sub inventory Issues & Receipts
--------------------------------

Once we know this,
1. we will pull these transactions from the above table into a customized schema
2. Per various reporting needs, we will pull out details for the above transactions from the base tables, using keys from the mtl_material_transaction tables

Can anyone help provide document/metalink pointers/anything else that will help us acheive the step#1 easily?
Re: Inventory - How do transactions make it to MTL_Material_Transactions table [message #227100 is a reply to message #227085] Tue, 27 March 2007 06:06 Go to previous message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
You get the information from WHO columns and transaction_type_id.

Have you checked that columns W.R.T to your requirement?
Previous Topic: error in Gapless sequence
Next Topic: How to Reconcile Refund Transactions in Cash Management?
Goto Forum:
  


Current Time: Sun Dec 04 19:03:57 CST 2016

Total time taken to generate the page: 0.04260 seconds