eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DR_COSTS_CONV_TMP

Line 330: isc_dr_costs_conv_tmp

326: , date_closed
327: , g_conv_rate
328: , sg_conv_rate
329: from
330: isc_dr_costs_conv_tmp
331: where
332: g_conv_rate < 0
333: or ( sg_conv_rate < 0 and g_global_sec_curr_code is not null );
334:

Line 343: into isc_dr_costs_conv_tmp

339: bis_collection_utilities.log( 'Begin currency conversion', 1 );
340:
341: l_stmnt_id := 10;
342: insert
343: into isc_dr_costs_conv_tmp
344: ( func_currency_code
345: , date_closed
346: , g_conv_rate
347: , sg_conv_rate

Line 746: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_CONV_TMP';

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:
748: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
749:
750: l_stmnt_id := 50;

Line 748: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );

744:
745: l_stmnt_id := 40;
746: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_CONV_TMP';
747:
748: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
749:
750: l_stmnt_id := 50;
751: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_F';
752:

Line 830: , isc_dr_costs_conv_tmp rates

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
834: group by stg.repair_line_id;

Line 1231: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_CONV_TMP';

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:
1233: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
1234:
1235: l_stmnt_id := 40;

Line 1233: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );

1229:
1230: l_stmnt_id := 30;
1231: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_CONV_TMP';
1232:
1233: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
1234:
1235: l_stmnt_id := 40;
1236: if isc_depot_backlog_etl_pkg.get_last_run_date
1237: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

Line 1305: , isc_dr_costs_conv_tmp rates

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
1309: group by stg.repair_line_id