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.MSC_GET_BIS_VALUES dependencies on FND_NUMBER

Line 319: fnd_number.number_to_canonical(nvl(p_out1,0));

315: CLOSE INV_VAL_CURSOR;
316: end if;
317:
318: p_list := p_list ||g_param||
319: fnd_number.number_to_canonical(nvl(p_out1,0));
320:
321: END LOOP;
322: return p_list;
323: END inventory_value_trend;

Line 383: fnd_number.number_to_canonical(v_revenue);

379: v_revenue := nvl(v_revenue,0);
380: v_cost := nvl(v_cost,0);
381: v_profit := v_revenue - v_cost;
382: p_out1 := p_out1 ||g_param||
383: fnd_number.number_to_canonical(v_revenue);
384: p_out2 := p_out2 ||g_param||
385: fnd_number.number_to_canonical(v_cost);
386: p_out3 := p_out3 ||g_param||
387: fnd_number.number_to_canonical(v_profit);

Line 385: fnd_number.number_to_canonical(v_cost);

381: v_profit := v_revenue - v_cost;
382: p_out1 := p_out1 ||g_param||
383: fnd_number.number_to_canonical(v_revenue);
384: p_out2 := p_out2 ||g_param||
385: fnd_number.number_to_canonical(v_cost);
386: p_out3 := p_out3 ||g_param||
387: fnd_number.number_to_canonical(v_profit);
388:
389: END LOOP;

Line 387: fnd_number.number_to_canonical(v_profit);

383: fnd_number.number_to_canonical(v_revenue);
384: p_out2 := p_out2 ||g_param||
385: fnd_number.number_to_canonical(v_cost);
386: p_out3 := p_out3 ||g_param||
387: fnd_number.number_to_canonical(v_profit);
388:
389: END LOOP;
390: END get_item_margin_trend;
391:

Line 718: fnd_number.number_to_canonical(v_revenue);

714: v_cost := nvl(v_cost,0);
715: v_profit := v_revenue - v_cost;
716:
717: p_out1 := p_out1 ||g_param||
718: fnd_number.number_to_canonical(v_revenue);
719: p_out2 := p_out2 ||g_param||
720: fnd_number.number_to_canonical(v_cost);
721: p_out3 := p_out3 ||g_param||
722: fnd_number.number_to_canonical(v_profit);

Line 720: fnd_number.number_to_canonical(v_cost);

716:
717: p_out1 := p_out1 ||g_param||
718: fnd_number.number_to_canonical(v_revenue);
719: p_out2 := p_out2 ||g_param||
720: fnd_number.number_to_canonical(v_cost);
721: p_out3 := p_out3 ||g_param||
722: fnd_number.number_to_canonical(v_profit);
723: elsif p_chart =COST_BREAKDOWN then
724: p_out1 := p_out1 ||g_param||

Line 722: fnd_number.number_to_canonical(v_profit);

718: fnd_number.number_to_canonical(v_revenue);
719: p_out2 := p_out2 ||g_param||
720: fnd_number.number_to_canonical(v_cost);
721: p_out3 := p_out3 ||g_param||
722: fnd_number.number_to_canonical(v_profit);
723: elsif p_chart =COST_BREAKDOWN then
724: p_out1 := p_out1 ||g_param||
725: fnd_number.number_to_canonical(nvl(v_production,0));
726: p_out2 := p_out2 ||g_param||

Line 725: fnd_number.number_to_canonical(nvl(v_production,0));

721: p_out3 := p_out3 ||g_param||
722: fnd_number.number_to_canonical(v_profit);
723: elsif p_chart =COST_BREAKDOWN then
724: p_out1 := p_out1 ||g_param||
725: fnd_number.number_to_canonical(nvl(v_production,0));
726: p_out2 := p_out2 ||g_param||
727: fnd_number.number_to_canonical(nvl(v_purchasing,0));
728: p_out3 := p_out3 ||g_param||
729: fnd_number.number_to_canonical(nvl(v_penalty,0));

Line 727: fnd_number.number_to_canonical(nvl(v_purchasing,0));

723: elsif p_chart =COST_BREAKDOWN then
724: p_out1 := p_out1 ||g_param||
725: fnd_number.number_to_canonical(nvl(v_production,0));
726: p_out2 := p_out2 ||g_param||
727: fnd_number.number_to_canonical(nvl(v_purchasing,0));
728: p_out3 := p_out3 ||g_param||
729: fnd_number.number_to_canonical(nvl(v_penalty,0));
730: p_out4 := p_out4 ||g_param||
731: fnd_number.number_to_canonical(nvl(v_inventory,0));

Line 729: fnd_number.number_to_canonical(nvl(v_penalty,0));

725: fnd_number.number_to_canonical(nvl(v_production,0));
726: p_out2 := p_out2 ||g_param||
727: fnd_number.number_to_canonical(nvl(v_purchasing,0));
728: p_out3 := p_out3 ||g_param||
729: fnd_number.number_to_canonical(nvl(v_penalty,0));
730: p_out4 := p_out4 ||g_param||
731: fnd_number.number_to_canonical(nvl(v_inventory,0));
732: p_out5 := p_out5 ||g_param||
733: fnd_number.number_to_canonical(nvl(v_tp_cost,0));

Line 731: fnd_number.number_to_canonical(nvl(v_inventory,0));

727: fnd_number.number_to_canonical(nvl(v_purchasing,0));
728: p_out3 := p_out3 ||g_param||
729: fnd_number.number_to_canonical(nvl(v_penalty,0));
730: p_out4 := p_out4 ||g_param||
731: fnd_number.number_to_canonical(nvl(v_inventory,0));
732: p_out5 := p_out5 ||g_param||
733: fnd_number.number_to_canonical(nvl(v_tp_cost,0));
734: elsif p_chart =SERVICE_LEVEL then
735: p_out1 := p_out1 ||g_param||

Line 733: fnd_number.number_to_canonical(nvl(v_tp_cost,0));

729: fnd_number.number_to_canonical(nvl(v_penalty,0));
730: p_out4 := p_out4 ||g_param||
731: fnd_number.number_to_canonical(nvl(v_inventory,0));
732: p_out5 := p_out5 ||g_param||
733: fnd_number.number_to_canonical(nvl(v_tp_cost,0));
734: elsif p_chart =SERVICE_LEVEL then
735: p_out1 := p_out1 ||g_param||
736: fnd_number.number_to_canonical(nvl(v_service,0));
737: end if;

Line 736: fnd_number.number_to_canonical(nvl(v_service,0));

732: p_out5 := p_out5 ||g_param||
733: fnd_number.number_to_canonical(nvl(v_tp_cost,0));
734: elsif p_chart =SERVICE_LEVEL then
735: p_out1 := p_out1 ||g_param||
736: fnd_number.number_to_canonical(nvl(v_service,0));
737: end if;
738: END LOOP;
739:
740: END;

Line 778: fnd_number.number_to_canonical(margin);

774: else
775: margin := (revenue-cost)/revenue;
776: end if;
777: p_margin := p_margin || g_param ||
778: fnd_number.number_to_canonical(margin);
779: p_org := p_org ||g_param || org;
780:
781: END LOOP;
782: CLOSE MARGIN_ORG_CURSOR;

Line 1718: fnd_number.number_to_canonical(l_value);

1714: END IF;
1715:
1716: l_value :=round(l_value,6);
1717: p_value_string := p_value_string ||g_param ||
1718: fnd_number.number_to_canonical(l_value);
1719:
1720: END LOOP;
1721: --exception
1722: --when others then

Line 1816: fnd_number.number_to_canonical(nvl(l_target,0));

1812: l_target :=
1813: get_targets(p_chart_type, p_instance_id,p_org_id,v_time_level);
1814:
1815: l_target_list := l_target_list ||g_param||
1816: fnd_number.number_to_canonical(nvl(l_target,0));
1817: END LOOP;
1818:
1819: return l_target_list;
1820: EXCEPTION

Line 2687: fnd_number.number_to_canonical(nvl(l_target,0));

2683:
2684: FOR j in 1 .. g_period_name.LAST LOOP
2685:
2686: l_target_list := l_target_list ||g_param||
2687: fnd_number.number_to_canonical(nvl(l_target,0));
2688: END LOOP;
2689:
2690:
2691: return l_target_list;