5447: where l.line_type = 'LINE'
5448: and l.warehouse_id is not null
5449: and not exists (select 'x'
5450: from hr_organization_units hou,
5451: hr_organization_information hoi1,
5452: hr_organization_information hoi2,
5453: mtl_parameters mp,
5454: gl_sets_of_books gsob
5455: where hou.organization_id = hoi1.organization_id
5448: and l.warehouse_id is not null
5449: and not exists (select 'x'
5450: from hr_organization_units hou,
5451: hr_organization_information hoi1,
5452: hr_organization_information hoi2,
5453: mtl_parameters mp,
5454: gl_sets_of_books gsob
5455: where hou.organization_id = hoi1.organization_id
5456: and hou.organization_id = hoi2.organization_id