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.POA_BIS_ALERTS dependencies on POA_PURCHASE_SALES_V

Line 477: FROM poa_purchase_sales_v poa,

473: nvl(100*sum((poa.purchase_amount)*nvl(gl.conversion_rate,1))/
474: nvl(sum((poa.sales_amount)*nvl(gl.conversion_rate,1)),1),0)),
475: POA_BIS_ALERTS.g_percent_mask) Actual
476: INTO l_actual
477: FROM poa_purchase_sales_v poa,
478: gl_daily_rates gl
479: WHERE gl.from_currency (+) = poa.currency
480: and gl.to_currency (+) = p_currency
481: and gl.conversion_date (+) = poa.transaction_date

Line 514: FROM poa_purchase_sales_v poa,

510: nvl(100*sum((poa.purchase_amount)*nvl(gl.conversion_rate,1))/
511: nvl(sum((poa.sales_amount)*nvl(gl.conversion_rate,1)),1),0)),
512: POA_BIS_ALERTS.g_percent_mask) Actual
513: INTO l_actual
514: FROM poa_purchase_sales_v poa,
515: gl_daily_rates gl
516: WHERE gl.from_currency (+) = poa.currency
517: and gl.to_currency (+) = p_currency
518: and gl.conversion_date (+) = poa.transaction_date