APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on IC_LOCT_INV

Line 47: /* Insert new period marker rows using ic_loct_inv for the current period and

43: OPEN check_cldr_for_perd_bal;
44: LOOP
45: FETCH check_cldr_for_perd_bal INTO cldr_rec;
46: EXIT WHEN check_cldr_for_perd_bal%NOTFOUND;
47: /* Insert new period marker rows using ic_loct_inv for the current period and
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

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 125: from IC_LOCT_INV

121: ,cldr_rec.period_end_date GL_PERIOD_END_DATE
122: ,cldr_rec.period_start_date GL_PERIOD_START_DATE
123: ,0 MISS_CONV_FACT_CNT
124: FROM (SELECT whse_code,item_id,sum(LOCT_ONHAND) loct_onhand
125: from IC_LOCT_INV
126: group by whse_code,item_id) loct,
127: IC_WHSE_MST whs,
128: SY_ORGN_MST org,
129: IC_ITEM_MST iim

Line 236: balance rows routine purges 0 balance rows from ic_LOCT_INV */

232: group by whse_code,item_id);
233:
234: /*
235: Following statement inserts 0-Zero balance rows if purge 0-zero
236: balance rows routine purges 0 balance rows from ic_LOCT_INV */
237:
238:
239: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR
240: ,CO_CODE