APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DR_COSTS_STG

Line 173: insert /*+ append parallel(isc_dr_costs_stg) */

169:
170: l_stmnt_id := 10;
171: if p_load_type = 'init_load' then -- initial load
172:
173: insert /*+ append parallel(isc_dr_costs_stg) */
174: into isc_dr_costs_stg
175: ( repair_line_id
176: , work_order_id
177: , func_currency_code

Line 174: into isc_dr_costs_stg

170: l_stmnt_id := 10;
171: if p_load_type = 'init_load' then -- initial load
172:
173: insert /*+ append parallel(isc_dr_costs_stg) */
174: into isc_dr_costs_stg
175: ( repair_line_id
176: , work_order_id
177: , func_currency_code
178: , date_closed

Line 230: insert /*+ append parallel(isc_dr_costs_stg) */

226: else -- incremental load
227:
228: l_stmnt_id := 20;
229:
230: insert /*+ append parallel(isc_dr_costs_stg) */
231: into isc_dr_costs_stg
232: ( repair_line_id
233: , work_order_id
234: , func_currency_code

Line 231: into isc_dr_costs_stg

227:
228: l_stmnt_id := 20;
229:
230: insert /*+ append parallel(isc_dr_costs_stg) */
231: into isc_dr_costs_stg
232: ( repair_line_id
233: , work_order_id
234: , func_currency_code
235: , date_closed

Line 291: , tabname => 'ISC_DR_COSTS_STG'

287:
288: l_stmnt_id := 40;
289: fnd_stats.gather_table_stats
290: ( ownname => g_isc_schema
291: , tabname => 'ISC_DR_COSTS_STG'
292: , percent=> 10
293: );
294:
295: bis_collection_utilities.log( 'Gather statistics onstaging table', 2 );

Line 373: from isc_dr_costs_stg

369: from
370: ( select distinct
371: func_currency_code
372: , date_closed
373: from isc_dr_costs_stg
374: order by func_currency_code, date_closed
375: ) costs;
376:
377: l_rowcount := sql%rowcount;

Line 741: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';

737:
738: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
739:
740: l_stmnt_id := 30;
741: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';
742:
743: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_STG', 1 );
744:
745: l_stmnt_id := 40;

Line 743: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_STG', 1 );

739:
740: l_stmnt_id := 30;
741: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';
742:
743: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_STG', 1 );
744:
745: l_stmnt_id := 40;
746: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_CONV_TMP';
747:

Line 829: isc_dr_costs_stg stg

825: , g_program_login_id program_login_id
826: , g_program_application_id program_application_id
827: , g_request_id request_id
828: from
829: isc_dr_costs_stg stg
830: , isc_dr_costs_conv_tmp rates
831: where
832: stg.func_currency_code = rates.func_currency_code
833: and stg.date_closed = rates.date_closed

Line 1226: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';

1222: bis_collection_utilities.log( 'Secondary Global Currency: ' || g_global_sec_curr_code, 1 );
1223: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );
1224:
1225: l_stmnt_id := 20;
1226: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';
1227:
1228: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_STG', 1 );
1229:
1230: l_stmnt_id := 30;

Line 1228: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_STG', 1 );

1224:
1225: l_stmnt_id := 20;
1226: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';
1227:
1228: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_STG', 1 );
1229:
1230: l_stmnt_id := 30;
1231: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_CONV_TMP';
1232:

Line 1304: isc_dr_costs_stg stg

1300: , g_program_login_id program_login_id
1301: , g_program_application_id program_application_id
1302: , g_request_id request_id
1303: from
1304: isc_dr_costs_stg stg
1305: , isc_dr_costs_conv_tmp rates
1306: where
1307: stg.func_currency_code = rates.func_currency_code
1308: and stg.date_closed = rates.date_closed