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_TRAN_CMP

Line 15: from ic_tran_cmp cmp,ic_loct_inv loct, sy_orgn_mst org,ic_whse_mst whse

11: FROM (
12: (SELECT
13: org.CO_CODE,org.ORGN_CODE,cmp.WHSE_CODE,cmp.ITEM_ID,cmp.LOT_ID,
14: nvl(cmp.LOCATION,'NONE'),trunc(cmp.TRANS_DATE),cmp.TRANS_UM
15: from ic_tran_cmp cmp,ic_loct_inv loct, sy_orgn_mst org,ic_whse_mst whse
16: where trunc(cmp.last_update_date) between p_from_date and p_to_date
17: AND loct.item_id = cmp.item_id AND loct.lot_id = cmp.lot_id
18: AND loct.whse_code = cmp.whse_code AND loct.location = cmp.location
19: AND cmp.whse_code is not null

Line 84: from ic_tran_cmp cmp,

80: whse.mtl_organization_id mtl_orgn_id,cmp.ITEM_ID item_id,cmp.LOT_ID lot_id,
81: nvl(cmp.LOCATION,'NONE') LOCT,trunc(cmp.TRANS_DATE) trx_date,cmp.TRANS_UM UOM,
82: iim.inactive_ind item_status,iim.inv_type item_type,iim.commodity_code commodity,
83: SUM(cmp.TRANS_QTY) QTY
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