APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 923: from mtl_material_transactions mmt

919: and cel.excess_status = 'P';
920:
921: cursor org_recently_received(p_inventory_item_id number) is
922: select mmt.transaction_date
923: from mtl_material_transactions mmt
924: where mmt.organization_id = p_organization_id
925: and mmt.inventory_item_id = p_inventory_item_id
926: and mmt.transaction_action_id in (2,3,12,27,31)
927: and mmt.transaction_quantity > 0

Line 932: from mtl_material_transactions mmt

928: and mmt.transaction_date > sysdate - br_rec.days_since_receipt;
929:
930: cursor sub_recently_received(p_inventory_item_id number) is
931: select mmt.transaction_date
932: from mtl_material_transactions mmt
933: where mmt.organization_id = p_organization_id
934: and mmt.subinventory_code = p_subinventory_code
935: and mmt.inventory_item_id = p_inventory_item_id
936: and mmt.transaction_action_id in (2,3,12,27,31)

Line 1968: FROM mtl_material_transactions

1964: BEGIN
1965: BEGIN
1966: SELECT SUM(primary_quantity)
1967: INTO l_shipped_qty
1968: FROM mtl_material_transactions
1969: WHERE transaction_action_id = 1
1970: AND source_line_id = p_order_line_id
1971: AND organization_id = p_organization_id
1972: AND inventory_item_id = p_inventory_item_id;