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 GL_DAILY_RATES

Line 315: FROM gl_daily_rates gl,

311: TO_CHAR(SUM(NVL(poa.pot_contract_amount,0)*NVL(gl.conversion_rate,1)),
312: l_format_mask)
313: INTO l_leakage_percent, l_total_purchases, l_potential_savings,
314: l_leakage_amount
315: FROM gl_daily_rates gl,
316: poa_bis_savings poa
317: WHERE gl.from_currency (+) = poa.currency_code
318: AND gl.to_currency (+) = p_currency
319: AND gl.conversion_date (+) = poa.rate_date

Line 372: FROM gl_daily_rates gl,

368: TO_CHAR(SUM(NVL(poa.pot_contract_amount,0)*NVL(gl.conversion_rate,1)),
369: l_format_mask)
370: INTO l_leakage_percent, l_total_purchases, l_potential_savings,
371: l_leakage_amount
372: FROM gl_daily_rates gl,
373: poa_bis_savings poa
374: WHERE gl.from_currency (+) = poa.currency_code
375: AND gl.to_currency (+) = p_currency
376: AND gl.conversion_date (+) = poa.rate_date

Line 430: FROM gl_daily_rates gl,

426: TO_CHAR(SUM(NVL(poa.pot_contract_amount,0)*NVL(gl.conversion_rate,1)),
427: l_format_mask)
428: INTO l_leakage_percent, l_total_purchases, l_potential_savings,
429: l_leakage_amount
430: FROM gl_daily_rates gl,
431: poa_bis_savings poa
432: WHERE gl.from_currency (+) = poa.currency_code
433: AND gl.to_currency (+) = p_currency
434: AND gl.conversion_date (+) = poa.rate_date

Line 478: gl_daily_rates gl

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
482: and gl.conversion_type (+) = 'Corporate'

Line 515: gl_daily_rates gl

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
519: and gl.conversion_type (+) = 'Corporate'