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_MAINT_WO_CST_ETL_PKG dependencies on WIP_EAM_PERIOD_BALANCES

Line 552: , wip_eam_period_balances pb

548: , g_program_application_id
549: , g_request_id
550: from
551: isc_maint_work_orders_f wo
552: , wip_eam_period_balances pb
553: where
554: wo.work_order_id = pb.wip_entity_id
555: and wo.organization_id = pb.organization_id
556: and nvl(wo.completion_date, wo.closed_date) >= g_global_start_date

Line 879: wip_eam_period_balances pb

875: , pb.system_estimated_mat_cost
876: , pb.system_estimated_lab_cost
877: , pb.system_estimated_eqp_cost
878: from
879: wip_eam_period_balances pb
880: , (
881: -- identifies all completed/closed work orders that
882: -- have at least on cost balance row updated since
883: -- last collection

Line 892: , wip_eam_period_balances pb

888: , wo.completion_date
889: , wo.closed_date
890: from
891: isc_maint_work_orders_f wo
892: , wip_eam_period_balances pb
893: where
894: pb.last_update_date >= l_collect_from_date
895: and wo.work_order_id = pb.wip_entity_id
896: and wo.organization_id = pb.organization_id

Line 919: , wip_eam_period_balances pb

915: , wo.completion_date
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