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.

[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 149: FROM oe_order_lines_all

145: ELSE
146: BEGIN
147: SELECT ordered_quantity , ordered_quantity2
148: INTO l_requested_qty ,l_requested_qty2
149: FROM oe_order_lines_all
150: WHERE line_id = p_demand_source_line_id
151: AND nvl(project_id, -99) = nvl(p_project_id, -99)
152: AND nvl(task_id, -99) = nvl(p_task_id, -99);
153:

Line 794: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

790: l_api_name CONSTANT VARCHAR2(30) := 'get_ship_qty_tolerance';
791: l_debug NUMBER;
792: l_primary_uom_code VARCHAR2(3);
793: l_ship_tolerance_above NUMBER; -- INVCONV
794: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
795: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
796: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
797: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
798: l_ordered_quantity_primary_uom NUMBER;

Line 795: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;

791: l_debug NUMBER;
792: l_primary_uom_code VARCHAR2(3);
793: l_ship_tolerance_above NUMBER; -- INVCONV
794: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
795: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
796: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
797: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
798: l_ordered_quantity_primary_uom NUMBER;
799:

Line 796: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;

792: l_primary_uom_code VARCHAR2(3);
793: l_ship_tolerance_above NUMBER; -- INVCONV
794: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
795: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
796: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
797: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
798: l_ordered_quantity_primary_uom NUMBER;
799:
800: -- MUOM Fulfillment Project

Line 797: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;

793: l_ship_tolerance_above NUMBER; -- INVCONV
794: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
795: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
796: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
797: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
798: l_ordered_quantity_primary_uom NUMBER;
799:
800: -- MUOM Fulfillment Project
801: l_fulfill_base VARCHAR2(1) := 'P';

Line 802: l_line_rec_ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE;

798: l_ordered_quantity_primary_uom NUMBER;
799:
800: -- MUOM Fulfillment Project
801: l_fulfill_base VARCHAR2(1) := 'P';
802: l_line_rec_ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE;
803: BEGIN
804:
805: IF (g_debug IS NULL) THEN
806: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 842: FROM oe_order_lines_all

838: l_line_rec_order_quantity_uom,
839: l_line_rec_org_id,
840: l_ship_tolerance_above,
841: l_line_rec_ordered_quantity2
842: FROM oe_order_lines_all
843: WHERE line_id = p_demand_line_id;
844: EXCEPTION
845: WHEN no_data_found THEN
846: IF (l_debug =1) THEN

Line 8708: FROM oe_order_lines_all WHERE

8704: AND ((l_rsv_rec.project_id IS NULL) OR
8705: (l_rsv_rec.task_id IS NULL)) THEN
8706: BEGIN
8707: SELECT project_id, task_id INTO l_project_id, l_task_id
8708: FROM oe_order_lines_all WHERE
8709: line_id = l_rsv_rec.demand_source_line_id;
8710: -- Bug 5264987
8711: -- Storing in global variables so that they are not queried again during transfer_reservation
8712: g_oe_line_id := l_rsv_rec.demand_source_line_id;

Line 10423: FROM oe_order_lines_all WHERE

10419: AND ((l_to_rsv_rec.project_id = fnd_api.g_miss_num) OR
10420: (l_to_rsv_rec.task_id = fnd_api.g_miss_num)) THEN
10421: BEGIN
10422: SELECT project_id, task_id INTO l_project_id, l_task_id
10423: FROM oe_order_lines_all WHERE
10424: line_id = l_to_rsv_rec.demand_source_line_id;
10425: EXCEPTION
10426: WHEN no_data_found THEN
10427: IF l_debug=1 THEN

Line 10965: FROM oe_order_lines_all

10961: BEGIN
10962: SELECT open_flag, booked_flag
10963: INTO l_open_flag,
10964: l_booked_flag
10965: FROM oe_order_lines_all
10966: WHERE line_id = l_to_rsv_rec.demand_source_line_id;
10967: EXCEPTION WHEN no_data_found THEN
10968: fnd_message.set_name('INV', 'INV_INVALID_SALES_ORDER');
10969: fnd_msg_pub.ADD;

Line 13578: FROM oe_order_lines_all WHERE

13574: l_task_id := g_task_id;
13575: ELSE
13576: BEGIN
13577: SELECT project_id, task_id INTO l_project_id, l_task_id
13578: FROM oe_order_lines_all WHERE
13579: line_id = l_to_rsv_rec.demand_source_line_id;
13580: EXCEPTION
13581: WHEN no_data_found THEN
13582: IF l_debug=1 THEN