APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on IC_TRAN_CMP

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 228: FROM IC_TRAN_CMP

224: AND completed_ind = 1 and delete_mark = 0
225: UNION ALL
226: SELECT WHSE_CODE,ITEM_ID,TRANS_QTY,
227: DECODE(DOC_TYPE,'OPSO',trans_qty,'OMSO',trans_qty,0) sales_qty
228: FROM IC_TRAN_CMP
229: WHERE trunc(trans_date) between cldr_rec.period_start_date AND
230: cldr_rec.period_end_date
231: AND doc_type NOT IN ('STSI', 'GRDI','STSR', 'GRDR'))
232: group by whse_code,item_id);

Line 496: from IC_TRAN_CMP

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
496: from IC_TRAN_CMP
497: WHERE (l_last_run_date IS NULL OR
498: (l_last_run_date IS NOT NULL AND last_update_date >= l_last_run_date))));
499: rows_exists number := null;
500: BEGIN