APPS.POA_DBI_RCV_TXN_F_C dependencies on POA_DBI_RTX_INC

Line 19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';

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;
21:
22: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_RATES';
23: EXECUTE IMMEDIATE l_stmt;

Line 140: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_RTX_INC';

136: END if;
137:
138: bis_collection_utilities.log('Truncate INC table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
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;

Line 153: insert /*+ append parallel(poa_dbi_rtx_inc) */ into

149: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
150: d_glob_date := bis_common_parameters.get_global_start_date;
151:
152: if (g_init) then
153: insert /*+ append parallel(poa_dbi_rtx_inc) */ into
154: poa_dbi_rtx_inc
155: (
156: primary_key,
157: global_cur_conv_rate,

Line 154: poa_dbi_rtx_inc

150: d_glob_date := bis_common_parameters.get_global_start_date;
151:
152: if (g_init) then
153: insert /*+ append parallel(poa_dbi_rtx_inc) */ into
154: poa_dbi_rtx_inc
155: (
156: primary_key,
157: global_cur_conv_rate,
158: batch_id,

Line 188: poa_dbi_rtx_inc

184:
185: ELSE -- not initial load
186:
187: insert /*+ append */ into
188: poa_dbi_rtx_inc
189: (
190: primary_key,
191: global_cur_conv_rate,
192: batch_id,

Line 244: TABNAME => 'POA_DBI_RTX_INC') ;

240: DBMS_APPLICATION_INFO.SET_ACTION('stats incremental');
241:
242: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
244: TABNAME => 'POA_DBI_RTX_INC') ;
245: END IF;
246:
247: insert /*+ APPEND */ into
248: poa_dbi_rtx_rates

Line 281: from poa_dbi_rtx_inc

277: ( select distinct
278: txn_cur_code,
279: func_cur_code,
280: rate_date
281: from poa_dbi_rtx_inc
282: where source_document_code = 'PO'
283: and txn_cur_code is not null -- added this for UNORDERED txns that have a source doc code of PO but don't have any PO reference on them
284: order by func_cur_code,rate_date
285: );

Line 297: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_rtx_inc;

293: END IF;
294:
295: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
296:
297: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_rtx_inc;
298: bis_collection_utilities.log('Identified '|| l_count ||' changed records. Batch size='|| l_batch_size || '. # of Batches=' || l_no_batch
299: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
300:
301: /* missing currency handling */

Line 413: poa_dbi_rtx_inc inc,

409: val.dropship_type_code,
410: val.inv_transaction_id
411: from rcv_transactions val,
412: rcv_transactions par,
413: poa_dbi_rtx_inc inc,
414: PO_HEADERS_ALL POH,
415: RCV_SHIPMENT_HEADERS RSH,
416: RCV_SHIPMENT_LINES rsl,
417: gl_sets_of_books poa_gl,

Line 499: poa_dbi_rtx_inc inc,

495: val.dropship_type_code,
496: val.inv_transaction_id
497: from rcv_transactions val,
498: rcv_transactions par,
499: poa_dbi_rtx_inc inc,
500: PO_HEADERS_ALL POH,
501: RCV_SHIPMENT_HEADERS RSH,
502: RCV_SHIPMENT_LINES rsl,
503: gl_sets_of_books poa_gl,