926: l_spec GMD_SPECIFICATIONS%ROWTYPE;
927:
928: CURSOR c_item_lot_number IS
929: SELECT 1
930: FROM mtl_lot_numbers
931: WHERE organization_id = l_inv_vr.organization_id
932: AND inventory_item_id = l_spec.inventory_item_id
933: AND lot_number = l_inv_vr.lot_number;
934:
933: AND lot_number = l_inv_vr.lot_number;
934:
935: CURSOR c_item_parent_lot IS
936: SELECT 1
937: FROM mtl_lot_numbers
938: WHERE organization_id = l_inv_vr.organization_id
939: AND inventory_item_id = l_spec.inventory_item_id
940: AND parent_lot_number = l_inv_vr.parent_lot_number;
941: