2150: bd.description,
2151: to_char(bdri.department_id) as department_id,
2152: to_char(ppf.person_id) as person_id,
2153: bdri.resource_id as resource_id
2154: from bom_dept_res_instances bdri,
2155: bom_departments bd,
2156: bom_resource_employees bre,
2157: per_people_f ppf
2158: where bdri.instance_id = bre.instance_id
2166: bd.description,
2167: to_char(bdr.department_id) as department_id,
2168: to_char(ppf.person_id) as person_id,
2169: bdri.resource_id as resource_id
2170: from bom_dept_res_instances bdri,
2171: bom_departments bd,
2172: bom_resource_employees bre,
2173: bom_department_resources bdr,
2174: per_people_f ppf