DBA Data[Home] [Help]

APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES_V

Line 102: FROM mtl_eam_asset_activities_v meaa

98: meaa.Attribute15,
99: meaa.Activity_Association_Id, meaa.organization_id, meaa.accounting_class_code,
100: meaa.owning_department_id, meaa.Activity_Cause_Code, meaa.Activity_Type_Code,
101: meaa.Activity_Source_Code, meaa.Tagging_Required_Flag, meaa.Shutdown_Type_Code
102: FROM mtl_eam_asset_activities_v meaa
103: WHERE meaa.asset_activity_id = p_source_activity_id
104: AND (p_maintenance_object_type IS NULL OR meaa.maintenance_object_type = p_maintenance_object_type)
105: AND (p_maintenance_object_id IS NULL OR meaa.maintenance_object_id = p_maintenance_object_id)
106: AND (p_tmpl_flag IS NULL OR NVL(meaa.template_flag, 'N') = p_tmpl_flag)