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.BIV_DBI_BAK_AGE_PKG dependencies on BIV_DBI_BACKLOG_AGE_DATES

Line 241: from biv_dbi_backlog_age_dates;

237: begin
238:
239: select max(trunc(report_date))
240: into l_current_date
241: from biv_dbi_backlog_age_dates;
242:
243: if(p_comparison_type = 'S') then
244: l_lag:= 1;
245: case p_period_type

Line 519: || ' from biv_dbi_backlog_age_dates '

515: || '( '
516: || ' select trunc(report_date) report_date'
517: || ' , decode(bitand(record_type_id, &BIV_CURR_PATTERN), &BIV_CURR_PATTERN,''Y'',''N'') Cur '
518: || ' , decode(bitand(record_type_id, &BIV_PREV_PATTERN), &BIV_PREV_PATTERN,''Y'',''N'') Pri '
519: || ' from biv_dbi_backlog_age_dates '
520: || ' where '
521: || ' bitand(record_type_id, &BIV_CURR_PATTERN)= &BIV_CURR_PATTERN /* current */ '
522: || ' or bitand(record_type_id, &BIV_PREV_PATTERN)= &BIV_PREV_PATTERN /* prior */ '
523: || ' ) join_dates '

Line 561: || ' from biv_dbi_backlog_age_dates '

557: || '( '
558: || ' select trunc(report_date) report_date'
559: || ' , decode(bitand(record_type_id, &BIV_CURR_PATTERN), &BIV_CURR_PATTERN,''Y'',''N'') Cur '
560: || ' , decode(bitand(record_type_id, &BIV_PREV_PATTERN), &BIV_PREV_PATTERN,''Y'',''N'') Pri '
561: || ' from biv_dbi_backlog_age_dates '
562: || ' where '
563: || ' bitand(record_type_id, &BIV_CURR_PATTERN)= &BIV_CURR_PATTERN /* current */ '
564: || ' or bitand(record_type_id, &BIV_PREV_PATTERN)= &BIV_PREV_PATTERN /* prior */ '
565: || ' ) join_dates '