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_INV_DAILY_STAT_F_SZ dependencies on WIP_TRANSACTIONS

Line 20: FROM wip_transactions wt,

16:
17: CURSOR wt_cnt_rows IS
18: select count(*) from (
19: SELECT wdj.primary_item_id,wdj.bom_revision
20: FROM wip_transactions wt,
21: wip_discrete_jobs wdj
22: WHERE wt.transaction_date between p_from_date
23: and p_to_Date
24: AND wt.wip_entity_id = wdj.wip_entity_id

Line 29: FROM wip_transactions wt,

25: GROUP BY wdj.primary_item_id,
26: wdj.bom_revision
27: UNION ALL
28: SELECT we.primary_item_id,wrs.bom_revision
29: FROM wip_transactions wt,
30: wip_repetitive_schedules wrs,
31: wip_entities we
32: WHERE wt.transaction_date between p_from_date
33: and p_to_Date

Line 40: FROM wip_transactions wt,

36: GROUP BY we.primary_item_id,
37: wrs.bom_revision
38: UNION ALL
39: SELECT wfs.primary_item_id,wfs.bom_revision
40: FROM wip_transactions wt,
41: wip_flow_schedules wfs
42: WHERE wt.transaction_date between p_from_date
43: and p_to_Date
44: AND wt.wip_entity_id = wfs.wip_entity_id