APPS.OPI_EDW_INV_DAILY_STAT_FOPM_SZ dependencies on IC_WHSE_MST

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 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 87: ic_whse_mst whse,

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
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

Line 109: ic_whse_mst whse ,

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
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