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

Line 804: AND abs(nvl(src.amount,0)) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));

800:
801: IF(CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL) THEN
802: IF(CE_CASH_FCST.G_rp_src_curr_type = 'E')THEN
803: where_clause := where_clause || '
804: AND abs(nvl(src.amount,0)) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
805: ELSIF(CE_CASH_FCST.G_rp_src_curr_type = 'F')THEN
806: --
807: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
808: -- the functional value of the transaction amount

Line 810: -- bug4345353 added the function fnd_number.number_to_canonical

806: --
807: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
808: -- the functional value of the transaction amount
809: --
810: -- bug4345353 added the function fnd_number.number_to_canonical
811: IF(CE_CASH_FCST.G_trx_type <> 'OEO')THEN
812: IF(CE_CASH_FCST.G_trx_type = 'XTR')THEN
813: where_clause := where_clause || '
814: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'

Line 814: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'

810: -- bug4345353 added the function fnd_number.number_to_canonical
811: IF(CE_CASH_FCST.G_trx_type <> 'OEO')THEN
812: IF(CE_CASH_FCST.G_trx_type = 'XTR')THEN
813: where_clause := where_clause || '
814: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'
815: AND curr2.currency_code = src.currency_code
816: AND curr2.to_currency = org.currency_code
817: AND org.set_of_books_id = src.set_of_books_id
818: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);

Line 820: -- bug4345353 added the function fnd_number.number_to_canonical

816: AND curr2.to_currency = org.currency_code
817: AND org.set_of_books_id = src.set_of_books_id
818: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);
819: ELSE
820: -- bug4345353 added the function fnd_number.number_to_canonical
821: where_clause := where_clause || '
822: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
823: END IF;
824: ELSE

Line 822: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));

818: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);
819: ELSE
820: -- bug4345353 added the function fnd_number.number_to_canonical
821: where_clause := where_clause || '
822: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
823: END IF;
824: ELSE
825: -- bug4345353 added the function fnd_number.number_to_canonical
826: where_clause := where_clause || '

Line 825: -- bug4345353 added the function fnd_number.number_to_canonical

821: where_clause := where_clause || '
822: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
823: END IF;
824: ELSE
825: -- bug4345353 added the function fnd_number.number_to_canonical
826: where_clause := where_clause || '
827: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'
828: AND curr2.currency_code = src.currency_code
829: AND curr2.to_currency = org.currency_code

Line 827: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'

823: END IF;
824: ELSE
825: -- bug4345353 added the function fnd_number.number_to_canonical
826: where_clause := where_clause || '
827: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'
828: AND curr2.currency_code = src.currency_code
829: AND curr2.to_currency = org.currency_code
830: AND org.org_id = src.org_id
831: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);