APPS.OPI_PMI_IDS_SUMMARY dependencies on OPI_PMI_IDS_IDNT

Line 441: INSERT INTO opi_pmi_ids_idnt (co_code,orgn_code,whse_code,location,item_id,lot_id, trans_date ,

437:
438:
439: edw_log.put_line ('Before idenfying rows to be re-summaeized :');
440:
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

Line 505: from opi_pmi_inv_daily_stat_sum sm, opi_pmi_ids_idnt idnt

501: ,sm.WIP_COMP_QTY
502: ,sm.WIP_ISSUE_QTY
503: ,sm.period_flag
504: ,'UPDATE' OPERATION_CODE
505: from opi_pmi_inv_daily_stat_sum sm, opi_pmi_ids_idnt idnt
506: where idnt.co_code = sm.co_code AND
507: idnt.orgn_code = sm.orgn_code AND
508: idnt.whse_code = sm.whse_code AND
509: idnt.location = sm.location AND

Line 1392: where table_name= 'OPI_PMI_IDS_IDNT';

1388: END;
1389: END IF;
1390: select TABLE_OWNER INTO l_owner
1391: from user_synonyms
1392: where table_name= 'OPI_PMI_IDS_IDNT';
1393: IF l_owner IS NOT NULL THEN
1394: l_stmt := 'truncate table '||l_owner||'.opi_pmi_ids_idnt ';
1395: BEGIN
1396: execute immediate l_stmt;

Line 1394: l_stmt := 'truncate table '||l_owner||'.opi_pmi_ids_idnt ';

1390: select TABLE_OWNER INTO l_owner
1391: from user_synonyms
1392: where table_name= 'OPI_PMI_IDS_IDNT';
1393: IF l_owner IS NOT NULL THEN
1394: l_stmt := 'truncate table '||l_owner||'.opi_pmi_ids_idnt ';
1395: BEGIN
1396: execute immediate l_stmt;
1397: EXCEPTION WHEN OTHERS THEN
1398: NULL;