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_JOB_RSRC_F_SZ dependencies on EDW_LOCAL_INSTANCE

Line 21: EDW_LOCAL_INSTANCE inst,

17: HR_ORGANIZATION_INFORMATION hoi,
18: GL_SETS_OF_BOOKS gsob,
19: WIP_DISCRETE_JOBS wdj,
20: WIP_REPETITIVE_SCHEDULES wrs,
21: EDW_LOCAL_INSTANCE inst,
22: MTL_SYSTEM_ITEMS msi
23: WHERE
24: wor.organization_id = wo.organization_id
25: and wor.wip_entity_id = wo.wip_entity_id

Line 66: EDW_LOCAL_INSTANCE inst,

62: GL_SETS_OF_BOOKS gsob,
63: WIP_FLOW_SCHEDULES wfs,
64: BOM_OPERATIONAL_ROUTINGS bor,
65: BOM_OPERATION_SEQUENCES bos,
66: EDW_LOCAL_INSTANCE inst,
67: MTL_SYSTEM_ITEMS msi
68: WHERE
69: wt.transaction_type in (1,3)
70: and wfs.status = 2

Line 275: FROM EDW_LOCAL_INSTANCE ;

271:
272: CURSOR c_6 IS
273: SELECT
274: avg(nvl(vsize(instance_code), 0))
275: FROM EDW_LOCAL_INSTANCE ;
276: -- WHERE last_update_date between
277: -- p_from_date and p_to_date;
278:
279: CURSOR c_7 is