CRP Available Resources

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github
Detail report showing the date range availability of each resource, as well as daily hours and unit capacity of the resource.
Run CRP Available Resources and other Oracle EBS reports with Blitz Report™ on our demo environment
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