APPS.ISC_MAINT_WO_CST_ETL_PKG dependencies on ISC_MAINT_WO_CST_SUM_F

Line 595: , 'ISC_MAINT_WO_CST_SUM_F'

591: -- truncate the fact table
592: l_stmt_id := 70;
593: if truncate_table
594: ( l_isc_schema
595: , 'ISC_MAINT_WO_CST_SUM_F'
596: , l_error_message ) <> 0 then
597: logger( l_proc_name, l_stmt_id, l_error_message );
598: raise l_exception;
599: end if;

Line 606: into isc_maint_wo_cst_sum_f f

602:
603: -- insert into base fact from staging table
604: l_stmt_id := 80;
605: insert /*+ append parallel(f) */
606: into isc_maint_wo_cst_sum_f f
607: ( organization_id
608: , work_order_id
609: , department_id
610: , maint_cost_category

Line 920: , isc_maint_wo_cst_sum_f f

916: , wo.closed_date
917: from
918: isc_maint_work_orders_f wo
919: , wip_eam_period_balances pb
920: , isc_maint_wo_cst_sum_f f
921: where
922: wo.last_update_date >= l_collect_from_date
923: and ( nvl(nvl(wo.completion_date,closed_date),g_max_date) <> nvl(f.completion_date,g_max_date) or
924: -- this is necessary to pick up cost for any work order where the estimated

Line 942: -- returns an all "zero" cost row from isc_maint_wo_cst_sum_f

938: and wo.organization_id = pb.organization_id
939: --
940: union all
941: --
942: -- returns an all "zero" cost row from isc_maint_wo_cst_sum_f
943: -- for all completed/closed work orders have been updated since
944: -- last collection and have been re-estimated since last collection
945: -- (this allows us to catch work orders that have had a resource
946: -- estimated deleted that resulted in a row being deleted from

Line 947: -- period balances and zero out the isc_maint_wo_cst_sum_f row)

943: -- for all completed/closed work orders have been updated since
944: -- last collection and have been re-estimated since last collection
945: -- (this allows us to catch work orders that have had a resource
946: -- estimated deleted that resulted in a row being deleted from
947: -- period balances and zero out the isc_maint_wo_cst_sum_f row)
948: select
949: wo.organization_id
950: , wo.work_order_id
951: , wo.status_type

Line 964: , isc_maint_wo_cst_sum_f f

960: , 0 system_estimated_lab_cost
961: , 0 system_estimated_eqp_cost
962: from
963: isc_maint_work_orders_f wo
964: , isc_maint_wo_cst_sum_f f
965: where
966: wo.status_type in (4, 5, 12)
967: and wo.last_update_date >= l_collect_from_date
968: and wo.last_estimation_date >= l_collect_from_date

Line 1016: merge into isc_maint_wo_cst_sum_f f

1012: end if;
1013:
1014: -- merge staging table into base fact
1015: l_stmt_id := 70;
1016: merge into isc_maint_wo_cst_sum_f f
1017: using
1018: ( select
1019: s.organization_id
1020: , s.work_order_id