DBA Data[Home] [Help]

APPS.GML_RCV_DB_COMMON dependencies on OE_LOT_SERIAL_NUMBERS

Line 272: From oe_lot_Serial_numbers

268: -- since we do not allow duplicate lots on the lot serial form while receiving. So person has to
269: -- receive in one lot..sum up the quantities.
270: Select nvl(SUM(QUANTITY),0)
271: Into l_rma_lot_qty
272: From oe_lot_Serial_numbers
273: Where (line_id = p_oe_line_id OR line_set_id = p_line_set_id)
274: And lot_number = p_lot_no
275: And nvl(sublot_number,' ') = nvl(p_sublot_no,' ');
276: