[Home] [Help]
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
228: WHERE
229: nvl(cpr.owning_department_id, cpr.department_id) = list.number5
230: AND cpr.resource_id = list.number3
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
301: WHERE
302: nvl(cpr.owning_department_id, cpr.department_id) = list.number5
303: AND cpr.resource_id = list.number3
485: msrs.daily_rate, -- this might not be right, used to be load_factor_rate
486: to_number(-1),
487: to_char('-1')
488: FROM msc_form_query list,
489: msc_supplies msrs
490: WHERE trunc(msrs.first_unit_start_date) <= trunc(g_cutoff_date)
491: AND msrs.plan_id = g_designator
492: AND msrs.organization_id = list.number1
493: AND msrs.sr_instance_id = list.number4
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
572: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
573: AND cpr.resource_id = list.number3
574: AND cpr.plan_id = g_designator
810: msrs.daily_rate, -- this might not be right, used to be load_factor_rate
811: to_number(null),
812: to_char(null)
813: FROM msc_form_query list,
814: msc_supplies msrs
815: WHERE trunc(msrs.first_unit_start_date) <= trunc(g_cutoff_date)
816: AND msrs.plan_id = g_designator
817: AND msrs.organization_id = list.number1
818: AND msrs.sr_instance_id = list.number4
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
903: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
904: AND cpr.resource_id = list.number3
905: AND cpr.plan_id = g_designator
1026: NVL(sup.weight_capacity_used,0)
1027: , to_number(null),
1028: to_char(NULL)
1029: FROM msc_interorg_ship_methods sm,
1030: msc_supplies sup,
1031: msc_form_query list
1032: WHERE sm.plan_id = g_designator
1033: AND sm.plan_id = sup.plan_id
1034: AND sm.to_organization_id = sup.organization_id
1052: NVL(sup.volume_capacity_used,0)
1053: , to_number(null),
1054: to_char(NULL)
1055: FROM msc_interorg_ship_methods sm,
1056: msc_supplies sup,
1057: msc_form_query list
1058: WHERE sm.plan_id = g_designator
1059: AND sm.plan_id = sup.plan_id
1060: AND sm.to_organization_id = sup.organization_id