DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_LOT_SERIAL_NUMBERS

Line 6006: FROM oe_lot_serial_numbers

6002: END IF;
6003: p_x_lot_serial_tbl(I).line_id := l_line_id;
6004:
6005: SELECT 1 into l_count
6006: FROM oe_lot_serial_numbers
6007: WHERE line_id = l_line_id
6008: AND orig_sys_lotserial_ref =
6009: p_x_lot_serial_tbl(I).orig_sys_lotserial_ref
6010: AND rownum < 2;

Line 6046: FROM oe_lot_serial_numbers

6042: END IF;
6043: p_x_lot_serial_tbl(I).line_id := l_line_id;
6044: SELECT lot_serial_id
6045: INTO l_lot_serial_id
6046: FROM oe_lot_serial_numbers
6047: WHERE line_id = l_line_id
6048: AND orig_sys_lotserial_ref =
6049: p_x_lot_serial_tbl(I).orig_sys_lotserial_ref;
6050: