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.FII_MV_REFRESH dependencies on FII_AR_REVENUE_B

Line 240: SELECT 1 INTO l_count FROM FII_AR_REVENUE_B

236: FII_UTIL.put_line('');
237: end if;
238:
239: begin
240: SELECT 1 INTO l_count FROM FII_AR_REVENUE_B
241: WHERE ROWNUM = 1;
242: exception
243: when NO_DATA_FOUND then
244: l_count := 0;

Line 247: IF l_count = 0 THEN -- no records in fii_ar_revenue_b

243: when NO_DATA_FOUND then
244: l_count := 0;
245: end;
246:
247: IF l_count = 0 THEN -- no records in fii_ar_revenue_b
248:
249: FII_MESSAGE.write_log(msg_name => 'FII_AR_REV_NO_RECS', token_num => 0);
250:
251: retcode := 1;

Line 255: ELSE -- there are records in fii_ar_revenue_b

251: retcode := 1;
252:
253: RETURN;
254:
255: ELSE -- there are records in fii_ar_revenue_b
256:
257: -----------------------------------------------------------
258: -- If we find record in the base summary table which references
259: -- time records which does not exist in FII_TIME_DAY

Line 271: FROM FII_AR_REVENUE_B t;

267: end if;
268:
269: SELECT MIN(t.gl_date),Max(t.gl_date)
270: INTO l_min, l_max
271: FROM FII_AR_REVENUE_B t;
272:
273: FII_TIME_API.check_missing_date(l_min, l_max, l_check_time_dim);
274:
275: --------------------------------------