APPS.POA_DBI_RCV_TXN_F_C dependencies on POA_DBI_RTX_F

Line 16: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_F';

12:
13: l_stmt VARCHAR2(4000);
14: BEGIN
15: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
16: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_F';
17: EXECUTE IMMEDIATE l_stmt;
18:
19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';
20: EXECUTE IMMEDIATE l_stmt;

Line 316: INSERT /*+ APPEND PARALLEL(poa_dbi_rtx_f) */ INTO poa_dbi_rtx_f

312: DBMS_APPLICATION_INFO.SET_ACTION('collect');
313:
314: if (l_no_batch is NOT NULL) then
315: IF (g_init) THEN
316: INSERT /*+ APPEND PARALLEL(poa_dbi_rtx_f) */ INTO poa_dbi_rtx_f
317: ( transaction_id,
318: transaction_type,
319: parent_transaction_type,
320: grp_txn_date,

Line 445: merge INTO poa_dbi_rtx_f T

441: else
442:
443: FOR v_batch_no IN 1..l_no_batch LOOP
444: bis_collection_utilities.log('batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);
445: merge INTO poa_dbi_rtx_f T
446: using (
447: select /*+ cardinality(inc,1) */
448: val.transaction_id,
449: val.transaction_type,