APPS.GML_OPM_ROI_GRP dependencies on OE_LOT_SERIAL_NUMBERS

Line 1107: From oe_lot_serial_numbers

1103: l_dummy NUMBER(1);
1104:
1105: CURSOR Cr_lot_exists_line IS
1106: Select 1
1107: From oe_lot_serial_numbers
1108: Where (line_id = p_oe_line_id
1109: or line_set_id =
1110: (select line_set_id
1111: from oe_order_lines_all

Line 1147: from oe_lot_serial_numbers o

1143: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1144:
1145: Cursor Cr_rma_lots Is
1146: Select o.quantity
1147: from oe_lot_serial_numbers o
1148: Where (o.line_id = p_oe_order_line_id
1149: OR
1150: o.line_set_id = x_line_set_id )
1151: AND o.lot_number = p_lot_no