SELECT distinct
             line.contract,
             line.part_no,
             line.eng_chg_level,
      -- RoSeCz 832971 - Begin
             line.alternative_no,
      -- RoSeCz 832971 - End
             Shop_Ord_Code_API.Decode(line.bom_type) bom_type_client,
             line.bom_type             bom_type_db,
             line.eff_phase_in_date,
             line.eff_phase_out_date,
             line.rowtype
      FROM   MANUF_STRUCTURE_TAB line, MANUF_STRUCT_ALTERNATE_TAB alt
      WHERE  alt.rowstate ='Buildable'
      AND    alt.alternative_no = line.alternative_no
      AND    alt.bom_type = line.bom_type
      AND    alt.eng_chg_level = line.eng_chg_level
      AND    alt.contract = line.contract
      AND    alt.part_no = line.part_no
      --AND    NVL(line.eff_phase_out_date, TO_DATE('31.12.99','DD.MM.YY')) > TO_DATE('16.11.23', 'DD.MM.YY')
     -- RoSeCz 832971 - Begin
      -- AND    line.part_no  = NVL(part_no_, line.part_no)
      AND    line.part_no >=
             (select  min (t.part_no) from MANUF_STRUCTURE_TAB t where t.part_no like NVL('A2903584', line.part_no))
      AND    line.part_no <=
             (select  max (t.part_no) from MANUF_STRUCTURE_TAB t where t.part_no like NVL('A2903584', line.part_no))
      -- RoSeCz 832971 - End
      AND    line.contract = 'ZPA'
      -- RoSeCz 832971 - Begin
      -- AND    line.component_part = part_out_
      AND    line.component_part = nvl (NULL,line.component_part)
      -- RoSeCz 832971 - End
      ORDER BY line.contract, line.part_no, to_number(line.eng_chg_level), bom_type_client;