BOM Bills of Material Parameters

select 
       maximum_bom_level maximum_bom_level,
       config_segment_name config_segment_name,
       bom_delete_status_code bom_delete_status,
       meaning config_number_method
from mfg_lookups lu,
     bom_parameters bp 
where bp.organization_id = :P_org_id 
  and lu.lookup_type (+) = 'BOM_CFG_NUMBER_METHOD'   
  and lu.lookup_code (+) = bp.config_number_method_type