1465: /*if there are no plant specific overrides */
1466: SELECT MIN( NVL(orgnres.max_capacity, crres.max_capacity) ) max_cap,
1467: crres.capacity_um capacity_um
1468: FROM (SELECT resources, max_capacity, capacity_um, capacity_constraint 1469: FROM cr_rsrc_mst_b m 1470: WHERE capacity_constraint = 1
1471: AND NOT EXISTS (SELECT 1
1472: FROM cr_rsrc_dtl d
1473: WHERE d.organization_id = vOrgn_id