829: and cel.excess_status = 'P';
830:
831: cursor org_recently_received(p_inventory_item_id number) is
832: select mmt.transaction_date
833: from mtl_material_transactions mmt
834: where mmt.organization_id = p_organization_id
835: and mmt.inventory_item_id = p_inventory_item_id
836: and mmt.transaction_action_id in (2,3,12,27,31)
837: and mmt.transaction_quantity > 0
838: order by transaction_id desc;
839:
840: cursor sub_recently_received(p_inventory_item_id number) is
841: select mmt.transaction_date
842: from mtl_material_transactions mmt
843: where mmt.organization_id = p_organization_id
844: and mmt.subinventory_code = p_subinventory_code
845: and mmt.inventory_item_id = p_inventory_item_id
846: and mmt.transaction_action_id in (2,3,12,27,31)
1843: BEGIN
1844: BEGIN
1845: SELECT SUM(primary_quantity)
1846: INTO l_shipped_qty
1847: FROM mtl_material_transactions
1848: WHERE transaction_action_id = 1
1849: AND source_line_id = p_order_line_id
1850: AND organization_id = p_organization_id
1851: AND inventory_item_id = p_inventory_item_id;