1516: /*if there are no plant specific overrides */
1517: SELECT MIN( NVL(orgnres.max_capacity, crres.max_capacity) ) max_cap,
1518: crres.capacity_um capacity_um
1519: FROM (SELECT resources, max_capacity, capacity_um, capacity_constraint 1520: FROM cr_rsrc_mst_b m 1521: WHERE capacity_constraint = 1
1522: AND NOT EXISTS (SELECT 1
1523: FROM cr_rsrc_dtl d
1524: WHERE d.organization_id = vOrgn_id