Bill Of Material Report

Hi @Deepak ,

You can try the below query.  The Part_no “11000-1” is the FG I have used.

select LEVEL,
       PART_NO,
       IFSAPP.INVENTORY_PART_API.Get_Description(CONTRACT, PART_NO),
       CONTRACT,
       ENG_CHG_LEVEL,
       BOM_TYPE,
       BOM_TYPE_DB,
       ALTERNATIVE_NO,
       IFSAPP.MANUF_STRUCT_ALTERNATE_API.Get_Alternative_Description(CONTRACT,
                                                                     PART_NO,
                                                                     ENG_CHG_LEVEL,
                                                                     BOM_TYPE,
                                                                     ALTERNATIVE_NO),
       COMPONENT_PART,
       IFSAPP.INVENTORY_PART_API.Get_Description(CONTRACT, COMPONENT_PART),
       QTY_PER_ASSEMBLY,
       IFSAPP.INVENTORY_PART_API.Get_Unit_Meas(Contract, COMPONENT_PART),
       OPERATION_NO,
       IFSAPP.INVENTORY_PART_API.Get_Mrp_Order_Code(CONTRACT,
                                                    COMPONENT_PART),
       IFSAPP.INVENTORY_PART_API.Get_Planner_Buyer(CONTRACT, COMPONENT_PART),
       IFSAPP.INVENTORY_PART_PLANNING_API.Get_Min_Order_Qty(CONTRACT,
                                                            COMPONENT_PART),
       IFSAPP.INVENTORY_PART_PLANNING_API.Get_Mul_Order_Qty(CONTRACT,
                                                            COMPONENT_PART),
       IFSAPP.INVENTORY_PART_PLANNING_API.Get_Max_Order_Qty(CONTRACT,
                                                            COMPONENT_PART),
       NOTE_TEXT,
       LINE_ITEM_NO
  from IFSAPP.MANUF_STRUCTURE
CONNECT BY PRIOR COMPONENT_PART = PART_NO
       AND PRIOR CONTRACT = CONTRACT
      /* AND eff_phase_in_date <= '2021 - 05 - 21 - 20.59.37'
       AND nvl(eff_phase_out_date, '2021 - 05 - 21 - 20.59.37') >=
           '2021 - 05 - 21 - 20.59.37'*/
 START WITH PART_NO = '11000-1'
        and CONTRACT = '1'
        and BOM_TYPE_DB = 'M'
        and ENG_CHG_LEVEL = '2'
 ORDER SIBLINGS BY LINE_ITEM_NO;

As result of the query you will get to see the structure (BOM). The LEVEL denotes at which position the component part (RM) is at and under which immediate parent .
 

However, you can use the below window/tab to view the same in the application. In IFS we use this Product Structure window to setup the BOM.

Additionally, you can use the below as well (quite graphical)