Skip to main content

Hello Community ,

We are using IFS Apps 8 .

I need one quick report where Bill of Material part nos will come from FG to RM order .

Can some one provide the sql query for this output.

 

FG PART NO
ASSEMBLY PART NO
PAINTING PART NO
MOLDING PART NO
RAW MATERIAL PART NO
 

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 .
 

(there are lot of lines in my example I just took an extract of it)

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)

 

Thank You so much @Tharindu Illangasinghe for your swift reply…!!!!

Really appreciate it….!!!

 

I will check the out put of this query..

Terms & ConditionsCookie settings