DBA Data[Home] [Help]

APPS.INV_MINMAX_HELPER_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 15: FROM mtl_material_transactions

11: BEGIN
12: BEGIN
13: SELECT SUM(primary_quantity)
14: INTO l_shipped_qty
15: FROM mtl_material_transactions
16: WHERE transaction_action_id = 1
17: AND source_line_id = p_order_line_id
18: AND organization_id = p_organization_id
19: AND inventory_item_id = p_inventory_item_id;