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

Line 52: , oe_order_lines_all ool

48: 'AMT',opa.operand,
49: 'NEWPRICE',ool.unit_list_price - opa.operand)
50: INTO adj_line_total_order_modifier
51: FROM oe_price_adjustments opa
52: , oe_order_lines_all ool
53: WHERE opa.HEADER_ID = x_header_id
54: and opa.line_id is null
55: and ool.line_id = x_line_id
56: and ool.header_id = x_header_id

Line 91: , oe_order_lines_all ool

87: 'AMT',opa.operand,
88: 'NEWPRICE',ool.unit_list_price - opa.operand) * NVL(ool.ordered_quantity,0)
89: INTO ext_line_tot_order_modifier
90: FROM oe_price_adjustments opa
91: , oe_order_lines_all ool
92: WHERE opa.HEADER_ID = x_header_id
93: and opa.line_id is null
94: and ool.line_id = x_line_id
95: and ool.header_id = x_header_id

Line 255: FROM oe_order_lines_all

251: CURSOR C1(p_header_id NUMBER,p_line_number NUMBER,p_line_id NUMBER) IS
252: SELECT NVL(Ordered_Quantity,0)*
253: NVL(unit_selling_price,0) Line_details_total,Line_Number,
254: Line_Category_Code
255: FROM oe_order_lines_all
256: WHERE header_id=p_header_id
257: AND (line_number=p_line_number
258: AND NVL(cancelled_flag,'N') ='N'
259: OR (top_model_line_id is not null

Line 274: FROM oe_order_lines_all

270: shipment_number NUMBER)
271: IS
272: SELECT NVL(ordered_quantity,0)-NVL(cancelled_quantity,0)*
273: NVL(unit_selling_price,0) shipment_total,Line_Number
274: FROM oe_order_lines_all
275: WHERE header_id=header_id
276: AND Line_Number=Line_Number
277: AND Shipment_Number=shipment_number
278: AND cancelled_flag='N'; */

Line 319: FROM oe_order_lines_all

315: CURSOR C1(p_header_id NUMBER,p_line_number NUMBER,p_service_number NUMBER) IS
316: SELECT NVL(Ordered_Quantity,0)*
317: NVL(unit_selling_price,0) Line_details_total,Line_Number,
318: Line_Category_Code
319: FROM oe_order_lines_all
320: WHERE header_id=p_header_id
321: AND line_number=p_line_number
322: AND service_number=p_service_number
323: AND NVL(cancelled_flag,'N') ='N'

Line 374: FROM oe_order_lines_all oel

370:
371: SELECT SUM(nvl(ROUND(decode(oel.line_category_code,'RETURN',-oel.tax_value,oel.tax_value), OE_ORDER_UTIL.G_Precision),0)),
372: SUM(ROUND(nvl(oel.Ordered_Quantity,0) * (oel.unit_selling_price) * (decode(oel.line_category_code,'RETURN',-1,1)),OE_ORDER_UTIL.G_Precision))
373: INTO G_TAX_VALUE, G_TOTAL_EXTENDED_PRICE
374: FROM oe_order_lines_all oel
375: WHERE oel.header_id=p_header_id
376: AND charge_periodicity_code is NULL -- added for recurring charges
377: AND NVL(oel.cancelled_flag,'N') ='N';
378:

Line 410: FROM oe_order_lines_all

406: BEGIN
407: SELECT SUM(nvl(Ordered_Quantity,0)
408: *(unit_selling_price))
409: INTO l_config_total
410: FROM oe_order_lines_all
411: WHERE line_id=p_line_id
412: AND NVL(cancelled_flag,'N') ='N';
413:
414: RETURN(l_config_total);

Line 438: FROM oe_order_lines_all

434: IS
435: l_ordered_qty NUMBER :=0;
436: CURSOR C1(p_header_id NUMBER,p_line_number NUMBER) IS
437: SELECT NVL(Ordered_quantity,0) Qty
438: FROM oe_order_lines_all
439: WHERE header_id=p_header_id
440: AND NVL(cancelled_flag,'N') ='N'
441: AND line_number=p_line_number
442: AND item_type_code in ('STANDARD','MODEL','KIT')

Line 585: FROM oe_order_lines_all ool

581: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
582: INTO
583: l_tax_total
584: , l_order_total
585: FROM oe_order_lines_all ool
586: WHERE ool.header_id = p_header_id
587: AND ( (ool.open_flag = 'Y' AND p_all_lines is null)
588: OR nvl(p_all_lines, 'N') = 'Y' )
589: AND ool.line_category_code <> 'RETURN'

Line 608: FROM mtl_system_items mti, oe_order_lines_all ool

604: FROM oe_payments op
605: WHERE op.header_id = p_header_id
606: AND NOT EXISTS
607: (SELECT 'Non Invoiceable Item Line'
608: FROM mtl_system_items mti, oe_order_lines_all ool
609: WHERE ool.line_id = op.line_id
610: AND mti.inventory_item_id = ool.inventory_item_id
611: AND mti.organization_id = nvl(ool.ship_from_org_id,
612: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 619: FROM oe_order_lines_all ool

615: ELSE
616: -- Select the Outbound Extended Price for lines that have committment
617: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
618: INTO l_commitment_total
619: FROM oe_order_lines_all ool
620: WHERE ool.header_id = p_header_id
621: AND ool.commitment_id is not null
622: AND ( (ool.open_flag = 'Y' AND p_all_lines is null)
623: OR nvl(p_all_lines, 'N') = 'Y' )

Line 679: OE_ORDER_LINES_ALL L

675: )
676: )
677: INTO l_chgs_w_line_id
678: FROM OE_PRICE_ADJUSTMENTS P,
679: OE_ORDER_LINES_ALL L
680: WHERE P.HEADER_ID = p_header_id
681: AND P.LINE_ID = L.LINE_ID
682: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
683: AND P.APPLIED_FLAG = 'Y'

Line 777: FROM oe_order_lines_all ool

773: BEGIN
774: SELECT SUM(nvl(ool.Ordered_Quantity,0)
775: *(ool.unit_selling_price))
776: INTO l_order_subtotal
777: FROM oe_order_lines_all ool
778: WHERE ool.header_id = p_header_id
779: AND ool.open_flag = 'Y'
780: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
781: AND ool.line_category_code <> 'RETURN'

Line 831: FROM oe_order_lines_all

827: -- combining 2 SQLs into one for performance
828: SELECT SUM(DECODE(line_category_code, 'RETURN', 0, nvl(Ordered_Quantity,0)*(unit_list_price))),
829: SUM(DECODE(line_category_code, 'RETURN', nvl(Ordered_Quantity,0)*(unit_list_price),0))
830: INTO orders_total, returns_total
831: FROM oe_order_lines_all
832: WHERE header_id=p_header_id
833: AND charge_periodicity_code is null -- Added for Recurring CHarges
834: AND NVL(cancelled_flag,'N') ='N';
835:

Line 963: FROM oe_order_lines_all oel

959:
960: SELECT SUM(nvl(ROUND(decode(oel.line_category_code,'RETURN',-oel.tax_value,oel.tax_value), OE_ORDER_UTIL.G_Precision),0)),
961: SUM(ROUND(nvl(oel.Ordered_Quantity,0) * (oel.unit_selling_price) * (decode(oel.line_category_code,'RETURN',-1,1)),OE_ORDER_UTIL.G_Precision))
962: INTO G_REC_TAX_VALUE, G_REC_TOTAL_EXTENDED_PRICE
963: FROM oe_order_lines_all oel
964: WHERE oel.header_id=p_header_id
965: AND nvl(charge_periodicity_code,'ONE') = p_charge_periodicity_code
966: AND NVL(oel.cancelled_flag,'N') ='N';
967:

Line 1142: from oe_order_lines_all

1138: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
1139: IS
1140: CURSOR C_rec_charge(g_header_id IN NUMBER) IS
1141: select distinct charge_periodicity_code
1142: from oe_order_lines_all
1143: where header_id = g_header_id
1144: and charge_periodicity_code is not null
1145: order by charge_periodicity_code;
1146:

Line 1223: from oe_order_lines_all

1219: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
1220: IS
1221: CURSOR C_rec_charge(g_header_id IN NUMBER) IS
1222: select distinct nvl(charge_periodicity_code,'ONE')
1223: from oe_order_lines_all
1224: where header_id = g_header_id
1225: -- and charge_periodicity_code is not null
1226: order by nvl(charge_periodicity_code,'ONE');
1227:

Line 1309: from oe_order_lines_all

1305: IS
1306:
1307: CURSOR C_rec_charge(g_header_id IN NUMBER,p_line_number IN NUMBER) IS
1308: select distinct nvl(charge_periodicity_code,'ONE')
1309: from oe_order_lines_all
1310: where header_id = g_header_id
1311: -- and charge_periodicity_code is not null
1312: and line_number = p_line_number
1313: order by nvl(charge_periodicity_code,'ONE') desc;

Line 1318: FROM oe_order_lines_all

1314:
1315: CURSOR C_extended(p_header_id IN NUMBER,p_line_Id IN NUMBER,p_line_Number IN NUMBER,p_code IN VARCHAR2) IS
1316: SELECT NVL(Ordered_Quantity,0)*
1317: NVL(unit_selling_price,0) Line_details_total,tax_value,line_category_code
1318: FROM oe_order_lines_all
1319: WHERE header_id=p_header_id
1320: AND nvl(charge_periodicity_code,'ONE')=p_code -- added abghosh
1321: AND (line_number=p_line_number
1322: AND NVL(cancelled_flag,'N') ='N'

Line 1402: OE_ORDER_LINES_ALL L

1398: ,OE_ORDER_UTIL.G_Precision)
1399: )
1400: INTO x_charges
1401: FROM OE_PRICE_ADJUSTMENTS P,
1402: OE_ORDER_LINES_ALL L
1403: WHERE P.HEADER_ID = p_header_id
1404: AND P.LINE_ID = L.LINE_ID
1405: AND nvl(L.CHARGE_PERIODICITY_CODE,'ONE') = l_code
1406: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 1463: FROM oe_order_lines_all

1459: IS
1460:
1461: CURSOR c_charge_periodicity(p_header_id IN NUMBER) IS
1462: SELECT DISTINCT charge_periodicity_code
1463: FROM oe_order_lines_all
1464: WHERE header_id = p_header_id
1465: AND charge_periodicity_code is not null
1466: ORDER BY charge_periodicity_code;
1467: