DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on MTL_EAM_LOCATIONS

Line 271: FROM eam_org_maint_defaults eomd, bom_departments bd, mtl_eam_locations mel,

267: l_buffer := NULL;
268: BEGIN
269: SELECT bd.department_code ||' '|| mel.location_codes ||' '|| eomd.accounting_class_code
270: INTO l_buffer
271: FROM eam_org_maint_defaults eomd, bom_departments bd, mtl_eam_locations mel,
272: mtl_parameters mp
273: WHERE mp.organization_id = l_org_id AND mp.maint_organization_id = eomd.organization_id
274: AND eomd.object_id = l_instance_id AND eomd.object_type = 50
275: AND eomd.owning_department_id = bd.department_id (+) AND eomd.area_id = mel.location_id(+);