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_EDW_COGS_F_SZ dependencies on BOM_DEPARTMENT_RESOURCES

Line 185: FROM bom_department_resources

181: WHERE last_update_date between p_from_date and p_to_date;
182:
183: CURSOR c_avail IS
184: SELECT AVG(Nvl(Vsize(24*capacity_units), 0))
185: FROM bom_department_resources
186: WHERE last_update_date between p_from_date and p_to_date;
187:
188: CURSOR c_trx_date_fk IS
189: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, set_of_books_id) ),0))