SELECT dtcv.data_table_id AS data_table_id,
       dtcv.data_type AS test_data_type,
       dtcv.dtc1 AS attr1,
       dtcv.dtc2 AS attr2,
       dtcv.dtc3 AS attr3,
       dtcv.dtc4 AS attr4,
       dtcv.dtc5 AS attr5,
       dtcv.dtc6 AS attr6,
       dtcv.dtc7 AS attr7,
       dtcv.dtc8 AS attr8,
       dtcv.dtc9 AS attr9,
       dtcv.dtc10 AS attr10,
       dtcv.dtc11 AS attr11,
       dtcv.dtc12 AS attr12,
       dtcv.dtc13 AS attr13,
       dtcv.dtc14 AS attr14,
       dtcv.dtc15 AS attr15,
       dtcv.dtc16 AS attr16,
       dtcv.dtc17 AS attr17,
       dtcv.dtc18 AS attr18,
       dtcv.dtc19 AS attr19,
       dtcv.dtc20 AS attr20,
       dtcv.dtc21 AS attr21,
       dtcv.dtc22 AS attr22,
       dtcv.dtc23 AS attr23,
       dtcv.dtc24 AS attr24,
       dtcv.dtc25 AS attr25,
       dtcv.dtc26 AS attr26,
       dtcv.dtc27 AS attr27,
       dtcv.dtc28 AS attr28,
       dtcv.dtc29 AS attr29,
       dtcv.dtc30 AS attr30,
       dtcv.dtc31 AS attr31,
       dtcv.dtc32 AS attr32,
       dtcv.dtc33 AS attr33,
       dtcv.dtc34 AS attr34,
       dtcv.dtc35 AS attr35,
       dtcv.dtc36 AS attr36,
       dtcv.dtc37 AS attr37,
       dtcv.dtc38 AS attr38,
       dtcv.dtc39 AS attr39,
       dtcv.dtc40 AS attr40,
       dtcv.dtc41 AS attr41,
       dtcv.dtc42 AS attr42,
       dtcv.dtc43 AS attr43,
       dtcv.dtc44 AS attr44,
       dtcv.dtc45 AS attr45,
       dtcv.dtc46 AS attr46,
       dtcv.dtc47 AS attr47,
       dtcv.dtc48 AS attr48,
       dtcv.dtc49 AS attr49,
       dtcv.dtc50 AS attr50,
       dtcv.dtc51 AS attr51,
       dtcv.dtc52 AS attr52,
       dtcv.dtc53 AS attr53,
       dtcv.dtc54 AS attr54,
       dtcv.dtc55 AS attr55,
       dtcv.dtc56 AS attr56,
       dtcv.dtc57 AS attr57,
       dtcv.dtc58 AS attr58,
       dtcv.dtc59 AS attr59,
       dtcv.dtc60 AS attr60,
       dtcv.dtc61 AS attr61,
       dtcv.dtc62 AS attr62,
       dtcv.dtc63 AS attr63,
       dtcv.dtc64 AS attr64,
       dtcv.dtc65 AS attr65,
       dtcv.dtc66 AS attr66,
       dtcv.dtc67 AS attr67,
       dtcv.dtc68 AS attr68,
       dtcv.dtc69 AS attr69,
       dtcv.dtc70 AS attr70,
       dtcv.dtc71 AS attr71,
       dtcv.dtc72 AS attr72,
       dtcv.dtc73 AS attr73,
       dtcv.dtc74 AS attr74,
       dtcv.dtc75 AS attr75,
       dtcv.dtc76 AS attr76,
       dtcv.dtc77 AS attr77,
       dtcv.dtc78 AS attr78,
       dtcv.dtc79 AS attr79,
       dtcv.dtc80 AS attr80,
       dtcv.dtc81 AS attr81,
       dtcv.dtc82 AS attr82,
       dtcv.dtc83 AS attr83,
       dtcv.dtc84 AS attr84,
       dtcv.dtc85 AS attr85,
       dtcv.dtc86 AS attr86,
       dtcv.dtc87 AS attr87,
       dtcv.dtc88 AS attr88,
       dtcv.dtc89 AS attr89,
       dtcv.dtc90 AS attr90,
       dtcv.dtc91 AS attr91,
       dtcv.dtc92 AS attr92,
       dtcv.dtc93 AS attr93,
       dtcv.dtc94 AS attr94,
       dtcv.dtc95 AS attr95,
       dtcv.dtc96 AS attr96,
       dtcv.dtc97 AS attr97,
       dtcv.dtc98 AS attr98,
       dtcv.dtc99 AS attr99,
       dtcv.dtc100 AS attr100,
       dtcv.dtc101 AS attr101,
       dtcv.dtc102 AS attr102,
       dtcv.dtc103 AS attr103,
       dtcv.dtc104 AS attr104,
       dtcv.dtc105 AS attr105,
       dtcv.dtc106 AS attr106,
       dtcv.dtc107 AS attr107,
       dtcv.dtc108 AS attr108,
       dtcv.dtc109 AS attr109,
       dtcv.dtc110 AS attr110,
       dtcv.dtc111 AS attr111,
       dtcv.dtc112 AS attr112,
       dtcv.dtc113 AS attr113,
       dtcv.dtc114 AS attr114,
       dtcv.dtc115 AS attr115,
       dtcv.dtc116 AS attr116,
       dtcv.dtc117 AS attr117,
       dtcv.dtc118 AS attr118,
       dtcv.dtc119 AS attr119,
       dtcv.dtc120 AS attr120,
       dtcv.dtc121 AS attr121,
       dtcv.dtc122 AS attr122,
       dtcv.dtc123 AS attr123,
       dtcv.dtc124 AS attr124,
       dtcv.dtc125 AS attr125,
       dtcv.dtc126 AS attr126,
       dtcv.dtc127 AS attr127,
       dtcv.dtc128 AS attr128,
       dtcv.dtc129 AS attr129,
       dtcv.dtc130 AS attr130,
       dtcv.dtc131 AS attr131,
       dtcv.dtc132 AS attr132,
       dtcv.dtc133 AS attr133,
       dtcv.dtc134 AS attr134,
       dtcv.dtc135 AS attr135,
       dtcv.dtc136 AS attr136,
       dtcv.dtc137 AS attr137,
       dtcv.dtc138 AS attr138,
       dtcv.dtc139 AS attr139,
       dtcv.dtc140 AS attr140,
       dtcv.dtc141 AS attr141,
       dtcv.dtc142 AS attr142,
       dtcv.dtc143 AS attr143,
       dtcv.dtc144 AS attr144,
       dtcv.dtc145 AS attr145,
       dtcv.dtc146 AS attr146,
       dtcv.dtc147 AS attr147,
       dtcv.dtc148 AS attr148,
       dtcv.dtc149 AS attr149,
       dtcv.dtc150 AS attr150,
       dtcv.dtc151 AS attr151,
       dtcv.dtc152 AS attr152,
       dtcv.dtc153 AS attr153,
       dtcv.dtc154 AS attr154,
       dtcv.dtc155 AS attr155,
       dtcv.dtc156 AS attr156,
       dtcv.dtc157 AS attr157,
       dtcv.dtc158 AS attr158,
       dtcv.dtc159 AS attr159,
       dtcv.dtc160 AS attr160,
       dtcv.dtc161 AS attr161,
       dtcv.dtc162 AS attr162,
       dtcv.dtc163 AS attr163,
       dtcv.dtc164 AS attr164,
       dtcv.dtc165 AS attr165,
       dtcv.dtc166 AS attr166,
       dtcv.dtc167 AS attr167,
       dtcv.dtc168 AS attr168,
       dtcv.dtc169 AS attr169,
       dtcv.dtc170 AS attr170,
       dtcv.dtc171 AS attr171,
       dtcv.dtc172 AS attr172,
       dtcv.dtc173 AS attr173,
       dtcv.dtc174 AS attr174,
       dtcv.dtc175 AS attr175,
       dtcv.dtc176 AS attr176,
       dtcv.dtc177 AS attr177,
       dtcv.dtc178 AS attr178,
       dtcv.dtc179 AS attr179,
       dtcv.dtc180 AS attr180,
       dtcv.dtc181 AS attr181,
       dtcv.dtc182 AS attr182,
       dtcv.dtc183 AS attr183,
       dtcv.dtc184 AS attr184,
       dtcv.dtc185 AS attr185,
       dtcv.dtc186 AS attr186,
       dtcv.dtc187 AS attr187,
       dtcv.dtc188 AS attr188,
       dtcv.dtc189 AS attr189,
       dtcv.dtc190 AS attr190,
       dtcv.dtc191 AS attr191,
       dtcv.dtc192 AS attr192,
       dtcv.dtc193 AS attr193,
       dtcv.dtc194 AS attr194,
       dtcv.dtc195 AS attr195,
       dtcv.dtc196 AS attr196,
       dtcv.dtc197 AS attr197,
       dtcv.dtc198 AS attr198,
       dtcv.dtc199 AS attr199,
       dtcv.dtc200 AS attr200
  FROM erpapp.cm_ba_data_table_columns_pivot_v dtcv
 WHERE 1 = 1 AND dtcv.data_table_id = '147'
ORDER BY dtcv.data_table_id, dtcv.data_type;
