APPS.OPI_PMI_IDS_SUMMARY dependencies on IC_WHSE_MST

Line 147: IC_WHSE_MST whs,

143: ,0 WIP_COMP_QTY
144: ,0 WIP_ISSUE_QTY
145: ,0
146: FROM IC_LOCT_INV loct,
147: IC_WHSE_MST whs,
148: SY_ORGN_MST org
149: WHERE co_code = cldr_rec.co_code
150: AND loct.whse_code = whs.whse_code
151: AND whs.orgn_code = org.orgn_code);

Line 203: IC_WHSE_MST whs,

199: ,0 WIP_COMP_QTY
200: ,0 WIP_ISSUE_QTY
201: ,1
202: FROM IC_LOCT_INV loct,
203: IC_WHSE_MST whs,
204: SY_ORGN_MST org
205: WHERE co_code = cldr_rec.co_code
206: AND loct.whse_code = whs.whse_code
207: AND whs.orgn_code = org.orgn_code);

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

281: org.CO_CODE,org.ORGN_CODE,cmp.WHSE_CODE,cmp.ITEM_ID,cmp.LINE_ID,cmp.LOT_ID,
282: nvl(cmp.LOCATION,'NONE'),cmp.DOC_TYPE,cmp.DOC_ID,cmp.DOC_LINE,cmp.TRANS_DATE,
283: cmp.TRANS_QTY,cmp.TRANS_QTY2,cmp.QC_GRADE,cmp.LOT_STATUS,loct.LOCT_ONHAND
284: ,cmp.TRANS_UM,cmp.TRANS_UM2,cmp.REASON_CODE,cmp.LINE_TYPE,cmp.CREATION_DATE,cmp.LAST_UPDATE_DATE
285: from ic_tran_cmp cmp,ic_loct_inv loct, sy_orgn_mst org,ic_whse_mst whse
286: where trunc(cmp.last_update_date) >= trunc(l_last_run_date)
287: AND loct.item_id = cmp.item_id AND loct.lot_id = cmp.lot_id
288: AND loct.whse_code = cmp.whse_code AND loct.location = cmp.location
289: AND cmp.whse_code is not null

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

295: org.CO_CODE,org.ORGN_CODE,pnd.WHSE_CODE,pnd.ITEM_ID,pnd.LINE_ID,pnd.LOT_ID,
296: nvl(pnd.LOCATION,'NONE'),pnd.DOC_TYPE,pnd.DOC_ID,pnd.DOC_LINE,pnd.TRANS_DATE,pnd.TRANS_QTY,
297: pnd.TRANS_QTY2,pnd.QC_GRADE,pnd.LOT_STATUS,loct.LOCT_ONHAND
298: ,pnd.TRANS_UM,pnd.TRANS_UM2,pnd.REASON_CODE,pnd.LINE_TYPE,pnd.CREATION_DATE,pnd.LAST_UPDATE_DATE
299: from ic_tran_pnd pnd ,ic_loct_inv loct , sy_orgn_mst org,ic_whse_mst whse
300: where trunc(pnd.last_update_date) >= trunc(l_last_run_date) AND pnd.COMPLETED_IND = 1
301: AND loct.item_id = pnd.item_id AND loct.lot_id = pnd.lot_id
302: AND loct.whse_code = pnd.whse_code AND loct.location = pnd.location
303: AND whse.whse_code = loct.whse_code