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_FOPM_SZ dependencies on IC_ITEM_MST

Line 88: ic_item_mst iim

84: from ic_tran_cmp cmp,
85: ic_loct_inv loct,
86: sy_orgn_mst org,
87: ic_whse_mst whse,
88: ic_item_mst iim
89: where trunc(cmp.last_update_date) between p_from_date and p_to_date
90: AND loct.item_id = cmp.item_id AND loct.lot_id = cmp.lot_id
91: AND loct.whse_code = cmp.whse_code AND loct.location = cmp.location
92: AND cmp.whse_code is not null

Line 110: ic_item_mst iim

106: from ic_tran_pnd pnd ,
107: ic_loct_inv loct ,
108: sy_orgn_mst org,
109: ic_whse_mst whse ,
110: ic_item_mst iim
111: where trunc(pnd.last_update_date) between p_from_date and p_to_date
112: AND pnd.COMPLETED_IND = 1
113: AND pnd.item_id = iim.item_id
114: AND loct.item_id = pnd.item_id