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

Line 186: FROM OE_ORDER_LINES_ALL

182: SELECT Line_id, item_type_code,line_set_id,
183: Service_reference_line_id,
184: inventory_item_id,
185: service_reference_type_code --Bug 4946843
186: FROM OE_ORDER_LINES_ALL
187: WHERE Line_id = l_line_id;
188:
189: CURSOR MODEL_SERVICES IS
190: SELECT /* MOAC_SQL_CHANGE */ line_id, header_id

Line 194: FROM oe_order_lines_all

190: SELECT /* MOAC_SQL_CHANGE */ line_id, header_id
191: FROM OE_ORDER_LINES
192: WHERE service_reference_line_id
193: in (SELECT line_id
194: FROM oe_order_lines_all
195: WHERE top_model_line_id = l_line_id1)
196: AND line_id <> l_line_id and
197: inventory_item_id = l_temp_inv_item_id;
198:

Line 2389: FROM oe_order_lines_all

2385:
2386: BEGIN
2387: SELECT header_id
2388: INTO l_header_id
2389: FROM oe_order_lines_all
2390: WHERE line_id = p_entity_id;
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: RAISE;

Line 2472: FROM oe_order_lines_all

2468:
2469: BEGIN
2470: SELECT header_id
2471: INTO l_header_id
2472: FROM oe_order_lines_all
2473: WHERE line_id = p_entity_id;
2474: EXCEPTION
2475: WHEN OTHERS THEN
2476: RAISE;

Line 2544: FROM oe_order_lines_all

2540: l_global_index NUMBER;
2541: CURSOR l_servbill_lin (
2542: p_header_id IN NUMBER) IS
2543: SELECT line_id
2544: FROM oe_order_lines_all
2545: WHERE header_id = p_header_id
2546: AND service_bill_option_code = 'FPOM'
2547: AND service_bill_profile_id IS NOT NULL
2548: AND service_start_date is NOT NULL --16621149

Line 2622: UPDATE oe_order_lines_all

2618: oe_debug_pub.ADD( ' Start Date,End Date are NULL, so Update FirstPeriod Amt and EndDate to NULL');
2619: End If;
2620: End If;
2621: --16621149 end
2622: UPDATE oe_order_lines_all
2623: SET service_first_period_amount = l_first_period_amt,
2624: service_first_period_enddate = l_first_period_enddate
2625: WHERE line_id = p_line_id;
2626: l_old_line_tbl(1) := l_line_rec;

Line 2697: UPDATE oe_order_lines_all

2693: oe_debug_pub.ADD( ' (2) After OKS Get Billed Amount, first_period_amt= '||l_first_period_amt
2694: ||' first_period_enddate= '||l_first_period_enddate);
2695: End If;
2696: -- Update the current line being processed
2697: UPDATE oe_order_lines_all
2698: SET service_first_period_amount = l_first_period_amt,
2699: service_first_period_enddate = l_first_period_enddate
2700: WHERE line_id = l_rec.line_id;
2701: l_old_line_tbl(1) := l_line_rec;

Line 5063: FROM oe_order_lines_all

5059: -- schedule the whole ATO model.
5060: BEGIN
5061: SELECT ship_set_id,arrival_set_id
5062: INTO l_ship_set_id,l_arrival_set_id
5063: FROM oe_order_lines_all
5064: WHERE line_id = l_line_rec.ato_line_id;
5065: EXCEPTION
5066: WHEN OTHERS THEN
5067: l_ship_set_id := null;

Line 5260: UPDATE OE_ORDER_LINES_ALL

5256:
5257: IF p_sch_set_tbl(I).request_type = OE_GLOBALS.G_SCHEDULE_LINE
5258: THEN
5259:
5260: UPDATE OE_ORDER_LINES_ALL
5261: SET
5262: (SCHEDULE_SHIP_DATE,
5263: SCHEDULE_ARRIVAL_DATE,
5264: SHIP_FROM_ORG_ID,

Line 5272: FROM OE_ORDER_LINES_ALL

5268: null,
5269: decode(re_source_flag,'Y',ship_from_org_id,null),
5270: null,
5271: null
5272: FROM OE_ORDER_LINES_ALL
5273: WHERE line_id=l_line_rec.line_id)
5274: WHERE line_id = l_line_rec.line_id;
5275:
5276: ELSE

Line 5277: UPDATE OE_ORDER_LINES_ALL

5273: WHERE line_id=l_line_rec.line_id)
5274: WHERE line_id = l_line_rec.line_id;
5275:
5276: ELSE
5277: UPDATE OE_ORDER_LINES_ALL
5278: SET
5279: SCHEDULE_SHIP_DATE = l_old_line_rec.schedule_ship_date,
5280: SCHEDULE_ARRIVAL_DATE = l_old_line_rec.schedule_arrival_date,
5281: SHIP_FROM_ORG_ID = l_old_line_rec.ship_from_org_id,

Line 5451: /* getting total tax value from oe_order_lines_all table for line id*/

5447: END IF;
5448: l_total_tax:= l_total_tax + l_tax_rec_out_tbl(j).tax_amount ;
5449: END IF;
5450: END LOOP;
5451: /* getting total tax value from oe_order_lines_all table for line id*/
5452: SELECT TAX_VALUE
5453: INTO l_old_total_tax
5454: FROM oe_order_lines_all
5455: WHERE line_id = p_entity_id_tbl(i).entity_id;

Line 5454: FROM oe_order_lines_all

5450: END LOOP;
5451: /* getting total tax value from oe_order_lines_all table for line id*/
5452: SELECT TAX_VALUE
5453: INTO l_old_total_tax
5454: FROM oe_order_lines_all
5455: WHERE line_id = p_entity_id_tbl(i).entity_id;
5456:
5457: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> p_entity_id_tbl(i).entity_id );
5458:

Line 5467: /* updating the tax value and tax line value on oe_order_lines_all table for line id*/

5463: IF l_debug_level > 0 THEN
5464: oe_debug_pub.add('Updateing tax value from '||TO_CHAR(l_old_total_tax)|| ' To ' ||TO_CHAR(l_total_tax) ,2);
5465: END IF;
5466:
5467: /* updating the tax value and tax line value on oe_order_lines_all table for line id*/
5468: UPDATE OE_ORDER_LINES_ALL
5469: SET TAX_VALUE = l_total_tax,
5470: TAX_LINE_VALUE = l_total_tax - l_tax_on_charge --TaxER
5471: WHERE line_id = p_entity_id_tbl(i).entity_id;

Line 5468: UPDATE OE_ORDER_LINES_ALL

5464: oe_debug_pub.add('Updateing tax value from '||TO_CHAR(l_old_total_tax)|| ' To ' ||TO_CHAR(l_total_tax) ,2);
5465: END IF;
5466:
5467: /* updating the tax value and tax line value on oe_order_lines_all table for line id*/
5468: UPDATE OE_ORDER_LINES_ALL
5469: SET TAX_VALUE = l_total_tax,
5470: TAX_LINE_VALUE = l_total_tax - l_tax_on_charge --TaxER
5471: WHERE line_id = p_entity_id_tbl(i).entity_id;
5472: /* getting line record*/

Line 5476: FROM oe_order_lines_all

5472: /* getting line record*/
5473: --TaxER l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> p_entity_id_tbl(i).entity_id );
5474: SELECT payment_type_code
5475: INTO l_payment_type_code
5476: FROM oe_order_lines_all
5477: WHERE line_id = l_line_rec.line_id;
5478: -- Bug 8825061: Update the global picture given that the line attribute
5479: -- "tax_value" has undergone an update.
5480: IF l_debug_level > 0 THEN

Line 5777: FROM oe_order_lines_all

5773: END IF; -- check on l_debug_level
5774: /* getting return count*/
5775: SELECT COUNT(1)
5776: INTO l_return
5777: FROM oe_order_lines_all
5778: WHERE 1 =1
5779: AND header_id = l_header_rec.header_id
5780: AND line_category_code = 'RETURN';
5781: IF l_return = 0 THEN -- logging delayed requests only when return lines are zero

Line 6227: l_cons_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;

6223: l_parent_line_id NUMBER;
6224: l_header_id NUMBER;
6225: --bug#7491829
6226:
6227: l_cons_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
6228: l_ret_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
6229:
6230: CURSOR REFERENCED_LINE is
6231: SELECT return.price_request_code,

Line 6228: l_ret_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;

6224: l_header_id NUMBER;
6225: --bug#7491829
6226:
6227: l_cons_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
6228: l_ret_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
6229:
6230: CURSOR REFERENCED_LINE is
6231: SELECT return.price_request_code,
6232: referenced.pricing_quantity,

Line 6234: FROM OE_ORDER_LINES_ALL return , OE_ORDER_LINES_ALL referenced

6230: CURSOR REFERENCED_LINE is
6231: SELECT return.price_request_code,
6232: referenced.pricing_quantity,
6233: referenced.price_request_code
6234: FROM OE_ORDER_LINES_ALL return , OE_ORDER_LINES_ALL referenced
6235: WHERE return.line_id = p_line_id
6236: and referenced.line_id = return.reference_line_id;
6237:
6238: --bug #7491829

Line 6243: FROM OE_ORDER_LINES_ALL child, OE_ORDER_LINES_ALL parent

6239: CURSOR SPLIT_LINE IS
6240: SELECT parent.header_id,
6241: parent.pricing_quantity,
6242: parent.line_id
6243: FROM OE_ORDER_LINES_ALL child, OE_ORDER_LINES_ALL parent
6244: WHERE child.line_id = p_line_id
6245: and parent.line_id = child.split_from_line_id;
6246: --bug #7491829
6247:

Line 6341: update oe_order_lines_All

6337: END IF;
6338:
6339: --bug 7491829
6340: IF p_action_code = 'SPLIT_NEW' THEN
6341: update oe_order_lines_All
6342: set price_request_code = l_ret_price_request_code
6343: where line_id = p_line_id;
6344: END IF;
6345: --bug 7491829

Line 6934: from oe_order_lines_all

6930: END IF;
6931: Begin
6932: select nvl(ordered_quantity,0)
6933: into l_new_ord_quantity
6934: from oe_order_lines_all
6935: where line_id = p_line_id;
6936: End;
6937: IF l_new_ord_quantity = 0 THEN
6938: IF l_debug_level > 0 THEN