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

Line 346: l_existing_fsc oe_order_lines_all.flow_status_code%type; -- Bug 13870263

342: l_header_rec Oe_Order_Pub.Header_Rec_Type;
343: l_line_rec Oe_Order_Pub.Line_Rec_Type;
344: l_ret_stat Varchar2(30);
345: -- 8541809: End
346: l_existing_fsc oe_order_lines_all.flow_status_code%type; -- Bug 13870263
347: --
348: Begin
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'Inside Update Line Flow Status');

Line 358: FROM oe_order_lines_all

354:
355: ------------ Bug 13870263:: Start
356: BEGIN
357: SELECT flow_status_code INTO l_existing_fsc
358: FROM oe_order_lines_all
359: WHERE line_id = p_line_id;
360: EXCEPTION
361: WHEN Others THEN
362: l_existing_fsc := NULL;

Line 385: Update oe_order_lines_all

381: RETURN;
382: END IF; -- Check on existing and new flow status codes.
383: ------------ Bug 13870263::: END
384:
385: Update oe_order_lines_all
386: Set flow_status_code = p_flow_status_code
387: , last_update_date = sysdate --BUG#9539541
388: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541
389: Where line_id = p_line_id;

Line 717: FROM oe_order_lines_all ol, mtl_system_items msi

713: BEGIN
714: /*Bug3261460*/
715: SELECT msi.SERVICEABLE_PRODUCT_FLAG
716: INTO l_serviceable_product_flag
717: FROM oe_order_lines_all ol, mtl_system_items msi
718: WHERE ol.line_id = l_service_reference_line_id
719: AND ol.inventory_item_id = msi.inventory_item_id
720: AND msi.organization_id = nvl(ol.ship_from_org_id, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ol.org_id));
721: EXCEPTION

Line 1081: FROM oe_order_lines_all /* MOAC SQL CHANGE */

1077: SELECT NVL(lt.cust_trx_type_id, 0)
1078: INTO l_inv_cust_trx_type_id
1079: FROM oe_line_types_v lt
1080: WHERE lt.line_type_id = (SELECT line_type_id
1081: FROM oe_order_lines_all /* MOAC SQL CHANGE */
1082: WHERE line_id = p_line_rec.reference_line_id);
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM REFERENCE LINE TYPE : '||L_INV_CUST_TRX_TYPE_ID , 5 ) ;
1085: END IF;

Line 1093: FROM oe_order_lines_all /* MOAC SQL CHANGE */

1089: FROM oe_order_types_v ot,
1090: oe_order_headers_all oh /* MOAC SQL CHANGE */
1091: WHERE ot.order_type_id = oh.order_type_id
1092: AND oh.header_id = (SELECT header_id
1093: FROM oe_order_lines_all /* MOAC SQL CHANGE */
1094: WHERE line_id = p_line_rec.reference_line_id);
1095: END IF;
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM REFERENCE ORDER TYPE : '||L_INV_CUST_TRX_TYPE_ID , 5 ) ;

Line 1450: from OE_ORDER_LINES_ALL

1446: -- Get_Item_Description(l_line_rec, l_item_serviced_desc);
1447: BEGIN
1448: select inventory_item_id,ordered_item_id,sold_to_org_id,item_identifier_type,ordered_item,org_id
1449: into l_inventory_item_id,l_ordered_item_id,l_sold_to_org_id,l_item_identifier_type,l_ordered_item,l_org_id
1450: from OE_ORDER_LINES_ALL
1451: where line_id = l_service_reference_line_id;
1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN
1454: IF l_debug_level > 0 THEN

Line 2281: from oe_order_lines_all where header_id = p_line_rec.header_id and line_set_id = p_line_rec.line_set_id;

2277: -- line is splitted
2278: -- get the total amounts
2279: select sum(nvl(ordered_quantity,0)), sum(nvl(fulfilled_quantity,nvl(shipped_quantity,0))), sum(nvl(invoiced_quantity,0))
2280: into l_unsplit_ordered_qty , l_unsplit_fulfilled_qty, l_unsplit_invoiced_qty
2281: from oe_order_lines_all where header_id = p_line_rec.header_id and line_set_id = p_line_rec.line_set_id;
2282: else
2283: l_unsplit_ordered_qty := nvl(p_line_rec.ordered_quantity,0);
2284: l_unsplit_fulfilled_qty := nvl(p_line_rec.fulfilled_quantity,nvl(p_line_rec.shipped_quantity,0));
2285: l_unsplit_invoiced_qty := nvl(p_line_rec.invoiced_quantity,0);

Line 4183: FROM oe_order_lines_all /Bug3261460/

4179: -- Check if service parent has parent (In case if service parent is an option, class, kit etc)
4180: BEGIN
4181: SELECT top_model_line_id
4182: INTO service_grand_parent_id
4183: FROM oe_order_lines_all /*Bug3261460*/
4184: WHERE line_id = l_service_reference_line_id;
4185: EXCEPTION
4186: WHEN NO_DATA_FOUND THEN
4187: IF l_debug_level > 0 THEN

Line 4716: from oe_order_lines_all

4712:
4713: cursor order_info(c_line_id number)
4714: is
4715: select header_id, line_id
4716: from oe_order_lines_all
4717: where line_id = c_line_id;
4718: --
4719: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4720: --

Line 6233: FROM oe_order_lines_all ool,

6229:
6230: BEGIN
6231: SELECT max(actual_shipment_date)
6232: INTO l_max_actual_shipment_date
6233: FROM oe_order_lines_all ool,
6234: oe_line_sets ols
6235: WHERE ool.shippable_flag = 'Y'
6236: AND ool.line_id = ols.line_id
6237: AND ols.set_id IN (SELECT os.set_id

Line 7191: from oe_order_lines_all

7187: IF l_parent_line_id IS NOT NULL THEN
7188: BEGIN
7189: Select top_model_line_id
7190: into l_top_model_line_id
7191: from oe_order_lines_all
7192: where line_id = l_parent_line_id ;
7193: EXCEPTION WHEN NO_DATA_FOUND THEN
7194: p_x_interface_line_rec.parent_line_id := l_parent_line_id ;
7195: END;

Line 7826: UPDATE OE_ORDER_LINES_ALL

7822: oe_debug_pub.add( ' UPDATING p_line_rec.SERVICE_START_DATE = '||p_line_rec.SERVICE_START_DATE , 5 ) ; -- bug# 7231974
7823: oe_debug_pub.add( ' p_line_rec.SERVICE_END_DATE = '|| p_line_rec.SERVICE_END_DATE , 5 ) ;
7824: END IF;
7825:
7826: UPDATE OE_ORDER_LINES_ALL
7827: SET INVOICE_INTERFACE_STATUS_CODE = p_invoice_interface_status,
7828: INVOICED_QUANTITY = l_invoiced_quantity,
7829: FLOW_STATUS_CODE = l_flow_status_code,
7830: SERVICE_START_DATE = p_line_rec.SERVICE_START_DATE, --bug# 7231974 :- as srvc_dates are derived in OE_INVOICE_PUB, they should be updated in OM tables as well

Line 8993: from oe_order_lines_all where line_id = l_line_rec.line_id

8989: --bug 5336623
8990: begin
8991:
8992: select line_id, lock_control into v_line_id, v_lock_control
8993: from oe_order_lines_all where line_id = l_line_rec.line_id
8994: FOR UPDATE NOWAIT;
8995:
8996: IF l_debug_level > 0 THEN
8997: oe_debug_pub.add('Locking successful');

Line 9100: UPDATE oe_order_lines_all

9096: ||'and End Date'
9097: ||to_char(l_line_rec.SERVICE_END_DATE,'DD-MON-YYYY HH24:MI:SS')
9098: ||' for line_id= '||l_line_rec.line_id);
9099: End IF;
9100: UPDATE oe_order_lines_all
9101: SET SERVICE_START_DATE = l_line_rec.SERVICE_START_DATE,
9102: SERVICE_END_DATE = l_line_rec.SERVICE_END_DATE
9103: WHERE line_id = l_line_rec.line_id;
9104: l_old_line_tbl(1) := l_line_rec;

Line 9147: from oe_order_lines_all l

9143: -- there is no requery happening within the current procedure
9144: BEGIN
9145: Select l.service_first_period_amount , l.service_first_period_enddate
9146: into l_line_rec.service_first_period_amount , l_line_rec.service_first_period_enddate
9147: from oe_order_lines_all l
9148: where l.line_id = l_line_rec.line_id;
9149: EXCEPTION
9150: WHEN NO_DATA_FOUND THEN
9151: IF l_debug_level > 0 THEN