APPS.POA_DBI_PO_DIST_F_C dependencies on FND_STATS

Line 450: fnd_stats.gather_table_stats(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_POD_INC');

446: COMMIT;
447:
448: DBMS_APPLICATION_INFO.SET_ACTION('stats incremental');
449:
450: fnd_stats.gather_table_stats(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_POD_INC');
451:
452: insert /*+ APPEND */ into poa_dbi_pod_rates
453: (
454: txn_cur_code,

Line 681: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_NEG_PO_RATES') ;

677:
678: end if;
679: COMMIT;
680: -- Gather statistics for poa_dbi_neg_po_rates
681: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_NEG_PO_RATES') ;
682:
683: --- Create a Negotiations Table that stores all relevant data pertaining to negotiations ---
684: if(g_init) then
685: insert /*+ APPEND */ into poa_dbi_neg_details

Line 1184: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,

1180:
1181:
1182: DBMS_APPLICATION_INFO.SET_ACTION('stats rates');
1183:
1184: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1185: TABNAME => 'POA_DBI_POD_RATES') ;
1186: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1187: TABNAME => 'POA_DBI_NEG_DETAILS') ;
1188:

Line 1186: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,

1182: DBMS_APPLICATION_INFO.SET_ACTION('stats rates');
1183:
1184: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1185: TABNAME => 'POA_DBI_POD_RATES') ;
1186: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1187: TABNAME => 'POA_DBI_NEG_DETAILS') ;
1188:
1189: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1190:

Line 1362: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,

1358: and inc.primary_key = match.po_distribution_id;
1359:
1360: COMMIT;
1361:
1362: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1363: TABNAME => 'POA_DBI_POD_MATCH_TEMP') ;
1364:
1365: bis_collection_utilities.log('Initial Load - populate lowest price table. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1366:

Line 1519: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,

1515: group by po_distribution_id ,po_line_id, po_header_id;
1516:
1517: COMMIT;
1518:
1519: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1520: TABNAME => 'POA_DBI_POD_LOWEST_ALL_TEMP') ;
1521:
1522: insert /*+ APPEND PARALLEL(t) */ into poa_dbi_pod_lowest_price_temp t(po_distribution_id,
1523: lowest_price,

Line 1535: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,

1531: group by po_distribution_id;
1532:
1533: COMMIT;
1534:
1535: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1536: TABNAME => 'POA_DBI_POD_LOWEST_PRICE_TEMP') ;
1537:
1538: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1539: INSERT /*+ APPEND PARALLEL(t) */ INTO