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 375: FROM oe_order_lines_all oel

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

Line 427: FROM oe_order_lines_all

423: BEGIN
424: SELECT SUM(nvl(Ordered_Quantity,0)
425: *(unit_selling_price))
426: INTO l_config_total
427: FROM oe_order_lines_all
428: WHERE line_id=p_line_id
429: AND NVL(cancelled_flag,'N') ='N';
430:
431: RETURN(l_config_total);

Line 455: FROM oe_order_lines_all

451: IS
452: l_ordered_qty NUMBER :=0;
453: CURSOR C1(p_header_id NUMBER,p_line_number NUMBER) IS
454: SELECT NVL(Ordered_quantity,0) Qty
455: FROM oe_order_lines_all
456: WHERE header_id=p_header_id
457: AND NVL(cancelled_flag,'N') ='N'
458: AND line_number=p_line_number
459: AND item_type_code in ('STANDARD','MODEL','KIT')

Line 603: FROM oe_order_lines_all ool

599: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
600: INTO
601: l_tax_total
602: , l_order_total
603: FROM oe_order_lines_all ool
604: WHERE ool.header_id = p_header_id
605: AND ( (ool.open_flag = 'Y' AND p_all_lines is null)
606: OR nvl(p_all_lines, 'N') = 'Y' )
607: AND ool.line_category_code <> 'RETURN'

Line 627: FROM mtl_system_items mti, oe_order_lines_all ool

623: FROM oe_payments op
624: WHERE op.header_id = p_header_id
625: AND NOT EXISTS
626: (SELECT 'Non Invoiceable Item Line'
627: FROM mtl_system_items mti, oe_order_lines_all ool
628: WHERE ool.line_id = op.line_id
629: AND mti.inventory_item_id = ool.inventory_item_id
630: AND mti.organization_id = nvl(ool.ship_from_org_id,
631: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 640: FROM oe_order_lines_all ool

636: SELECT /*SUM(ROUND(nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))*/
637: -- sol_ord_er #16014165
638: SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
639: INTO l_commitment_total
640: FROM oe_order_lines_all ool
641: WHERE ool.header_id = p_header_id
642: AND ool.commitment_id is not null
643: AND ( (ool.open_flag = 'Y' AND p_all_lines is null)
644: OR nvl(p_all_lines, 'N') = 'Y' )

Line 702: OE_ORDER_LINES_ALL L

698: )
699: )
700: INTO l_chgs_w_line_id
701: FROM OE_PRICE_ADJUSTMENTS P,
702: OE_ORDER_LINES_ALL L
703: WHERE P.HEADER_ID = p_header_id
704: AND P.LINE_ID = L.LINE_ID
705: AND NVL(L.SERVICE_BILL_OPTION_CODE,'FBOM') = 'FBOM' -- sol_ord_er #16014165
706: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 801: FROM oe_order_lines_all ool

797: BEGIN
798: SELECT SUM(nvl(ool.Ordered_Quantity,0)
799: *(ool.unit_selling_price))
800: INTO l_order_subtotal
801: FROM oe_order_lines_all ool
802: WHERE ool.header_id = p_header_id
803: AND ool.open_flag = 'Y'
804: AND ool.charge_periodicity_code is null -- Added for Recurring Charges
805: AND ool.line_category_code <> 'RETURN'

Line 855: FROM oe_order_lines_all

851: -- combining 2 SQLs into one for performance
852: SELECT SUM(DECODE(line_category_code, 'RETURN', 0, nvl(Ordered_Quantity,0)*(unit_list_price))),
853: SUM(DECODE(line_category_code, 'RETURN', nvl(Ordered_Quantity,0)*(unit_list_price),0))
854: INTO orders_total, returns_total
855: FROM oe_order_lines_all
856: WHERE header_id=p_header_id
857: AND charge_periodicity_code is null -- Added for Recurring CHarges
858: AND NVL(cancelled_flag,'N') ='N';
859:

Line 987: FROM oe_order_lines_all oel

983:
984: SELECT SUM(nvl(ROUND(decode(oel.line_category_code,'RETURN',-oel.tax_value,oel.tax_value), OE_ORDER_UTIL.G_Precision),0)),
985: SUM(ROUND(nvl(oel.Ordered_Quantity,0) * (oel.unit_selling_price) * (decode(oel.line_category_code,'RETURN',-1,1)),OE_ORDER_UTIL.G_Precision))
986: INTO G_REC_TAX_VALUE, G_REC_TOTAL_EXTENDED_PRICE
987: FROM oe_order_lines_all oel
988: WHERE oel.header_id=p_header_id
989: AND nvl(charge_periodicity_code,'ONE') = p_charge_periodicity_code
990: AND NVL(oel.cancelled_flag,'N') ='N';
991:

Line 1166: from oe_order_lines_all

1162: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
1163: IS
1164: CURSOR C_rec_charge(g_header_id IN NUMBER) IS
1165: select distinct charge_periodicity_code
1166: from oe_order_lines_all
1167: where header_id = g_header_id
1168: and charge_periodicity_code is not null
1169: order by charge_periodicity_code;
1170:

Line 1247: from oe_order_lines_all

1243: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
1244: IS
1245: CURSOR C_rec_charge(g_header_id IN NUMBER) IS
1246: select distinct nvl(charge_periodicity_code,'ONE')
1247: from oe_order_lines_all
1248: where header_id = g_header_id
1249: -- and charge_periodicity_code is not null
1250: order by nvl(charge_periodicity_code,'ONE');
1251:

Line 1333: from oe_order_lines_all

1329: IS
1330:
1331: CURSOR C_rec_charge(g_header_id IN NUMBER,p_line_number IN NUMBER) IS
1332: select distinct nvl(charge_periodicity_code,'ONE')
1333: from oe_order_lines_all
1334: where header_id = g_header_id
1335: -- and charge_periodicity_code is not null
1336: and line_number = p_line_number
1337: order by nvl(charge_periodicity_code,'ONE') desc;

Line 1342: FROM oe_order_lines_all

1338:
1339: CURSOR C_extended(p_header_id IN NUMBER,p_line_Id IN NUMBER,p_line_Number IN NUMBER,p_code IN VARCHAR2) IS
1340: SELECT NVL(Ordered_Quantity,0)*
1341: NVL(unit_selling_price,0) Line_details_total,tax_value,line_category_code
1342: FROM oe_order_lines_all
1343: WHERE header_id=p_header_id
1344: AND nvl(charge_periodicity_code,'ONE')=p_code -- added abghosh
1345: AND (line_number=p_line_number
1346: AND NVL(cancelled_flag,'N') ='N'

Line 1426: OE_ORDER_LINES_ALL L

1422: ,OE_ORDER_UTIL.G_Precision)
1423: )
1424: INTO x_charges
1425: FROM OE_PRICE_ADJUSTMENTS P,
1426: OE_ORDER_LINES_ALL L
1427: WHERE P.HEADER_ID = p_header_id
1428: AND P.LINE_ID = L.LINE_ID
1429: AND nvl(L.CHARGE_PERIODICITY_CODE,'ONE') = l_code
1430: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 1487: FROM oe_order_lines_all

1483: IS
1484:
1485: CURSOR c_charge_periodicity(p_header_id IN NUMBER) IS
1486: SELECT DISTINCT charge_periodicity_code
1487: FROM oe_order_lines_all
1488: WHERE header_id = p_header_id
1489: AND charge_periodicity_code is not null
1490: ORDER BY charge_periodicity_code;
1491: