[Home] [Help]
562: else 'OPEN'
563: end
564: from
565: csp_required_parts_temp crpt,
566: cac_sr_object_capacity csoc,
567: csp_sec_inventories csi
568: where (cr.organization_id <> l_organization_id
569: or nvl(cr.secondary_inventory,'-1') <> l_subinventory_code)
570: and csi.organization_id = cr.organization_id