APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_RESOURCE_REQUIREMENTS

Line 246: msc_resource_requirements crp,

242: avg(crp.resource_hours),
243: to_number(-1),
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

Line 326: msc_resource_requirements crp,

322: avg(crp.resource_hours),
323: to_number(-1),
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

Line 408: msc_resource_requirements crp,

404: avg(crp.resource_hours),
405: to_number(-1),
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

Line 493: msc_resource_requirements crp,

489: sum((cpr.max_rate*crp.daily_resource_hours))),
490: to_number(-1),
491: to_char('-1')
492: FROM
493: msc_resource_requirements crp,
494: msc_department_resources cpr,
495: msc_form_query list
496: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
497: AND cpr.resource_id = list.number3

Line 565: msc_resource_requirements crp,

561: sum((cpr.max_rate*crp.daily_resource_hours))),
562: to_number(-1),
563: to_char('-1')
564: FROM
565: msc_resource_requirements crp,
566: msc_department_resources cpr,
567: msc_form_query list
568: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
569: AND cpr.resource_id = list.number3

Line 714: FROM msc_resource_requirements crp,

710: crp.daily_resource_hours),
711: cpr.max_rate*crp.daily_resource_hours))),
712: TO_NUMBER(-1),
713: to_char('-1')
714: FROM msc_resource_requirements crp,
715: msc_department_resources cpr,
716: msc_form_query list,
717: msc_supplies s,
718: msc_system_items i

Line 809: msc_resource_requirements crp,

805: sum((cpr.max_rate*mrir.daily_res_instance_hours))),
806: mrir.res_instance_id,
807: mrir.serial_number
808: FROM
809: msc_resource_requirements crp,
810: msc_department_resources cpr,
811: msc_dept_res_instances mdri,
812: msc_resource_instance_reqs mrir,
813: msc_form_query list

Line 900: msc_resource_requirements crp,

896: sum((cpr.max_rate*mrir.daily_res_instance_hours))),
897: mrir.res_instance_id,
898: mrir.serial_number
899: FROM
900: msc_resource_requirements crp,
901: msc_department_resources cpr,
902: msc_dept_res_instances mdri,
903: msc_resource_instance_reqs mrir,
904: msc_form_query list

Line 1073: FROM msc_resource_requirements crp,

1069: crp.daily_resource_hours),
1070: cpr.max_rate*crp.daily_resource_hours))),
1071: to_number(null),
1072: to_char(null)
1073: FROM msc_resource_requirements crp,
1074: msc_department_resources cpr,
1075: msc_form_query list,
1076: msc_supplies s,
1077: msc_system_items i