Reports 2017-11-18T12:27:27+00:00

CRP Available Resources

Description
Categories: Enginatics, Manufacturing
Capacity plans available resources with one record per date range and daily hours capacity of that resource.

select
bd.department_code,
br.resource_code,
br.description,
car.resource_hours,
car.resource_units,
car.resource_start_date,
car.resource_end_date
from
crp_available_resources car,
bom_departments bd,
bom_resources br
where
1=1 and
car.department_id=bd.department_id(+) and
car.resource_id=br.resource_id(+)
order by
br.resource_code,
car.resource_start_date desc

Parameter Name SQL text Validation
Department
bd.department_code=:department_code
LOV
Resource
br.resource_code=:resource_code
LOV
Plan
car.compile_designator=:compile_designator
LOV
Organization Code
car.organization_id=:organization_id
LOV Oracle