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.

[Home] [Help]

APPS.ISC_DBI_REV_CUM_TREND_PKG dependencies on FII_TIME_DAY

Line 133: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_curr_start;

129: l_temp := NULL;
130:
131: END IF;
132:
133: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_curr_start;
134: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_curr_end;
135: l_id := '(g.report_date_julian between '||l_day_id1|| ' and ' ||l_day_id2 ||')';
136:
137: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_prior_start;

Line 134: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_curr_end;

130:
131: END IF;
132:
133: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_curr_start;
134: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_curr_end;
135: l_id := '(g.report_date_julian between '||l_day_id1|| ' and ' ||l_day_id2 ||')';
136:
137: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_prior_start;
138: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_prior_end;

Line 137: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_prior_start;

133: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_curr_start;
134: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_curr_end;
135: l_id := '(g.report_date_julian between '||l_day_id1|| ' and ' ||l_day_id2 ||')';
136:
137: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_prior_start;
138: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_prior_end;
139: l_id2 := '(g.report_date_julian between '||l_day_id1|| ' and ' ||l_day_id2 ||')';
140:
141: l_sg_sg := to_number(replace(substr(l_sgid,instr(l_sgid,'.') + 1),''''));

Line 138: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_prior_end;

134: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_curr_end;
135: l_id := '(g.report_date_julian between '||l_day_id1|| ' and ' ||l_day_id2 ||')';
136:
137: SELECT report_date_julian INTO l_day_id1 FROM fii_time_day WHERE report_date = l_prior_start;
138: SELECT report_date_julian INTO l_day_id2 FROM fii_time_day WHERE report_date = l_prior_end;
139: l_id2 := '(g.report_date_julian between '||l_day_id1|| ' and ' ||l_day_id2 ||')';
140:
141: l_sg_sg := to_number(replace(substr(l_sgid,instr(l_sgid,'.') + 1),''''));
142: l_sg_res := to_number(replace(substr(l_sgid,1,instr(l_sgid,'.') - 1),''''));

Line 372: FROM FII_TIME_DAY g,

368: NVL(SUM(SUM(f.c_rev_xtd)) OVER
369: (ORDER BY g.report_date - :ISC_CURR_START + to_number('||l_adjust1||')
370: ROWS UNBOUNDED PRECEDING),0) C_REV,
371: 0 P_REV
372: FROM FII_TIME_DAY g,
373: (SELECT time_id,
374: net_booked_amt_'||l_curr_suffix||' C_BOOK_XTD,
375: recognized_amt_'||l_curr_suffix||' C_REV_XTD
376: FROM '||l_mv||' f'

Line 398: FROM FII_TIME_DAY g,

394: to_number(NULL) C_REV,
395: NVL(SUM(SUM(f.p_rev_xtd)) OVER
396: (ORDER BY g.report_date-:ISC_PRIOR_START+to_number('||l_adjust2||')
397: ROWS UNBOUNDED PRECEDING),0) P_REV
398: FROM FII_TIME_DAY g,
399: (SELECT time_id,
400: net_booked_amt_'||l_curr_suffix||' P_BOOK_XTD,
401: recognized_amt_'||l_curr_suffix||' P_REV_XTD
402: FROM '||l_mv||' f'

Line 426: l_custom_rec.attribute_value := 'TIME+FII_TIME_DAY';

422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
423: IF l_period_type = 'FII_TIME_ENT_YEAR' THEN
424: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_PERIOD';
425: ELSE -- l_period_type = 'FII_TIME_ENT_QTR', 'FII_TIME_ENT_PERIOD', 'FII_TIME_WEEK'
426: l_custom_rec.attribute_value := 'TIME+FII_TIME_DAY';
427: END IF;
428: x_custom_output.extend;
429: x_custom_output(1) := l_custom_rec;
430: