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_RES_UTIL_F_SZ dependencies on EDW_TIME_PKG

Line 123: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, set_of_books_id) ),0))

119: FROM bom_department_resources
120: WHERE last_update_date between p_from_date and p_to_date;
121:
122: CURSOR c_trx_date_fk IS
123: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, set_of_books_id) ),0))
124: FROM gl_sets_of_books;
125:
126: x_res_util_pk NUMBER;
127:

Line 180: -- EDW_TIME_PKG.CAL_DAY_FK(bcd.calendar_date,To_number(hoi.org_information1))

176: + Ceil( l_org.org_code + x_instance_fk + 5 +1 + 1)
177: --res.resource_code||'-'||dept.department_code||'-'||
178: -- mp.organization_code||'-'||inst.instance_code RSRC_FK,
179: + Ceil(l_res.res_code +x_department +l_org.org_code +x_instance_fk +3+1)
180: -- EDW_TIME_PKG.CAL_DAY_FK(bcd.calendar_date,To_number(hoi.org_information1))
181: -- trx_date_fk,
182: + Ceil( x_trx_date_fk +1)
183: -- br.unit_of_measure uom_fk,
184: + Ceil(l_res.uom + 1 )