CRP Available Resources
Description
- Categories
- Enginatics
- Repository
- GitHub
Detail report showing the date range availability of each resource, as well as daily hours and unit capacity of the resource.
SQL 27 lines
select car.compile_designator plan, mp.organization_code, bd.department_code, br.resource_code, br.description, car.resource_hours, car.resource_units, car.resource_start_date, car.resource_end_date from mtl_parameters mp, crp_available_resources car, bom_departments bd, bom_resources br where 1=1 and car.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and mp.organization_id=car.organization_id and car.department_id=bd.department_id(+) and car.resource_id=br.resource_id(+) order by car.compile_designator, mp.organization_code, bd.department_code, br.resource_code, car.resource_start_date desc |
Parameters 4
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Organization Code | LOV |
| |
| Plan | LOV |
| |
| Department | LOV |
| |
| Resource | LOV |
|