APPS.POA_DBI_REQ_F_C dependencies on POA_DBI_REQ_RATES

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

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

Line 173: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_RATES';

169: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
170: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';
171: EXECUTE IMMEDIATE l_stmt;
172:
173: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_RATES';
174: EXECUTE IMMEDIATE l_stmt;
175: END IF;
176:
177: dbms_application_info.set_action('inc');

Line 609: INSERT /*+ APPEND */ INTO poa_dbi_req_rates

605: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
606: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_REQ_INC') ;
607: END IF;
608:
609: INSERT /*+ APPEND */ INTO poa_dbi_req_rates
610: (
611: txn_cur_code,
612: func_cur_code,
613: rate_date,

Line 654: tabname => 'POA_DBI_REQ_RATES') ;

650: dbms_application_info.set_action('stats rates');
651:
652: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
653: fnd_stats.gather_table_stats(ownname => l_poa_schema,
654: tabname => 'POA_DBI_REQ_RATES') ;
655: END IF;
656:
657: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
658: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_req_inc;

Line 969: poa_dbi_req_rates rat,

965: )
966: ) base_uom_conv_rate
967: FROM
968: poa_dbi_req_inc inc,
969: poa_dbi_req_rates rat,
970: po_requisition_lines_all rln,
971: po_req_distributions_all rdn,
972: po_headers_all poh,
973: po_lines_all pol,

Line 1424: poa_dbi_req_rates rat,

1420: )
1421: ) base_uom_conv_rate
1422: FROM
1423: poa_dbi_req_inc inc,
1424: poa_dbi_req_rates rat,
1425: po_requisition_lines_all rln,
1426: po_req_distributions_all rdn,
1427: po_headers_all poh,
1428: po_lines_all pol,