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?

Report message to a moderator

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?

Report message to a moderator

Previous Topic: error in Gapless sequence
Next Topic: How to Reconcile Refund Transactions in Cash Management?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 00:47:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.