INV Material Transactions Summary
Description
Categories: Enginatics
Repository: Github
Repository: Github
Summary report of Inventory item movement including transaction type, source type, and transaction ID’s.
Run
INV Material Transactions Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select count(*) count, &org_cols &item_cols xxen_util.meaning(mmt.transaction_action_id,'MTL_TRANSACTION_ACTION',700) transaction_action, mtt.transaction_type_name transaction_type, mtst.transaction_source_type_name source_type, mmt.transaction_action_id, mmt.transaction_type_id, mmt.transaction_source_type_id from mtl_material_transactions mmt, mtl_transaction_types mtt, mtl_txn_source_types mtst, (select msiv.* from mtl_system_items_vl msiv where '&show_item'='Y') msiv, mtl_parameters mp, mtl_parameters mp2 where 1=1 and mmt.transaction_type_id=mtt.transaction_type_id and mtt.transaction_source_type_id=mtst.transaction_source_type_id(+) and mmt.organization_id=msiv.organization_id(+) and mmt.inventory_item_id=msiv.inventory_item_id(+) and mmt.organization_id=mp.organization_id(+) and mmt.transfer_organization_id=mp2.organization_id(+) group by &org_group_by &item_group_by mtt.transaction_type_name, mtst.transaction_source_type_name, mmt.transaction_action_id, mmt.transaction_type_id, mmt.transaction_source_type_id order by count(*) desc |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Level |
|
LOV | |
Item |
|
LOV | |
Transaction within Days |
|
Number | |
Transaction Date From |
|
DateTime | |
Transaction Date To |
|
DateTime | |
Source Type |
|
LOV | |
Exclude Source Type |
|
LOV | |
Action |
|
LOV | |
Exclude Action |
|
LOV | |
Transaction Type |
|
LOV | |
Exclude Transaction Type |
|
LOV | |
Created By |
|
LOV | |
Exclude Logical Transactions |
|
LOV | |
Organization Code |
|
LOV Oracle | |
Subinventory |
|
LOV |