DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 287: FROM eam_org_maint_defaults

283: --if workorder dept. is null,de fault it from asset's owning dept
284:
285: SELECT OWNING_DEPARTMENT_ID
286: INTO l_fail_dept_id
287: FROM eam_org_maint_defaults
288: WHERE object_id =l_maintenance_object_id
289: AND object_type = 50
290: AND organization_id =l_eam_wo_comp_rec.organization_id;
291:

Line 294: FROM eam_org_maint_defaults

290: AND organization_id =l_eam_wo_comp_rec.organization_id;
291:
292: SELECT area_id
293: INTO l_eam_location_id
294: FROM eam_org_maint_defaults
295: WHERE object_id = l_maintenance_object_id
296: AND object_type = 50
297: AND organization_id = l_eam_wo_comp_rec.organization_id;
298:

Line 697: FROM eam_org_maint_defaults

693: --if workorder dept. is null,de fault it from asset's owning dept
694: IF(l_fail_dept_id IS NULL) THEN
695: SELECT OWNING_DEPARTMENT_ID
696: INTO l_fail_dept_id
697: FROM eam_org_maint_defaults
698: WHERE object_id =l_maintenance_object_id
699: AND object_type = 50
700: AND organization_id =l_eam_wo_comp_rec.organization_id;
701: END IF;

Line 705: FROM eam_org_maint_defaults

701: END IF;
702:
703: SELECT area_id
704: INTO l_eam_location_id
705: FROM eam_org_maint_defaults
706: WHERE object_id = l_maintenance_object_id
707: AND object_type = 50
708: AND organization_id = l_eam_wo_comp_rec.organization_id;
709: