[Home] [Help]
1430: end if ;
1431:
1432:
1433: -- Calculate the resource availability and populate the
1434: -- information into MRP_NET_RESOURCE_AVAIL
1435:
1436: Wip_Prod_Indicators.Calculate_Resource_Avail(
1437: p_organization_id => p_organization_id,
1438: p_date_from => x_sim_date_from,
1635: SET wit.available_units = (
1636: select
1637: nvl(sum(((mnra.to_time-mnra.from_time)/3600)*mnra.capacity_units),0)
1638: from
1639: mrp_net_resource_avail mnra
1640: where
1641: mnra.organization_id = wit.organization_id
1642: and mnra.resource_id = wit.resource_id
1643: and mnra.department_id = wit.department_id
1742: nvl(count(distinct shift_date),0)
1743: into
1744: x_sched_days
1745: from
1746: mrp_net_resource_avail
1747: where resource_id = p_resource_id
1748: and organization_id = p_organization_id
1749: and simulation_set is null
1750: and shift_date between p_sched_start_date and p_date_to ;
1761: nvl(count(distinct shift_date),0)
1762: into
1763: x_total_days
1764: from
1765: mrp_net_resource_avail
1766: where resource_id = p_resource_id
1767: and organization_id = p_organization_id
1768: and simulation_set is null
1769: and shift_date between p_sched_start_date and p_sched_completion_date ;
1786: nvl(count(distinct shift_date),0)
1787: into
1788: x_sched_days
1789: from
1790: mrp_net_resource_avail
1791: where resource_id = p_resource_id
1792: and organization_id = p_organization_id
1793: and simulation_set is null
1794: and shift_date between p_date_from and p_date_to ;
1805: nvl(count(distinct shift_date),0)
1806: into
1807: x_total_days
1808: from
1809: mrp_net_resource_avail
1810: where resource_id = p_resource_id
1811: and organization_id = p_organization_id
1812: and simulation_set is null
1813: and shift_date between p_date_from and p_sched_completion_date ;