APPS.INV_ROI_INTEGRATION_GRP dependencies on OE_LOT_SERIAL_NUMBERS

Line 185: FROM oe_lot_serial_numbers

181:
182: -- Bug 4246448 Added nvl
183: CURSOR Cr_lot_exists_line(v_lot_no VARCHAR2) IS
184: SELECT NVL(SUM(QUANTITY),0)
185: FROM oe_lot_serial_numbers
186: WHERE (line_id = p_oe_order_line_id
187: OR line_set_id IN
188: (SELECT line_set_id
189: FROM oe_order_lines_all

Line 378: /*bug11734602,if l_rma_quantity returned from oe_lot_serial_numbers,

374: print_debug('Matching user entered lot with RMA lot :' || l_progress, 1);
375: print_debug('RMA quantity is :' || l_rma_quantity, 1);
376: END IF;
377:
378: /*bug11734602,if l_rma_quantity returned from oe_lot_serial_numbers,
379: since its quantity always be populated with primary qty,considering the code logic
380: in INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity,
381: we should convert the l_rma_quantity into RMA UNIT_OF_MEASURE.*/
382: SELECT unit_of_measure

Line 2612: FROM oe_lot_serial_numbers

2608:
2609:
2610: CURSOR Cr_count_lot IS
2611: SELECT count (*)
2612: FROM oe_lot_serial_numbers
2613: WHERE (line_id = p_oe_order_line_id
2614: OR line_set_id IN
2615: (SELECT line_set_id
2616: FROM oe_order_lines_all

Line 2795: FROM oe_lot_serial_numbers

2791:
2792: /*The below cursor willl be used to fetch the RMA quantity for online transactions.*/
2793: CURSOR Cr_rma_qty_online IS
2794: SELECT SUM(QUANTITY)
2795: FROM oe_lot_serial_numbers
2796: WHERE (line_id = p_oe_order_line_id
2797: OR line_set_id IN
2798: (SELECT line_set_id
2799: FROM oe_order_lines_all

Line 3034: /*bug11734602,if l_rma_quantity returned from oe_lot_serial_numbers,

3030: ---SAVEPOINT val_rma_quant5;
3031:
3032: /* IF RMA unit_of_measure is different than previously received primary unit_of_measure
3033: then convert RMA qty to previously received primary unit_of_measure. */
3034: /*bug11734602,if l_rma_quantity returned from oe_lot_serial_numbers,
3035: since its quantity always be populated with primary qty,it should not be converted again.*/
3036: IF nvl(p_rma_quantity,-1) <> -1 and l_rma_lot_unit_of_measure <> l_lot_recv_unit_of_measure THEN
3037:
3038: IF g_debug = 1 THEN