APPS.OPI_PMI_IDS_SUMMARY dependencies on OPI_PMI_DAY_SUM_TEMP

Line 383: INSERT INTO opi_pmi_day_sum_temp

379:
380:
381: edw_log.put_line ('After Indentifying Delta change :');
382:
383: INSERT INTO opi_pmi_day_sum_temp
384: (co_code,orgn_code,whse_code,item_id,lot_id,location,trans_date,TOT_ISSUES_QTY,
385: WIP_COMP_QTY,WIP_ISSUE_QTY,TOTAL_REC_QTY,TOT_CUST_SHIP_QTY, INV_ADJ_QTY,
386: PO_DEL_QTY,TO_ORG_QTY,FROM_ORG_QTY,
387: Period_start_date,Period_end_date,cost_mthd,curr_bal)

Line 445: FROM opi_pmi_day_sum_temp inc

441: INSERT INTO opi_pmi_ids_idnt (co_code,orgn_code,whse_code,location,item_id,lot_id, trans_date ,
442: start_date ,end_date) (
443: SELECT co_code,orgn_code,whse_code,location,item_id,lot_id,min(trans_date) trans_date ,
444: min(period_start_date) start_date ,min(period_end_date) end_date
445: FROM opi_pmi_day_sum_temp inc
446: group by co_code,orgn_code,whse_code,location,item_id,lot_id );
447:
448:
449: edw_log.put_line ('After idenfying rows to be re-summarized :');

Line 528: select * from opi_pmi_day_sum_temp

524: | and Moves data from day summary table to temporary summary table |
525: +===================================================================================*/
526:
527: CURSOR summerize_temp_sum IS
528: select * from opi_pmi_day_sum_temp
529: order by trans_date ASC;
530: rec_summary summerize_temp_sum%ROWTYPE;
531: CURSOR get_records_to_change IS
532: select *

Line 1370: where table_name= 'OPI_PMI_DAY_SUM_TEMP';

1366: l_owner VARCHAR2(240);
1367: BEGIN
1368: select TABLE_OWNER INTO l_owner
1369: from user_synonyms
1370: where table_name= 'OPI_PMI_DAY_SUM_TEMP';
1371: IF l_owner IS NOT NULL THEN
1372: l_stmt := 'truncate table '||l_owner||'.opi_pmi_day_sum_temp ';
1373: BEGIN
1374: execute immediate l_stmt;

Line 1372: l_stmt := 'truncate table '||l_owner||'.opi_pmi_day_sum_temp ';

1368: select TABLE_OWNER INTO l_owner
1369: from user_synonyms
1370: where table_name= 'OPI_PMI_DAY_SUM_TEMP';
1371: IF l_owner IS NOT NULL THEN
1372: l_stmt := 'truncate table '||l_owner||'.opi_pmi_day_sum_temp ';
1373: BEGIN
1374: execute immediate l_stmt;
1375: EXCEPTION WHEN OTHERS THEN
1376: NULL;