Miscellaneous transactions tables in oracle inventory

Miscellaneous transactions tables in oracle inventory

In this post, We will be discuss about the Miscellaneous transaction tables in oracle inventory. We do enter the Miscellaneous transactions in oracle inventory , When we have to adjust the on hand stock in oracle apps. We have two types of Miscellaneous transactions in oracle inventory and that is called Miscellaneous Receipt and Miscellaneous Issue. Miscellaneous transaction tables helps to store the Miscellaneous transactions created in oracle apps. Here below is the detail Information about  Miscellaneous transactions tables in oracle inventory.

4 Types of Miscellaneous transactions in oracle inventory

Miscellaneous Receipt
Miscellaneous Issue
Miscellaneous Issue(RG Update)
Miscellaneous Receipt(RG Update)

Miscellaneous Receipt & Miscellaneous Issue Transactions :-

 We do enter the Miscellaneous transactions in oracle inventory , When we have to adjust the on hand stock in oracle apps. Miscellaneous Receipt we do create in oracle apps , to increase the Inventory Item Stock in oracle inventory. Miscellaneous Issue we do create in oracle apps , to decrease the Inventory Item Stock in oracle inventory.

Miscellaneous Receipt & Miscellaneous Issue Transactions( RG Update):-

 We do enter the Miscellaneous transactions in oracle inventory , When we have to adjust the on hand stock in oracle apps. Miscellaneous transactions RG update specific for India Taxation requirement but the functionality is more similar like Miscellaneous transactions.

Most Important Miscellaneous transactions tables in oracle inventory

1.MTL_MATERIAL_TRANSACTIONS

2.MTL_Transaction_Types

3.MTL_SYSTEM_ITEMS_B

SQl Query to extract Miscellaneous transactions in oracle inventory

select mtt.transaction_type_name,MMT.INVENTORY_ITEM_ID,MSB.SEGMENT1 ITEM_CODE,MMT.SUBINVENTORY_CODE,MMT.TRANSACTION_QUANTITY,MMT.TRANSACTION_UOM,
MMT.TRANSACTION_DATE,MMT.ACTUAL_COST
from apps.MTL_MATERIAL_TRANSACTIONS MMT, apps.mtl_transaction_types MTT,apps.MTL_SYSTEM_ITEMS_B MSB
Where mmt.transactiON_type_id=mtt.transaction_type_id
and  mtt.transaction_type_name like '%Miscellaneous%'
and MMT.INVENTORY_ITEM_ID=MSB.INVENTORY_ITEM_ID
AND MMT.ORGANIZATION_ID=MSB.ORGANIZATION_ID