APPS.INV_LABEL_PVT11 dependencies on MTL_LOT_NUMBERS

Line 127: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;

123: l_negation_qty NUMBER;
124:
125: l_print_count NUMBER;
126: l_reprint VARCHAR2(10);
127: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
128:
129: l_dispensing_mode varchar2(100);
130: l_undispensing_mode varchar2(100);
131: l_batch_line varchar2(100);

Line 560: FROM mtl_lot_numbers

556: IF (l_lot_number is not null)
557: THEN
558: SELECT parent_lot_number
559: into l_parent_lot_number
560: FROM mtl_lot_numbers
561: WHERE organization_id = l_organization_id
562: AND inventory_item_id = l_inventory_item_id
563: AND lot_number = l_lot_number;
564: END IF;