DBA Data[Home] [Help]

APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES_V

Line 118: FROM mtl_eam_asset_activities_v meaa

114: meaa.owning_department_id, meaa.Activity_Cause_Code, meaa.Activity_Type_Code,
115: meaa.Activity_Source_Code, meaa.Tagging_Required_Flag, meaa.Shutdown_Type_Code
116: , meaa.Work_Order_Type, meaa.Planner_Maintenance AS planner, meaa.Plan_Maintenance AS planned -- added for 16525236
117: , meaa.Firm_Planned_Flag as firm, meaa.Notification_Required -- ended for 16525236
118: FROM mtl_eam_asset_activities_v meaa
119: WHERE meaa.asset_activity_id = p_source_activity_id
120: AND (p_maintenance_object_type IS NULL OR meaa.maintenance_object_type = p_maintenance_object_type)
121: AND (p_maintenance_object_id IS NULL OR meaa.maintenance_object_id = p_maintenance_object_id)
122: AND (p_tmpl_flag IS NULL OR NVL(meaa.template_flag, 'N') = p_tmpl_flag)