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

Line 2180: wip_flow_schedules wfs

2176: where
2177: bb.COMMON_BILL_SEQUENCE_ID = bic.bill_sequence_id and
2178: bic.implementation_date is not null
2179: ) bom_join,
2180: wip_flow_schedules wfs
2181: WHERE
2182: EFFECTIVITY_DATE <= wfs.scheduled_completion_date and
2183: last_rev > decode (sign(wfs.scheduled_completion_date - nvl(wfs.date_closed,wfs.scheduled_completion_date)),1,wfs.date_closed,wfs.scheduled_completion_date) and
2184: decode (sign(wfs.scheduled_completion_date - nvl(wfs.date_closed,wfs.scheduled_completion_date)),1,wfs.date_closed,wfs.scheduled_completion_date) < nvl(bom_join.disable_date, sysdate) and

Line 2404: wip_flow_schedules wfs

2400: where
2401: bb.COMMON_BILL_SEQUENCE_ID = bic.bill_sequence_id and
2402: bic.implementation_date is not null
2403: ) t,
2404: wip_flow_schedules wfs
2405: WHERE
2406: EFFECTIVITY_DATE <= wfs.scheduled_completion_date and
2407: last_rev > decode (sign(wfs.scheduled_completion_date - nvl(wfs.date_closed,wfs.scheduled_completion_date)),1,wfs.date_closed,wfs.scheduled_completion_date) and
2408: decode (sign(wfs.scheduled_completion_date - nvl(wfs.date_closed,wfs.scheduled_completion_date)),1,wfs.date_closed,wfs.scheduled_completion_date) < nvl(t.disable_date, sysdate) and