BOM Bills of Material Parameters

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Bills of Material Parameters Report
Application: Bills of Material
Source: Bills of Material Parameters Report (XML)
Short Name: BOMRDBPR_XML
DB package: BOM_BOMRDBPR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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