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.OPI_DBI_INV_TURNS_PKG dependencies on FII_TIME_DAY_ALL_V

Line 220: from FII_TIME_DAY_ALL_V

216: select start_date
217: from
218: (
219: select distinct WEEK_START_DATE start_date
220: from FII_TIME_DAY_ALL_V
221: where REPORT_DATE between l_min_trx_date and
222: l_max_trx_date
223: union
224: select distinct ENT_PERIOD_START_DATE start_date

Line 225: from FII_TIME_DAY_ALL_V

221: where REPORT_DATE between l_min_trx_date and
222: l_max_trx_date
223: union
224: select distinct ENT_PERIOD_START_DATE start_date
225: from FII_TIME_DAY_ALL_V
226: where REPORT_DATE between l_min_trx_date and
227: l_max_trx_date
228: union
229: select distinct ENT_QTR_START_DATE start_date

Line 230: from FII_TIME_DAY_ALL_V

226: where REPORT_DATE between l_min_trx_date and
227: l_max_trx_date
228: union
229: select distinct ENT_QTR_START_DATE start_date
230: from FII_TIME_DAY_ALL_V
231: where REPORT_DATE between l_min_trx_date and
232: l_max_trx_date
233: union
234: select distinct ENT_YEAR_START_DATE start_date

Line 235: from FII_TIME_DAY_ALL_V

231: where REPORT_DATE between l_min_trx_date and
232: l_max_trx_date
233: union
234: select distinct ENT_YEAR_START_DATE start_date
235: from FII_TIME_DAY_ALL_V
236: where REPORT_DATE between l_min_trx_date and
237: l_max_trx_date
238: )
239: where start_date between l_min_trx_date and l_max_trx_date

Line 345: fii_time_day_all_v cal,

341: g_user_id,
342: sysdate
343: FROM
344: opi_dbi_inv_turns_stg turns,
345: fii_time_day_all_v cal,
346: (SELECT /*+ no_merge */
347: organization_id,
348: trunc (cogs_date) cogs_date,
349: nvl (sum (cogs_val_b), 0) cogs_val_b,