eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ROI_INTEGRATION_GRP dependencies on OE_LOT_SERIAL_NUMBERS

Line 181: FROM oe_lot_serial_numbers

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

Line 2505: FROM oe_lot_serial_numbers

2501:
2502:
2503: CURSOR Cr_count_lot IS
2504: SELECT count (*)
2505: FROM oe_lot_serial_numbers
2506: WHERE (line_id = p_oe_order_line_id
2507: OR line_set_id IN
2508: (SELECT line_set_id
2509: FROM oe_order_lines_all

Line 2686: FROM oe_lot_serial_numbers

2682:
2683: /*The below cursor willl be used to fetch the RMA quantity for online transactions.*/
2684: CURSOR Cr_rma_qty_online IS
2685: SELECT SUM(QUANTITY)
2686: FROM oe_lot_serial_numbers
2687: WHERE (line_id = p_oe_order_line_id
2688: OR line_set_id IN
2689: (SELECT line_set_id
2690: FROM oe_order_lines_all