244: to_char('-1')
245: FROM
246: msc_resource_requirements crp,
247: msc_department_resources cpr,
248: msc_resource_batches mrb,
249: msc_supplies mss,
250: msc_form_query list
251: WHERE
252: nvl(cpr.owning_department_id, cpr.department_id) = list.number5
324: to_char('-1')
325: FROM
326: msc_resource_requirements crp,
327: msc_department_resources cpr,
328: msc_resource_batches mrb,
329: msc_supplies mss,
330: msc_form_query list
331: WHERE
332: nvl(cpr.owning_department_id, cpr.department_id) = list.number5
406: to_char('-1')
407: FROM
408: msc_resource_requirements crp,
409: msc_department_resources cpr,
410: msc_resource_batches mrb,
411: msc_supplies mss,
412: msc_form_query list
413: WHERE
414: nvl(cpr.owning_department_id, cpr.department_id) = list.number5