APPS.POA_DBI_NEG_F_C dependencies on POA_DBI_NEG_RATES

Line 23: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_RATES';

19:
20: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_INC';
21: EXECUTE immediate l_stmt;
22:
23: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_RATES';
24: EXECUTE immediate l_stmt;
25:
26: g_init := TRUE;
27: populate_neg_facts (errbuf, retcode);

Line 132: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_RATES';

128: bis_collection_utilities.log('Truncate Currency Conversion table: '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
129: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
130: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_INC';
131: EXECUTE IMMEDIATE l_stmt;
132: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_RATES';
133: EXECUTE IMMEDIATE l_stmt;
134: END IF;
135:
136: dbms_application_info.set_action('inc');

Line 245: INSERT /*+ APPEND */ INTO poa_dbi_neg_rates

241: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
242: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_NEG_INC') ;
243: END IF;
244:
245: INSERT /*+ APPEND */ INTO poa_dbi_neg_rates
246: (
247: txn_cur_code,
248: func_cur_code,
249: rate_date,

Line 290: tabname => 'POA_DBI_NEG_RATES') ;

286: dbms_application_info.set_action('stats rates');
287:
288: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
289: fnd_stats.gather_table_stats(ownname => l_poa_schema,
290: tabname => 'POA_DBI_NEG_RATES') ;
291: END IF;
292:
293: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
294: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_neg_inc;

Line 501: poa_dbi_neg_rates rat,

497: rat.sglobal_cur_conv_rate,
498: decode(doctype.internal_name, 'REQUEST_FOR_INFORMATION', nvl(ponh.award_complete_date, ponh.last_update_date), null) rfi_complete_date
499: FROM
500: poa_dbi_neg_inc inc,
501: poa_dbi_neg_rates rat,
502: pon_auction_headers_all ponh,
503: pon_auction_item_prices_all ponip,
504: pon_bid_headers ponbh,
505: pon_bid_item_prices ponbip,

Line 626: poa_dbi_neg_rates rat,

622: ponbh.bid_status bid_status,
623: decode(doctype.internal_name, 'REQUEST_FOR_INFORMATION', nvl(ponh.award_complete_date, ponh.last_update_date), null) rfi_complete_date
624: FROM
625: poa_dbi_neg_inc inc,
626: poa_dbi_neg_rates rat,
627: pon_auction_headers_all ponh,
628: pon_auction_item_prices_all ponip,
629: pon_bid_headers ponbh,
630: pon_bid_item_prices ponbip,