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_RESERVATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 144: FROM oe_order_lines_all

140: ELSE
141: BEGIN
142: SELECT ordered_quantity
143: INTO l_requested_qty
144: FROM oe_order_lines_all
145: WHERE line_id = p_demand_source_line_id
146: AND nvl(project_id, -99) = nvl(p_project_id, -99)
147: AND nvl(task_id, -99) = nvl(p_task_id, -99);
148:

Line 557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

553: l_api_name CONSTANT VARCHAR2(30) := 'get_ship_qty_tolerance';
554: l_debug NUMBER;
555: l_primary_uom_code VARCHAR2(3);
556: l_ship_tolerance_above NUMBER; -- INVCONV
557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
561: l_ordered_quantity_primary_uom NUMBER;

Line 558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;

554: l_debug NUMBER;
555: l_primary_uom_code VARCHAR2(3);
556: l_ship_tolerance_above NUMBER; -- INVCONV
557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
561: l_ordered_quantity_primary_uom NUMBER;
562: BEGIN

Line 559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;

555: l_primary_uom_code VARCHAR2(3);
556: l_ship_tolerance_above NUMBER; -- INVCONV
557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
561: l_ordered_quantity_primary_uom NUMBER;
562: BEGIN
563:

Line 560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;

556: l_ship_tolerance_above NUMBER; -- INVCONV
557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
561: l_ordered_quantity_primary_uom NUMBER;
562: BEGIN
563:
564: IF (g_debug IS NULL) THEN

Line 600: FROM oe_order_lines_all

596: l_line_rec_ordered_quantity,
597: l_line_rec_order_quantity_uom,
598: l_line_rec_org_id,
599: l_ship_tolerance_above
600: FROM oe_order_lines_all
601: WHERE line_id = p_demand_line_id;
602: EXCEPTION
603: WHEN no_data_found THEN
604: IF (l_debug =1) THEN

Line 8288: FROM oe_order_lines_all WHERE

8284: AND ((l_rsv_rec.project_id IS NULL) OR
8285: (l_rsv_rec.task_id IS NULL)) THEN
8286: BEGIN
8287: SELECT project_id, task_id INTO l_project_id, l_task_id
8288: FROM oe_order_lines_all WHERE
8289: line_id = l_rsv_rec.demand_source_line_id;
8290: -- Bug 5264987
8291: -- Storing in global variables so that they are not queried again during transfer_reservation
8292: g_oe_line_id := l_rsv_rec.demand_source_line_id;

Line 9841: FROM oe_order_lines_all WHERE

9837: AND ((l_to_rsv_rec.project_id = fnd_api.g_miss_num) OR
9838: (l_to_rsv_rec.task_id = fnd_api.g_miss_num)) THEN
9839: BEGIN
9840: SELECT project_id, task_id INTO l_project_id, l_task_id
9841: FROM oe_order_lines_all WHERE
9842: line_id = l_to_rsv_rec.demand_source_line_id;
9843: EXCEPTION
9844: WHEN no_data_found THEN
9845: IF l_debug=1 THEN

Line 10264: FROM oe_order_lines_all

10260: BEGIN
10261: SELECT open_flag, booked_flag
10262: INTO l_open_flag,
10263: l_booked_flag
10264: FROM oe_order_lines_all
10265: WHERE line_id = l_to_rsv_rec.demand_source_line_id;
10266: EXCEPTION WHEN no_data_found THEN
10267: fnd_message.set_name('INV', 'INV_INVALID_SALES_ORDER');
10268: fnd_msg_pub.ADD;

Line 12782: FROM oe_order_lines_all WHERE

12778: l_task_id := g_task_id;
12779: ELSE
12780: BEGIN
12781: SELECT project_id, task_id INTO l_project_id, l_task_id
12782: FROM oe_order_lines_all WHERE
12783: line_id = l_to_rsv_rec.demand_source_line_id;
12784: EXCEPTION
12785: WHEN no_data_found THEN
12786: IF l_debug=1 THEN