APPS.OPI_EDW_COGS_FOPM_SZ dependencies on IC_LOTS_MST

Line 49: FROM IC_TRAN_PND ITP,IC_LOTS_MST ILM

45: avg(nvl(vsize(itp.LOCATION), 0)) location,
46: avg(nvl(vsize(itp.TRANS_QTY), 0)) qty,
47: avg(nvl(vsize(ilm.lot_no),0)) Lot_no,
48: avg(nvl(vsize(itp.item_id),0)) item_id
49: FROM IC_TRAN_PND ITP,IC_LOTS_MST ILM
50: WHERE ITP.last_update_date between p_from_date and p_to_date
51: AND ITP.LOT_ID = ILM.LOT_ID
52: AND ITP.ITEM_ID = ILM.ITEM_ID
53: AND ITP.COMPLETED_IND =1