872: WHERE transaction_set_id = p_set_id;
873:
874: CURSOR mtln(p_set_id NUMBER) IS
875: SELECT *
876: FROM mtl_transaction_lot_numbers
877: WHERE transaction_id IN(SELECT transaction_id
878: FROM mtl_material_transactions
879: WHERE transaction_set_id = p_set_id);
880:
888: CURSOR mut2(p_set_id NUMBER) IS
889: SELECT *
890: FROM mtl_unit_transactions
891: WHERE transaction_id IN(SELECT serial_transaction_id
892: FROM mtl_transaction_lot_numbers
893: WHERE transaction_id IN(SELECT transaction_id
894: FROM mtl_material_transactions
895: WHERE transaction_set_id = p_set_id));
896: