APPS.OPI_PMI_IDS_SUMMARY dependencies on USER_SYNONYMS

Line 1369: from user_synonyms

1365: l_stmt varchar2(2000);
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

Line 1380: from user_synonyms

1376: NULL;
1377: END;
1378: END IF;
1379: select TABLE_OWNER INTO l_owner
1380: from user_synonyms
1381: where table_name= 'OPI_PMI_TRANS_INC';
1382: IF l_owner IS NOT NULL THEN
1383: l_stmt := 'truncate table '||l_owner||'.opi_pmi_trans_inc ';
1384: BEGIN

Line 1391: from user_synonyms

1387: NULL;
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

Line 1402: from user_synonyms

1398: NULL;
1399: END;
1400: END IF;
1401: select TABLE_OWNER INTO l_owner
1402: from user_synonyms
1403: where table_name= 'OPI_PMI_IDS_TEMP';
1404: IF l_owner IS NOT NULL THEN
1405: l_stmt := 'truncate table '||l_owner||'.opi_pmi_ids_temp ';
1406: BEGIN

Line 1413: from user_synonyms

1409: NULL;
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