BOM Bill of Material Listing GUI

Description
Categories: BI Publisher, Manufacturing
Application: Bills of Material
Source: Bill of Material Listing GUI (XML)
Short Name: BOMRASSYG_XML
DB package: BOM_BOMRASSY_XMLP_PKG
select 
            &P_ASSEMBLY                                             assembly_flex_values,
            item1.description                                          assy_desc,
            DECODE(b.assembly_type, 1,'No','Yes')  eng_bill_flag,
            null                                            catg_flex_values,
            b.alternate_bom_designator                       alternate,
            b.organization_id                                         organization_id,
            null                                              common_flex_values,
            item2.description                                          common_desc,
            item2.organization_id                                   common_org_id,
            item1.inventory_item_id                               item_id,
            b.assembly_item_id                                      assy_id,
            NVL(b.common_assembly_item_id,b.assembly_item_id) common_assy_id,
            b.common_organization_id, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly_flex_format', 'INV', 'MSTK', 101, item1.ORGANIZATION_ID, item1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') assembly_flex_format, 
	BOM_BOMRASSY_XMLP_PKG.get_common_org(b.common_organization_id) C_common_org_code, 
	BOM_BOMRASSY_XMLP_PKG.org_codeformula(b.organization_id) ORG_CODE, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('common_flex_format', 'INV', 'MSTK', 101, item2.ORGANIZATION_ID, item2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') common_flex_format, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('catg_flex_format', 'INV', 'MCAT', mcat.STRUCTURE_ID, NULL, mcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') catg_flex_format
from   bom_bill_of_materials b,
         mtl_item_categories    micat,
         mtl_system_items        item1,
         mtl_system_items        item2,
         mtl_categories             mcat,
         bom_lists                     blist
where 
blist.sequence_id = :P_SEQUENCE_ID
and blist.organization_id = b.organization_id
and b.assembly_item_id = item1.inve