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.

[Home] [Help]

APPS.WIP_EAM_WORKREQUEST_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 166: FROM eam_org_maint_defaults eomd

162: begin
163: -- select owning dept from asset
164: SELECT eomd.owning_department_id
165: INTO l_owning_dept_id
166: FROM eam_org_maint_defaults eomd
167: WHERE eomd.object_type(+) = 50
168: AND eomd.object_id = l_maintenance_object_id
169: and organization_id = p_org_id;
170: exception

Line 3455: from eam_org_maint_defaults

3451: begin
3452:
3453: SELECT owning_department_id
3454: into l_owning_dept_id
3455: from eam_org_maint_defaults
3456: where object_type = 50
3457: and object_id = p_maintenance_object_id
3458: and organization_id = p_org_id;
3459: exception

Line 3477: FROM eam_org_maint_defaults eomd

3473:
3474:
3475: SELECT owning_department_id
3476: INTO l_owning_dept_id
3477: FROM eam_org_maint_defaults eomd
3478: WHERE eomd.organization_id = p_org_id
3479:
3480: and eomd.object_type(+) = 50
3481: and eomd.object_id (+) = l_instance_id;

Line 3560: FROM eam_org_maint_defaults eomd

3556:
3557: BEGIN
3558: SELECT area_id
3559: INTO l_asset_location_id
3560: FROM eam_org_maint_defaults eomd
3561: WHERE eomd.organization_id = p_org_id
3562: AND eomd.object_type = 50
3563: AND eomd.object_id = l_instance_id;
3564: EXCEPTION