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_BACKLOG_ETL_PKG dependencies on ISC_DR_REPAIR_ORDERS_F

Line 13: g_object_name constant varchar2(30) := 'ISC_DR_REPAIR_ORDERS_F';

9: c_errbuf_size constant number := 300; -- length of formatted error message
10:
11: g_global_start_date date;
12: g_isc_schema varchar2(30);
13: g_object_name constant varchar2(30) := 'ISC_DR_REPAIR_ORDERS_F';
14:
15: -- Common Procedures (for initial and incremental load)
16:
17: -- err_mesg

Line 303: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';

299:
300: l_stmnt_id := 20;
301: delete
302: from isc_dr_inc
303: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';
304:
305: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
306:
307: l_stmnt_id := 30;

Line 308: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_REPAIR_ORDERS_F';

304:
305: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
306:
307: l_stmnt_id := 30;
308: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_REPAIR_ORDERS_F';
309:
310: bis_collection_utilities.log( 'Truncated table ISC_DR_REPAIR_ORDERS_F', 1 );
311:
312: l_stmnt_id := 40;

Line 310: bis_collection_utilities.log( 'Truncated table ISC_DR_REPAIR_ORDERS_F', 1 );

306:
307: l_stmnt_id := 30;
308: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_REPAIR_ORDERS_F';
309:
310: bis_collection_utilities.log( 'Truncated table ISC_DR_REPAIR_ORDERS_F', 1 );
311:
312: l_stmnt_id := 40;
313: l_run_date := sysdate - 5/(24*60);
314: l_to_date := sysdate;

Line 326: insert /+ append parallel(isc_dr_repair_orders_f) /

322: end if;
323: bis_collection_utilities.log( 'Master organization id: ' || l_master_org, 1 );
324:
325: l_stmnt_id := 60;
326: insert /*+ append parallel(isc_dr_repair_orders_f) */
327: into isc_dr_repair_orders_f
328: ( repair_line_id
329: , repair_number
330: , repair_organization_id

Line 327: into isc_dr_repair_orders_f

323: bis_collection_utilities.log( 'Master organization id: ' || l_master_org, 1 );
324:
325: l_stmnt_id := 60;
326: insert /*+ append parallel(isc_dr_repair_orders_f) */
327: into isc_dr_repair_orders_f
328: ( repair_line_id
329: , repair_number
330: , repair_organization_id
331: , master_organization_id

Line 410: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_REPAIR_ORDERS_F' , 1 );

406: cr.Date_closed >= g_global_start_date
407: );
408:
409: l_rowcount := sql%rowcount;
410: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_REPAIR_ORDERS_F' , 1 );
411:
412: l_stmnt_id := 70;
413: insert into isc_dr_inc
414: ( fact_name

Line 427: ( 'ISC_DR_REPAIR_ORDERS_F'

423: , program_application_id
424: , request_id
425: )
426: values
427: ( 'ISC_DR_REPAIR_ORDERS_F'
428: , l_run_date
429: , l_user_id
430: , sysdate
431: , sysdate

Line 528: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

524: end if;
525:
526: l_stmnt_id := 10;
527: if get_last_run_date
528: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
529: , x_run_date => l_last_run_date
530: , x_message => l_message
531: ) <> c_ok then
532: raise l_exception;

Line 556: merge into isc_dr_repair_orders_f fact

552: end if;
553: bis_collection_utilities.log( 'Master organization id: ' || l_master_org, 1 );
554:
555: l_stmnt_id := 40;
556: merge into isc_dr_repair_orders_f fact
557: using
558: ( select
559: cr.repair_line_id repair_line_id
560: , cr.repair_number repair_number

Line 696: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_REPAIR_ORDERS_F' , 1 );

692: , l_request_id
693: );
694:
695: l_rowcount := sql%rowcount;
696: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_REPAIR_ORDERS_F' , 1 );
697:
698: l_stmnt_id := 50;
699: update isc_dr_inc
700: set

Line 709: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';

705: , program_id = l_program_id
706: , program_login_id = l_program_login_id
707: , program_application_id = l_program_application_id
708: , request_id = l_request_id
709: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';
710:
711: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );
712:
713: l_stmnt_id := 60;