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_UTIL

Line 363: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);

359:
360: BEGIN
361:
362: IF p_header_id IS NOT NULL THEN
363: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
364: END IF;
365:
366: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
367: OE_ORDER_UTIL.G_Precision:=2;

Line 366: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

362: IF p_header_id IS NOT NULL THEN
363: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
364: END IF;
365:
366: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
367: OE_ORDER_UTIL.G_Precision:=2;
368: END IF;
369:
370: /* changed following SQL for #3970425 */

Line 367: OE_ORDER_UTIL.G_Precision:=2;

363: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
364: END IF;
365:
366: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
367: OE_ORDER_UTIL.G_Precision:=2;
368: END IF;
369:
370: /* changed following SQL for #3970425 */
371:

Line 372: SELECT SUM(nvl(ROUND(decode(oel.line_category_code,'RETURN',-oel.tax_value,oel.tax_value), OE_ORDER_UTIL.G_Precision),0)),

368: END IF;
369:
370: /* changed following SQL for #3970425 */
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

Line 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))

369:
370: /* changed following SQL for #3970425 */
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

Line 381: SELECT Sum(Nvl(ROUND(adjusted_amount,OE_ORDER_UTIL.G_Precision),0))

377: AND charge_periodicity_code is NULL -- added for recurring charges
378: AND NVL(oel.cancelled_flag,'N') ='N';
379:
380: --TaxER start
381: SELECT Sum(Nvl(ROUND(adjusted_amount,OE_ORDER_UTIL.G_Precision),0))
382: INTO l_tax_hdr_chg
383: FROM oe_price_adjustments
384: WHERE header_id=p_header_id
385: AND line_id IS NULL

Line 582: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270

578: --
579: Is_fmt BOOLEAN; --5716270
580: BEGIN
581:
582: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270
583: -- bug4013565
584: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
585: OE_ORDER_UTIL.G_Precision:=2;
586: END IF;

Line 584: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

580: BEGIN
581:
582: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270
583: -- bug4013565
584: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
585: OE_ORDER_UTIL.G_Precision:=2;
586: END IF;
587:
588:

Line 585: OE_ORDER_UTIL.G_Precision:=2;

581:
582: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270
583: -- bug4013565
584: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
585: OE_ORDER_UTIL.G_Precision:=2;
586: END IF;
587:
588:
589: -- added ROUND in someplaces below for 4013565

Line 596: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))

592: -- p_all_lines 'Y' means to include all lines including all open or closed ones.
593: -- Currently this parameter is only set 'Y' when calling from Payments form.
594: --sol_ord_er #16014165, If Full Billing from OKS then no invoice, hence no payment
595: SELECT
596: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
597: /*, SUM(ROUND(nvl(ool.Ordered_Quantity,0)
598: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))*/ -- sol_ord_er #16014165
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

Line 598: (ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))/ -- sol_ord_er #16014165

594: --sol_ord_er #16014165, If Full Billing from OKS then no invoice, hence no payment
595: SELECT
596: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
597: /*, SUM(ROUND(nvl(ool.Ordered_Quantity,0)
598: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))*/ -- sol_ord_er #16014165
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

Line 599: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))

595: SELECT
596: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
597: /*, SUM(ROUND(nvl(ool.Ordered_Quantity,0)
598: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))*/ -- sol_ord_er #16014165
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

Line 621: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))

617: OR mti.invoice_enabled_flag = 'N'));
618:
619: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
620: -- Select the committment applied amount if Commitment Sequencing "On"
621: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))
622: INTO l_commitment_total
623: FROM oe_payments op
624: WHERE op.header_id = p_header_id
625: AND NOT EXISTS

Line 636: SELECT /SUM(ROUND(nvl(ool.Ordered_Quantity,0) (ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))*/

632: AND (mti.invoiceable_item_flag = 'N'
633: OR mti.invoice_enabled_flag = 'N'));
634: ELSE
635: -- Select the Outbound Extended Price for lines that have committment
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

Line 638: SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))

634: ELSE
635: -- Select the Outbound Extended Price for lines that have committment
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

Line 663: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision

659: -- sol_ord_er #16014165, Freight Charges are not invoiced if billing involves OKS, hence payment should not be made for it.
660:
661: SELECT SUM(
662: ROUND(
663: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision
664: )
665: )
666: INTO l_chgs_wo_line_id
667: FROM OE_PRICE_ADJUSTMENTS P

Line 697: ,OE_ORDER_UTIL.G_Precision

693: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
694: DECODE(L.ORDERED_QUANTITY,0,0,P.OPERAND),
695: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
696: )
697: ,OE_ORDER_UTIL.G_Precision
698: )
699: )
700: INTO l_chgs_w_line_id
701: FROM OE_PRICE_ADJUSTMENTS P,

Line 975: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);

971:
972: BEGIN
973:
974: IF p_header_id IS NOT NULL THEN
975: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
976: END IF;
977:
978: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
979: OE_ORDER_UTIL.G_Precision:=2;

Line 978: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

974: IF p_header_id IS NOT NULL THEN
975: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
976: END IF;
977:
978: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
979: OE_ORDER_UTIL.G_Precision:=2;
980: END IF;
981:
982: /* changed following SQL for #3970425 */

Line 979: OE_ORDER_UTIL.G_Precision:=2;

975: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
976: END IF;
977:
978: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
979: OE_ORDER_UTIL.G_Precision:=2;
980: END IF;
981:
982: /* changed following SQL for #3970425 */
983:

Line 984: SELECT SUM(nvl(ROUND(decode(oel.line_category_code,'RETURN',-oel.tax_value,oel.tax_value), OE_ORDER_UTIL.G_Precision),0)),

980: END IF;
981:
982: /* changed following SQL for #3970425 */
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

Line 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))

981:
982: /* changed following SQL for #3970425 */
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

Line 1422: ,OE_ORDER_UTIL.G_Precision)

1418: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
1419: DECODE(L.ORDERED_QUANTITY,0,0,P.OPERAND),
1420: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
1421: )
1422: ,OE_ORDER_UTIL.G_Precision)
1423: )
1424: INTO x_charges
1425: FROM OE_PRICE_ADJUSTMENTS P,
1426: OE_ORDER_LINES_ALL L