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 743: AND abs(nvl(src.amount,0)) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));

739:
740: IF(CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL) THEN
741: IF(CE_CASH_FCST.G_rp_src_curr_type = 'E')THEN
742: where_clause := where_clause || '
743: AND abs(nvl(src.amount,0)) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
744: ELSIF(CE_CASH_FCST.G_rp_src_curr_type = 'F')THEN
745: --
746: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
747: -- the functional value of the transaction amount

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

745: --
746: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
747: -- the functional value of the transaction amount
748: --
749: -- bug4345353 added the function fnd_number.number_to_canonical
750: IF(CE_CASH_FCST.G_trx_type <> 'OEO')THEN
751: IF(CE_CASH_FCST.G_trx_type = 'XTR')THEN
752: where_clause := where_clause || '
753: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'

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

749: -- bug4345353 added the function fnd_number.number_to_canonical
750: IF(CE_CASH_FCST.G_trx_type <> 'OEO')THEN
751: IF(CE_CASH_FCST.G_trx_type = 'XTR')THEN
752: where_clause := where_clause || '
753: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'
754: AND curr2.currency_code = src.currency_code
755: AND curr2.to_currency = org.currency_code
756: AND org.set_of_books_id = src.set_of_books_id
757: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);

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

755: AND curr2.to_currency = org.currency_code
756: AND org.set_of_books_id = src.set_of_books_id
757: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);
758: ELSE
759: -- bug4345353 added the function fnd_number.number_to_canonical
760: where_clause := where_clause || '
761: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
762: END IF;
763: ELSE

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

757: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);
758: ELSE
759: -- bug4345353 added the function fnd_number.number_to_canonical
760: where_clause := where_clause || '
761: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
762: END IF;
763: ELSE
764: -- bug4345353 added the function fnd_number.number_to_canonical
765: where_clause := where_clause || '

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

760: where_clause := where_clause || '
761: AND abs(src.base_amount) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
762: END IF;
763: ELSE
764: -- bug4345353 added the function fnd_number.number_to_canonical
765: where_clause := where_clause || '
766: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'
767: AND curr2.currency_code = src.currency_code
768: AND curr2.to_currency = org.currency_code

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

762: END IF;
763: ELSE
764: -- bug4345353 added the function fnd_number.number_to_canonical
765: where_clause := where_clause || '
766: AND abs(nvl(src.amount,0)*curr2.exchange_rate) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold)) ||'
767: AND curr2.currency_code = src.currency_code
768: AND curr2.to_currency = org.currency_code
769: AND org.org_id = src.org_id
770: AND curr2.forecast_request_id = '||to_char(CE_CASH_FCST.G_forecast_id);