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.

[Home] [Help]

APPS.ISC_MAINT_WO_CST_ETL_PKG dependencies on ISC_MAINT_WO_CST_SUM_STG

Line 152: , ( select /+ index_ffs(isc_maint_wo_cst_sum_stg) / distinct

148: , nvl(r.conversion_rate2, -999) secondary_rate
149: from
150: isc_maint_wo_cst_conv_rates r
151: , mtl_parameters mp
152: , ( select /*+ index_ffs(isc_maint_wo_cst_sum_stg) */ distinct
153: organization_id
154: , completion_date
155: from isc_maint_wo_cst_sum_stg
156: ) s

Line 155: from isc_maint_wo_cst_sum_stg

151: , mtl_parameters mp
152: , ( select /*+ index_ffs(isc_maint_wo_cst_sum_stg) */ distinct
153: organization_id
154: , completion_date
155: from isc_maint_wo_cst_sum_stg
156: ) s
157: where ( nvl(r.conversion_rate1, -999) < 0 or
158: nvl(r.conversion_rate2, -999) < 0 )
159: and mp.organization_id = s.organization_id

Line 292: ( select /*+ index_ffs(isc_maint_wo_cst_sum_stg)

288: , g_program_login_id
289: , g_program_application_id
290: , g_request_id
291: from
292: ( select /*+ index_ffs(isc_maint_wo_cst_sum_stg)
293: parallel_index(isc_maint_wo_cst_sum_stg) */ distinct
294: organization_id
295: , completion_date
296: , completed_flag

Line 293: parallel_index(isc_maint_wo_cst_sum_stg) */ distinct

289: , g_program_application_id
290: , g_request_id
291: from
292: ( select /*+ index_ffs(isc_maint_wo_cst_sum_stg)
293: parallel_index(isc_maint_wo_cst_sum_stg) */ distinct
294: organization_id
295: , completion_date
296: , completed_flag
297: from

Line 298: isc_maint_wo_cst_sum_stg

294: organization_id
295: , completion_date
296: , completed_flag
297: from
298: isc_maint_wo_cst_sum_stg
299: ) s
300: , ( select distinct
301: hoi.organization_id
302: , gsob.currency_code

Line 479: , 'ISC_MAINT_WO_CST_SUM_STG'

475: -- truncate the staging table
476: l_stmt_id := 30;
477: if truncate_table
478: ( l_isc_schema
479: , 'ISC_MAINT_WO_CST_SUM_STG'
480: , l_error_message ) <> 0 then
481: logger( l_proc_name, l_stmt_id, l_error_message );
482: raise l_exception;
483: end if;

Line 497: into isc_maint_wo_cst_sum_stg s

493: -- date -- to be confirmed.
494: -- ------------------------------------------------------------
495: l_stmt_id := 40;
496: insert /*+ append parallel(s) */
497: into isc_maint_wo_cst_sum_stg s
498: ( organization_id
499: , work_order_id
500: , department_id
501: , maint_cost_category

Line 574: , 'ISC_MAINT_WO_CST_SUM_STG'

570: -- conversion rates
571: l_stmt_id := 50;
572: if gather_statistics
573: ( l_isc_schema
574: , 'ISC_MAINT_WO_CST_SUM_STG'
575: , l_error_message ) <> 0 then
576: logger( l_proc_name, l_stmt_id, l_error_message );
577: raise l_exception;
578: end if;

Line 658: isc_maint_wo_cst_sum_stg s

654: , g_program_login_id
655: , g_program_application_id
656: , g_request_id
657: from
658: isc_maint_wo_cst_sum_stg s
659: , isc_maint_wo_cst_conv_rates c
660: where
661: c.organization_id = s.organization_id
662: and c.transaction_date = s.completion_date;

Line 674: , 'ISC_MAINT_WO_CST_SUM_STG'

670: -- house keeping -- cleanup staging/currency conversion tables
671: l_stmt_id := 90;
672: if truncate_table
673: ( l_isc_schema
674: , 'ISC_MAINT_WO_CST_SUM_STG'
675: , l_error_message ) <> 0 then
676: logger( l_proc_name, l_stmt_id, l_error_message );
677: raise l_exception;
678: end if;

Line 783: , 'ISC_MAINT_WO_CST_SUM_STG'

779: -- truncate the staging table
780: l_stmt_id := 30;
781: if truncate_table
782: ( l_isc_schema
783: , 'ISC_MAINT_WO_CST_SUM_STG'
784: , l_error_message ) <> 0 then
785: logger( l_proc_name, l_stmt_id, l_error_message );
786: raise l_exception;
787: end if;

Line 802: into isc_maint_wo_cst_sum_stg

798: -- since the last collection
799: -- ------------------------------------------------------------
800: l_stmt_id := 40;
801: insert /*+ append */
802: into isc_maint_wo_cst_sum_stg
803: ( organization_id
804: , work_order_id
805: , department_id
806: , maint_cost_category

Line 997: , 'ISC_MAINT_WO_CST_SUM_STG'

993: -- conversion rates
994: l_stmt_id := 50;
995: if gather_statistics
996: ( l_isc_schema
997: , 'ISC_MAINT_WO_CST_SUM_STG'
998: , l_error_message ) <> 0 then
999: logger( l_proc_name, l_stmt_id, l_error_message );
1000: raise l_exception;
1001: end if;

Line 1064: isc_maint_wo_cst_sum_stg s

1060: , g_program_login_id program_login_id
1061: , g_program_application_id program_application_id
1062: , g_request_id request_id
1063: from
1064: isc_maint_wo_cst_sum_stg s
1065: , isc_maint_wo_cst_conv_rates c
1066: where
1067: c.organization_id = s.organization_id
1068: and c.transaction_date = s.completion_date

Line 1156: , 'ISC_MAINT_WO_CST_SUM_STG'

1152: -- house keeping -- cleanup staging/currency conversion tables
1153: l_stmt_id := 80;
1154: if truncate_table
1155: ( l_isc_schema
1156: , 'ISC_MAINT_WO_CST_SUM_STG'
1157: , l_error_message ) <> 0 then
1158: logger( l_proc_name, l_stmt_id, l_error_message );
1159: raise l_exception;
1160: end if;