APPS.POA_DBI_PO_DIST_F_C dependencies on POA_DBI_POD_RATES

Line 22: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';

18:
19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';
20: EXECUTE IMMEDIATE l_stmt;
21:
22: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';
23: EXECUTE IMMEDIATE l_stmt;
24:
25: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_PO_RATES';
26: EXECUTE IMMEDIATE l_stmt;

Line 151: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';

147: RAISE_APPLICATION_ERROR (-20000, 'Error in GET_APP_INFO: ' || errbuf);
148: END IF;
149: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';
150: EXECUTE IMMEDIATE l_stmt;
151: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';
152: EXECUTE IMMEDIATE l_stmt;
153: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_PO_RATES';
154: EXECUTE IMMEDIATE l_stmt;
155: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_DETAILS';

Line 452: insert /*+ APPEND */ into poa_dbi_pod_rates

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,
455: func_cur_code,
456: rate_date,

Line 1185: TABNAME => 'POA_DBI_POD_RATES') ;

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:
1189: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

Line 1875: poa_dbi_pod_rates rat,

1871: nvl(pol.negotiated_by_preparer_flag,'N') negotiated_by_preparer_flag
1872: FROM
1873: poa_dbi_pod_inc inc,
1874: poa_dbi_neg_details negd,
1875: poa_dbi_pod_rates rat,
1876: po_doc_style_headers style,
1877: gl_sets_of_books poa_gl,
1878: ( select /*+ PARALLEL(a) PARALLEL(pod) NO_MERGE */
1879: pod.po_distribution_id,

Line 2158: poa_dbi_pod_rates rat,

2154: nvl(pol.negotiated_by_preparer_flag,'N') negotiated_by_preparer_flag
2155: FROM
2156: poa_dbi_pod_inc inc,
2157: poa_dbi_neg_details negd,
2158: poa_dbi_pod_rates rat,
2159: gl_sets_of_books poa_gl,
2160: po_distributions_all pod,
2161: po_line_locations_all pll,
2162: po_lines_all pol,