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_DETAIL_F_SZ dependencies on WIP_FLOW_SCHEDULES

Line 29: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL

25: and en.last_update_date between p_from_date and p_to_date
26: union
27: Select count(*) cnt
28: FROM
29: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL
30: WHERE
31: FL.STATUS = 2 AND '_SEC:fl.organization_id' IS NOT NULL AND
32: FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID
33: and en.last_update_date between p_from_date and p_to_date

Line 170: WIP_FLOW_SCHEDULES FL

166: avg(nvl(vsize(NVL(FL.DATE_CLOSED,FL.scheduled_completion_date)), 0)), -- ACT_CMPL_DATE,
167: avg(nvl(vsize(FL.LINE_ID), 0)), -- PRD_LINE_FK,
168: avg(nvl(vsize(FL.ROUTING_REVISION), 0)) -- ROUTING_REVISION,
169: FROM
170: WIP_FLOW_SCHEDULES FL
171: WHERE
172: FL.STATUS = 2 AND '_SEC:fl.organization_id' IS NOT NULL;
173:
174: CURSOR c_5 IS

Line 211: WIP_FLOW_SCHEDULES FL;

207: CURSOR c_10 IS
208: SELECT
209: avg(nvl(vsize((NVL(FL.DATE_CLOSED, FL.scheduled_completion_date) - FL.SCHEDULED_START_DATE)), 0)) -- ACT_JOB_TIME AND PLN_JOB_TIME
210: FROM
211: WIP_FLOW_SCHEDULES FL;
212:
213: CURSOR c_11 IS
214: SELECT
215: avg(nvl(vsize(instance_code), 0))

Line 242: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL

238:
239: CURSOR c_15 IS
240: Select count(*) cnt
241: FROM
242: WIP_ENTITIES EN, WIP_FLOW_SCHEDULES FL
243: WHERE
244: FL.STATUS = 2 AND '_SEC:fl.organization_id' IS NOT NULL AND
245: FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID;
246: