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.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_ORDER_LINES

Line 409: FROM oe_order_lines

405: -- action code as 'D'
406:
407: SELECT item_type_code
408: INTO l_item_type_code
409: FROM oe_order_lines
410: WHERE line_id = l_line_id;
411:
412: --{ bug3831490 starts
413: IF l_item_type_code <> 'CONFIG' THEN

Line 503: FROM oe_order_lines

499:
500:
501: SELECT shipping_interfaced_flag, header_id
502: INTO l_shipping_interfaced_flag, l_header_id
503: FROM oe_order_lines
504: WHERE line_id = l_line_id;
505: IF g_debug_call > 0 THEN
506: G_DEBUG_MSG := G_DEBUG_MSG || '10,';
507: END IF;

Line 760: UPDATE oe_order_lines

756:
757: /* AG: Change to check if the ASO is installed and then only
758: call Process_Requests_And_Notify */
759:
760: UPDATE oe_order_lines
761: SET flow_status_code = 'SHIPPED',
762: shipped_quantity = 0,
763: last_update_date = SYSDATE,
764: last_updated_by = FND_GLOBAL.USER_ID,

Line 1327: FROM wsh_delivery_details wdd, oe_order_lines line

1323: ;
1324: IF ( l_exist_dd_count > 0 ) THEN
1325: SELECT Count(*)
1326: INTO l_non_cxl_dd_count
1327: FROM wsh_delivery_details wdd, oe_order_lines line
1328: WHERE wdd.source_line_id = line.line_id
1329: AND wdd.source_code = 'OE'
1330: AND wdd.source_line_id = l_changed_attributes(I).source_line_id
1331: AND Nvl(wdd.released_status, 'N') <> 'D'

Line 1379: -- update oe_order_lines set ship_from_org_id = 99

1375:
1376: ELSE ------- success, call catch DCP code ----------
1377:
1378: -- temp for testing only
1379: -- update oe_order_lines set ship_from_org_id = 99
1380: -- where line_id = l_changed_attributes(1).source_line_id;
1381:
1382: IF l_changed_attributes.COUNT = 1 AND
1383: l_changed_attributes(1).action_flag = 'D' THEN

Line 1396: FROM oe_order_lines

1392: l_header_id := nvl(l_line_rec.header_id, l_header_id);
1393: IF l_header_id is NULL THEN
1394: SELECT header_id
1395: INTO l_header_id
1396: FROM oe_order_lines
1397: WHERE line_id = l_changed_attributes(1).source_line_id;
1398: END IF;
1399:
1400:

Line 1717: FROM OE_ORDER_LINES

1713: l_line_rec.item_type_code,
1714: l_line_rec.inventory_item_id,
1715: l_line_rec.order_quantity_uom,
1716: l_line_rec.shipping_quantity_uom
1717: FROM OE_ORDER_LINES
1718: WHERE line_id = p_line_rec.top_model_line_id;
1719:
1720: IF l_debug_level > 0 THEN
1721: oe_debug_pub.add('SHIPPED QUANTITY : '

Line 2407: update oe_order_lines

2403: oe_debug_pub.add( 'ONE OF THE LINE HAS BEEN OVER SHIPPED , MAKE THE MODEL REMNANT '||P_X_LINE_TBL ( 1 ) .TOP_MODEL_LINE_ID , 3 ) ;
2404: END IF;
2405:
2406:
2407: update oe_order_lines
2408: set model_remnant_flag = 'Y'
2409: where top_model_line_id = p_x_line_tbl(1).top_model_line_id;
2410:
2411: IF l_debug_level > 0 THEN

Line 2884: UPDATE OE_ORDER_LINES_ALL

2880: IF nvl(l_line_tbl(l_top_model_index).ship_tolerance_below,0) <> 0 OR
2881: nvl(l_line_tbl(l_top_model_index).ship_tolerance_above,0) <> 0 THEN
2882:
2883:
2884: UPDATE OE_ORDER_LINES_ALL
2885: SET SHIP_TOLERANCE_BELOW = 0,
2886: SHIP_TOLERANCE_ABOVE = 0
2887: WHERE TOP_MODEL_LINE_ID = l_line_tbl(l_top_model_index).line_id;
2888:

Line 3374: FROM oe_order_lines

3370: INTO l_shipped_quantity, l_requested_qty_uom
3371: FROM wsh_delivery_details
3372: WHERE source_line_id in
3373: (SELECT line_id
3374: FROM oe_order_lines
3375: WHERE line_set_id = l_line_rec.line_set_id
3376: AND shipped_quantity IS NULL
3377: AND line_id <> l_line_rec.line_id)
3378: AND source_code = 'OE'

Line 3704: FROM oe_order_lines

3700: IF l_line_rec.item_type_code = 'CONFIG' THEN
3701:
3702: SELECT ato_line_id
3703: INTO l_line_rec.ato_line_id
3704: FROM oe_order_lines
3705: WHERE line_id = l_line_rec.line_id;
3706:
3707: Handle_Config_Parent
3708: ( p_ato_line_id => l_line_rec.ato_line_id);

Line 4750: FROM oe_order_lines,wf_item_activity_statuses wias,

4746: --
4747:
4748: CURSOR c_lines IS
4749: SELECT line_id
4750: FROM oe_order_lines,wf_item_activity_statuses wias,
4751: wf_process_activities wpa
4752: WHERE header_id = l_header_id
4753: AND top_model_line_id = l_top_model_line_id
4754: AND link_to_line_id = p_line_id

Line 4856: FROM OE_ORDER_LINES_ALL

4852: l_item_type_code,
4853: l_header_id,
4854: l_model_remnant_flag,
4855: l_ship_from_org_id
4856: FROM OE_ORDER_LINES_ALL
4857: WHERE LINE_ID = p_line_id;
4858:
4859: END IF; -- bulk mode switch
4860:

Line 5182: FROM oe_order_lines

5178: END IF;
5179:
5180: SELECT explosion_date
5181: INTO l_parent_explosion_date
5182: FROM oe_order_lines
5183: WHERE top_model_line_id = l_top_model_line_id
5184: AND header_id = l_header_id
5185: AND line_id = l_link_to_line_id;
5186:

Line 5485: FROM oe_order_lines

5481:
5482: BEGIN
5483: SELECT 'X'
5484: INTO l_dummy
5485: FROM oe_order_lines
5486: WHERE top_model_line_id = p_top_model_line_id
5487: AND ato_line_id = l_line_tbl(l_line_index).ato_line_id
5488: AND item_type_code = 'CONFIG';
5489: EXCEPTION

Line 5705: FROM oe_order_lines_all oe

5701:
5702: CURSOR split_lines IS
5703: SELECT /* MOAC_SQL_CHANGE */ line_id, line_set_id, ordered_quantity, ordered_quantity2,
5704: order_quantity_uom, ordered_quantity_uom2, inventory_item_id
5705: FROM oe_order_lines_all oe
5706: WHERE line_id in
5707: (SELECT line_id
5708: FROM oe_order_lines_all
5709: WHERE line_set_id = p_line_rec.line_set_id

Line 5708: FROM oe_order_lines_all

5704: order_quantity_uom, ordered_quantity_uom2, inventory_item_id
5705: FROM oe_order_lines_all oe
5706: WHERE line_id in
5707: (SELECT line_id
5708: FROM oe_order_lines_all
5709: WHERE line_set_id = p_line_rec.line_set_id
5710: AND line_id <> p_line_rec.line_id)
5711: AND open_flag = 'Y'
5712: AND shipped_quantity is NULL

Line 5790: UPDATE OE_ORDER_LINES

5786: RAISE FND_API.G_EXC_ERROR;
5787: END IF;
5788:
5789:
5790: UPDATE OE_ORDER_LINES
5791: SET shipping_quantity = l_line_set_rec.shipping_quantity,
5792: shipped_quantity = l_line_set_rec.shipped_quantity,
5793: shipping_quantity2 = l_line_set_rec.shipping_quantity2,
5794: shipped_quantity2 = l_line_set_rec.shipped_quantity2,

Line 6040: UPDATE oe_order_lines

6036: l_firm_flag := 'Y';
6037: END IF;
6038:
6039: FORALL I in p_line_rec.line_id.FIRST..p_line_rec.line_id.LAST
6040: UPDATE oe_order_lines
6041: SET shipping_interfaced_flag = 'Y',
6042: flow_status_code = 'AWAITING_SHIPPING',
6043: firm_demand_flag = NVL(l_firm_flag,firm_demand_flag)
6044: WHERE line_id = p_line_rec.line_id(I)