APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on IC_TRAN_PND

Line 52: populate period 3 rows using IC_LOCT_INV and Transaction tables (IC_TRAN_PND and IC_TRAN_CMP) this is

48: create previous period rows using current period rows
49: E.g.
50: we need to populate data for period 1 to period 3.
51: current period : 3
52: populate period 3 rows using IC_LOCT_INV and Transaction tables (IC_TRAN_PND and IC_TRAN_CMP) this is
53: required because user might have run the purge 0 -zero balance rows
54: For period 2 use period 3 rows and Trnasaction tables
55: For period 1 use period 2 rows and Trnasaction tables
56: */

Line 220: FROM IC_TRAN_PND

216: (
217: SELECT whse_code,item_id,sum(trans_qty),sum(sales_qty)
218: FROM (SELECT WHSE_CODE,ITEM_ID,TRANS_QTY,
219: DECODE(DOC_TYPE,'OPSO',trans_qty,'OMSO',trans_qty,0) sales_qty
220: FROM IC_TRAN_PND
221: WHERE trunc(trans_date) between cldr_rec.period_start_date AND
222: cldr_rec.period_end_date
223: AND doc_type NOT IN ('STSI', 'GRDI','STSR', 'GRDR')
224: AND completed_ind = 1 and delete_mark = 0

Line 491: from IC_TRAN_PND

487: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
488: CURSOR cur_last_trans_eff_date IS
489: SELECT min(trans_date)
490: from (Select (min(trans_date)) trans_date
491: from IC_TRAN_PND
492: WHERE (l_last_run_date IS NULL OR
493: (l_last_run_date IS NOT NULL AND last_update_date >= l_last_run_date))
494: UNION ALL
495: (Select (min(trans_date)) trans_date