BOM Bills of Material Parameters

Description
Categories: BI Publisher, Manufacturing
Application: Bills of Material
Source: Bills of Material Parameters Report (XML)
Short Name: BOMRDBPR_XML
DB package: BOM_BOMRDBPR_XMLP_PKG
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
Ask a question
Parameter Name SQL text Validation
Organization Id:
 
Number