Tabulky - STD_BIM_USE - STD_DATA_NEEDED - STD_PHASE_USE - STD_PRJ_PHASE - STD_PROPERTY_SET_INDEX

select
    P.Kod,
    U.ID,
    U.Visible,
    U.Por_Nov Poradi,
    X.Vaha,
    U.Nazev_CZ,
    ( select
          N.Visible
        from
          STD_Property_Set_Index I,
          STD_Data_Needed N
        where I.Znak='I'
          and N.Index_ID=I.ID
          and N.Phase_ID=P.ID
          and N.Use_ID  =U.ID ) Vis_I,
    ( select
          N.Visible
        from
          STD_Property_Set_Index I,
          STD_Data_Needed N
        where I.Znak='S'
          and N.Index_ID=I.ID
          and N.Phase_ID=P.ID
          and N.Use_ID  =U.ID ) Vis_S,
    ( select
          N.Visible
        from
          STD_Property_Set_Index I,
          STD_Data_Needed N
        where I.Znak='E'
          and N.Index_ID=I.ID
          and N.Phase_ID=P.ID
         and N.Use_ID   =U.ID ) Vis_E,
    ( select
          N.Visible
        from
          STD_Property_Set_Index I,
          STD_Data_Needed N
        where I.Znak='Z'
          and N.Index_ID=I.ID
          and N.Phase_ID=P.ID
         and N.Use_ID   =U.ID ) Vis_Z,
    ( select
          N.Visible
        from
          STD_Property_Set_Index I,
          STD_Data_Needed N
        where I.Znak='M'
          and N.Index_ID=I.ID
          and N.Phase_ID=P.ID
         and N.Use_ID   =U.ID ) Vis_M,
    ( select
          N.Visible
        from
          STD_Property_Set_Index I,
          STD_Data_Needed N
        where I.Znak='F'
          and N.Index_ID=I.ID
          and N.Phase_ID=P.ID
         and N.Use_ID   =U.ID ) Vis_F
  from
    STD_BIM_Use U,
    STD_Phase_Use X,
    STD_PRJ_Phase P
  where X.Phase_ID=P.ID
    and U.ID=X.Use_ID