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 362: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);

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

Line 365: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

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

Line 366: OE_ORDER_UTIL.G_Precision:=2;

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

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

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

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

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

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

561: --
562: Is_fmt BOOLEAN; --5716270
563: BEGIN
564:
565: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270
566: -- bug4013565
567: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
568: OE_ORDER_UTIL.G_Precision:=2;
569: END IF;

Line 567: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

563: BEGIN
564:
565: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270
566: -- bug4013565
567: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
568: OE_ORDER_UTIL.G_Precision:=2;
569: END IF;
570:
571:

Line 568: OE_ORDER_UTIL.G_Precision:=2;

564:
565: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id); --5716270
566: -- bug4013565
567: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
568: OE_ORDER_UTIL.G_Precision:=2;
569: END IF;
570:
571:
572: -- added ROUND in someplaces below for 4013565

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

575: -- p_all_lines 'Y' means to include all lines including all open or closed ones.
576: -- Currently this parameter is only set 'Y' when calling from Payments form.
577:
578: SELECT
579: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
580: , SUM(ROUND(nvl(ool.Ordered_Quantity,0)
581: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
582: INTO
583: l_tax_total

Line 581: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))

577:
578: SELECT
579: SUM(ROUND(nvl(ool.tax_value,0), OE_ORDER_UTIL.G_Precision))
580: , SUM(ROUND(nvl(ool.Ordered_Quantity,0)
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

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

598: OR mti.invoice_enabled_flag = 'N'));
599:
600: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
601: -- Select the committment applied amount if Commitment Sequencing "On"
602: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0), OE_ORDER_UTIL.G_Precision))
603: INTO l_commitment_total
604: FROM oe_payments op
605: WHERE op.header_id = p_header_id
606: AND NOT EXISTS

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

613: AND (mti.invoiceable_item_flag = 'N'
614: OR mti.invoice_enabled_flag = 'N'));
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

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

636: -- Select the Outbound Charges Total
637:
638: SELECT SUM(
639: ROUND(
640: DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND), OE_ORDER_UTIL.G_Precision
641: )
642: )
643: INTO l_chgs_wo_line_id
644: FROM OE_PRICE_ADJUSTMENTS P

Line 674: ,OE_ORDER_UTIL.G_Precision

670: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
671: P.OPERAND,
672: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
673: )
674: ,OE_ORDER_UTIL.G_Precision
675: )
676: )
677: INTO l_chgs_w_line_id
678: FROM OE_PRICE_ADJUSTMENTS P,

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

947:
948: BEGIN
949:
950: IF p_header_id IS NOT NULL THEN
951: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
952: END IF;
953:
954: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
955: OE_ORDER_UTIL.G_Precision:=2;

Line 954: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

950: IF p_header_id IS NOT NULL THEN
951: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
952: END IF;
953:
954: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
955: OE_ORDER_UTIL.G_Precision:=2;
956: END IF;
957:
958: /* changed following SQL for #3970425 */

Line 955: OE_ORDER_UTIL.G_Precision:=2;

951: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
952: END IF;
953:
954: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
955: OE_ORDER_UTIL.G_Precision:=2;
956: END IF;
957:
958: /* changed following SQL for #3970425 */
959:

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

956: END IF;
957:
958: /* changed following SQL for #3970425 */
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

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

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

Line 1398: ,OE_ORDER_UTIL.G_Precision)

1394: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
1395: DECODE(L.ORDERED_QUANTITY,0,0,P.OPERAND),
1396: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
1397: )
1398: ,OE_ORDER_UTIL.G_Precision)
1399: )
1400: INTO x_charges
1401: FROM OE_PRICE_ADJUSTMENTS P,
1402: OE_ORDER_LINES_ALL L