[Home] [Help]
1169: | This procedure to cost the summary table rows. |
1170: +===================================================================================*/
1171: BEGIN
1172: /* following insert statement moves all open periods data into work table for costing */
1173: INSERT INTO OPI_PMI_INV_DAILY_STAT_TEMP (CO_CODE
1174: ,ORGN_CODE
1175: ,WHSE_CODE
1176: ,LOCATION
1177: ,ITEM_ID
1262: (SELECT distinct orgn_code,
1263: whse_code,
1264: item_id,
1265: trx_date
1266: FROM OPI_PMI_INV_DAILY_STAT_TEMP);
1267: opi_pmi_cost.get_cost;
1268:
1269: /* Move data from temporary summary table to actual summary table and calculate the values
1270: using cost data inserted into opi_pmi_cost_result_gtmp table by costing procedure */
1341: ,sm.WIP_COMP_QTY * rslt.total_cost
1342: ,sm.WIP_ISSUE_QTY * rslt.total_cost
1343: ,NVL(rslt.PERIOD_STATUS,0)
1344: ,NVL(sm.DATA_PUSHED_IND,0)
1345: FROM OPI_PMI_INV_DAILY_STAT_TEMP sm,
1346: opi_pmi_cost_result_gtmp rslt
1347: WHERE rslt.orgn_code = sm.orgn_code AND
1348: rslt.whse_code = sm.whse_code AND
1349: rslt.item_id = sm.item_id AND
1410: END;
1411: END IF;
1412: select TABLE_OWNER INTO l_owner
1413: from user_synonyms
1414: where table_name= 'OPI_PMI_INV_DAILY_STAT_TEMP';
1415: IF l_owner IS NOT NULL THEN
1416: l_stmt := 'truncate table '||l_owner||'.OPI_PMI_INV_DAILY_STAT_TEMP';
1417: BEGIN
1418: execute immediate l_stmt;
1412: select TABLE_OWNER INTO l_owner
1413: from user_synonyms
1414: where table_name= 'OPI_PMI_INV_DAILY_STAT_TEMP';
1415: IF l_owner IS NOT NULL THEN
1416: l_stmt := 'truncate table '||l_owner||'.OPI_PMI_INV_DAILY_STAT_TEMP';
1417: BEGIN
1418: execute immediate l_stmt;
1419: EXCEPTION WHEN OTHERS THEN
1420: NULL;