APPS.POA_DBI_RCV_TXN_F_C dependencies on POA_DBI_RTX_RATES

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

18:
19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';
20: EXECUTE IMMEDIATE l_stmt;
21:
22: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_RATES';
23: EXECUTE IMMEDIATE l_stmt;
24:
25: -- l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_ITEMS';
26: -- EXECUTE IMMEDIATE l_stmt;

Line 143: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_RATES';

139: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
140: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';
141: EXECUTE IMMEDIATE l_stmt;
142:
143: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_RATES';
144: EXECUTE IMMEDIATE l_stmt;
145: END IF;
146:
147: DBMS_APPLICATION_INFO.SET_ACTION('inc');

Line 248: poa_dbi_rtx_rates

244: TABNAME => 'POA_DBI_RTX_INC') ;
245: END IF;
246:
247: insert /*+ APPEND */ into
248: poa_dbi_rtx_rates
249: (
250: txn_cur_code,
251: func_cur_code,
252: rate_date,

Line 292: TABNAME => 'POA_DBI_RTX_RATES') ;

288: DBMS_APPLICATION_INFO.SET_ACTION('stats rates');
289:
290: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
291: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
292: TABNAME => 'POA_DBI_RTX_RATES') ;
293: END IF;
294:
295: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
296:

Line 421: poa_dbi_rtx_rates rat

417: gl_sets_of_books poa_gl,
418: financials_system_params_all fsp,
419: mtl_system_items item,
420: mtl_parameters param,
421: poa_dbi_rtx_rates rat
422: where
423: -- val.transaction_type IN ('RECEIVE','MATCH','CORRECT','REJECT','ACCEPT','RETURN TO VENDOR')
424: -- AND val.source_document_code = 'PO' AND
425: inc.primary_key = val.transaction_id

Line 507: poa_dbi_rtx_rates rat

503: gl_sets_of_books poa_gl,
504: financials_system_params_all fsp,
505: mtl_system_items item,
506: mtl_parameters param,
507: poa_dbi_rtx_rates rat
508: where
509: inc.primary_key = val.transaction_id
510: and val.parent_transaction_id = par.transaction_id(+)
511: AND val.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID