DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_LOT_SERIAL_NUMBERS

Line 5939: FROM oe_lot_serial_numbers

5935: END IF;
5936: p_x_lot_serial_tbl(I).line_id := l_line_id;
5937:
5938: SELECT 1 into l_count
5939: FROM oe_lot_serial_numbers
5940: WHERE line_id = l_line_id
5941: AND orig_sys_lotserial_ref =
5942: p_x_lot_serial_tbl(I).orig_sys_lotserial_ref
5943: AND rownum < 2;

Line 5979: FROM oe_lot_serial_numbers

5975: END IF;
5976: p_x_lot_serial_tbl(I).line_id := l_line_id;
5977: SELECT lot_serial_id
5978: INTO l_lot_serial_id
5979: FROM oe_lot_serial_numbers
5980: WHERE line_id = l_line_id
5981: AND orig_sys_lotserial_ref =
5982: p_x_lot_serial_tbl(I).orig_sys_lotserial_ref;
5983: