APPS.OPI_PMI_IDS_SUMMARY dependencies on IC_TRAN_CMP

Line 267: | current date into work table from ic_tran_pnd and ic_tran_cmp. |

263: PROCEDURE populate_net_change (p_last_run_date date) IS
264: /*=================================================================================+
265: | populate_net_change; |
266: | It moves transaction data created after last summarization date upto |
267: | current date into work table from ic_tran_pnd and ic_tran_cmp. |
268: +=================================================================================*/
269: l_stmt varchar2(2000);
270: l_last_run_date date:= p_last_run_date;
271: BEGIN

Line 272: -- get all new trasactions from ic_tran_cmp and ic_tran_pnd and insert into net change table

268: +=================================================================================*/
269: l_stmt varchar2(2000);
270: l_last_run_date date:= p_last_run_date;
271: BEGIN
272: -- get all new trasactions from ic_tran_cmp and ic_tran_pnd and insert into net change table
273:
274: edw_log.put_line ('Before Indentifying Delta change :');
275:
276: INSERT INTO opi_pmi_trans_inc (co_code,orgn_code,whse_code,item_id,

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