APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_RESOURCE_REQUIREMENTS

Line 223: msc_resource_requirements crp,

219: avg(crp.resource_hours),
220: to_number(-1),
221: to_char('-1')
222: FROM
223: msc_resource_requirements crp,
224: msc_department_resources cpr,
225: msc_resource_batches mrb,
226: msc_supplies mss,
227: msc_form_query list

Line 296: msc_resource_requirements crp,

292: avg(crp.resource_hours),
293: to_number(-1),
294: to_char('-1')
295: FROM
296: msc_resource_requirements crp,
297: msc_department_resources cpr,
298: msc_resource_batches mrb,
299: msc_supplies mss,
300: msc_form_query list

Line 372: msc_resource_requirements crp,

368: sum((cpr.max_rate*crp.daily_resource_hours))),
369: to_number(-1),
370: to_char('-1')
371: FROM
372: msc_resource_requirements crp,
373: msc_department_resources cpr,
374: msc_form_query list
375: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
376: AND cpr.resource_id = list.number3

Line 435: msc_resource_requirements crp,

431: sum((cpr.max_rate*crp.daily_resource_hours))),
432: to_number(-1),
433: to_char('-1')
434: FROM
435: msc_resource_requirements crp,
436: msc_department_resources cpr,
437: msc_form_query list
438: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
439: AND cpr.resource_id = list.number3

Line 567: FROM msc_resource_requirements crp,

563: crp.daily_resource_hours),
564: cpr.max_rate*crp.daily_resource_hours))),
565: TO_NUMBER(-1),
566: to_char('-1')
567: FROM msc_resource_requirements crp,
568: msc_department_resources cpr,
569: msc_form_query list,
570: msc_supplies s,
571: msc_system_items i

Line 658: msc_resource_requirements crp,

654: sum((cpr.max_rate*mrir.daily_res_instance_hours))),
655: mrir.res_instance_id,
656: mrir.serial_number
657: FROM
658: msc_resource_requirements crp,
659: msc_department_resources cpr,
660: msc_dept_res_instances mdri,
661: msc_resource_instance_reqs mrir,
662: msc_form_query list

Line 740: msc_resource_requirements crp,

736: sum((cpr.max_rate*mrir.daily_res_instance_hours))),
737: mrir.res_instance_id,
738: mrir.serial_number
739: FROM
740: msc_resource_requirements crp,
741: msc_department_resources cpr,
742: msc_dept_res_instances mdri,
743: msc_resource_instance_reqs mrir,
744: msc_form_query list

Line 898: FROM msc_resource_requirements crp,

894: crp.daily_resource_hours),
895: cpr.max_rate*crp.daily_resource_hours))),
896: to_number(null),
897: to_char(null)
898: FROM msc_resource_requirements crp,
899: msc_department_resources cpr,
900: msc_form_query list,
901: msc_supplies s,
902: msc_system_items i