[Home] [Help]
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
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,
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