APPS.OPI_EDW_INV_DAILY_STAT_FOPM_SZ dependencies on IC_TRAN_PND

Line 29: from ic_tran_pnd pnd ,ic_loct_inv loct , sy_orgn_mst org,ic_whse_mst whse

25: nvl(cmp.LOCATION,'NONE'),trunc(cmp.TRANS_DATE),cmp.TRANS_UM)
26: UNION ALL
27: ( SELECT org.CO_CODE,org.ORGN_CODE,pnd.WHSE_CODE,pnd.ITEM_ID,pnd.LOT_ID,
28: nvl(pnd.LOCATION,'NONE'),trunc(pnd.TRANS_DATE),pnd.TRANS_UM
29: from ic_tran_pnd pnd ,ic_loct_inv loct , sy_orgn_mst org,ic_whse_mst whse
30: where trunc(pnd.last_update_date) between p_from_date and p_to_date
31: AND pnd.COMPLETED_IND = 1
32: AND loct.item_id = pnd.item_id
33: AND loct.lot_id = pnd.lot_id

Line 106: from ic_tran_pnd pnd ,

102: ( SELECT org.CO_CODE co_code,org.ORGN_CODE org_code ,pnd.WHSE_CODE whse_code,
103: whse.mtl_organization_id mtl_orgn_id,pnd.ITEM_ID item_id,pnd.LOT_ID lot_id,
104: nvl(pnd.LOCATION,'NONE'),trunc(pnd.TRANS_DATE) trx_date,pnd.TRANS_UM UOM,
105: iim.inactive_ind item_status,iim.inv_type item_type,iim.commodity_code commodity,SUM(TRANS_QTY) QTY
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