SELECT
B.EXTENSION_ID AS EXTENSION_ID ,
B.LINE_ID AS LINE_ID ,
B.TYPE_LOOKUP_CODE AS TYPE_LOOKUP_CODE ,
B.STYLE_ID AS STYLE_ID ,
B.ATTR_GROUP_ID AS ATTR_GROUP_ID ,
B.DATA_LEVEL_ID AS DATA_LEVEL_ID ,
B.ENTITY AS ENTITY ,
B.REQUEST_ID AS REQUEST_ID ,
B.PK1_VALUE AS PK1_VALUE ,
B.PK2_VALUE AS PK2_VALUE ,
B.PK3_VALUE AS PK3_VALUE ,
B.PK4_VALUE AS PK4_VALUE ,
B.PK5_VALUE AS PK5_VALUE ,
B.CREATED_BY AS CREATED_BY ,
B.CREATION_DATE AS CREATION_DATE ,
B.LAST_UPDATED_BY AS LAST_UPDATED_BY ,
B.LAST_UPDATE_DATE AS LAST_UPDATE_DATE ,
B.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN ,
TL.SOURCE_LANG AS SOURCE_LANG ,
TL.LANGUAGE AS LANGUAGE ,
B.C_EXT_ATTR1 AS C_EXT_ATTR1 ,
B.C_EXT_ATTR2 AS C_EXT_ATTR2 ,
B.C_EXT_ATTR3 AS C_EXT_ATTR3 ,
B.C_EXT_ATTR4 AS C_EXT_ATTR4 ,
B.C_EXT_ATTR5 AS C_EXT_ATTR5 ,
B.C_EXT_ATTR6 AS C_EXT_ATTR6 ,
B.C_EXT_ATTR7 AS C_EXT_ATTR7 ,
B.C_EXT_ATTR8 AS C_EXT_ATTR8 ,
B.C_EXT_ATTR9 AS C_EXT_ATTR9 ,
B.C_EXT_ATTR10 AS C_EXT_ATTR10 ,
B.C_EXT_ATTR11 AS C_EXT_ATTR11 ,
B.C_EXT_ATTR12 AS C_EXT_ATTR12 ,
B.C_EXT_ATTR13 AS C_EXT_ATTR13 ,
B.C_EXT_ATTR14 AS C_EXT_ATTR14 ,
B.C_EXT_ATTR15 AS C_EXT_ATTR15 ,
B.C_EXT_ATTR16 AS C_EXT_ATTR16 ,
B.C_EXT_ATTR17 AS C_EXT_ATTR17 ,
B.C_EXT_ATTR18 AS C_EXT_ATTR18 ,
B.C_EXT_ATTR19 AS C_EXT_ATTR19 ,
B.C_EXT_ATTR20 AS C_EXT_ATTR20 ,
B.C_EXT_ATTR21 AS C_EXT_ATTR21 ,
B.C_EXT_ATTR22 AS C_EXT_ATTR22 ,
B.C_EXT_ATTR23 AS C_EXT_ATTR23 ,
B.C_EXT_ATTR24 AS C_EXT_ATTR24 ,
B.C_EXT_ATTR25 AS C_EXT_ATTR25 ,
B.C_EXT_ATTR26 AS C_EXT_ATTR26 ,
B.C_EXT_ATTR27 AS C_EXT_ATTR27 ,
B.C_EXT_ATTR28 AS C_EXT_ATTR28 ,
B.C_EXT_ATTR29 AS C_EXT_ATTR29 ,
B.C_EXT_ATTR30 AS C_EXT_ATTR30 ,
B.C_EXT_ATTR31 AS C_EXT_ATTR31 ,
B.C_EXT_ATTR32 AS C_EXT_ATTR32 ,
B.C_EXT_ATTR33 AS C_EXT_ATTR33 ,
B.C_EXT_ATTR34 AS C_EXT_ATTR34 ,
B.C_EXT_ATTR35 AS C_EXT_ATTR35 ,
B.C_EXT_ATTR36 AS C_EXT_ATTR36 ,
B.C_EXT_ATTR37 AS C_EXT_ATTR37 ,
B.C_EXT_ATTR38 AS C_EXT_ATTR38 ,
B.C_EXT_ATTR39 AS C_EXT_ATTR39 ,
B.C_EXT_ATTR40 AS C_EXT_ATTR40 ,
B.N_EXT_ATTR1 AS N_EXT_ATTR1 ,
B.UOM_EXT_ATTR1 AS UOM_EXT_ATTR1 ,
B.N_EXT_ATTR2 AS N_EXT_ATTR2 ,
B.UOM_EXT_ATTR2 AS UOM_EXT_ATTR2 ,
B.N_EXT_ATTR3 AS N_EXT_ATTR3 ,
B.UOM_EXT_ATTR3 AS UOM_EXT_ATTR3 ,
B.N_EXT_ATTR4 AS N_EXT_ATTR4 ,
B.UOM_EXT_ATTR4 AS UOM_EXT_ATTR4 ,
B.N_EXT_ATTR5 AS N_EXT_ATTR5 ,
B.UOM_EXT_ATTR5 AS UOM_EXT_ATTR5 ,
B.N_EXT_ATTR6 AS N_EXT_ATTR6 ,
B.UOM_EXT_ATTR6 AS UOM_EXT_ATTR6 ,
B.N_EXT_ATTR7 AS N_EXT_ATTR7 ,
B.UOM_EXT_ATTR7 AS UOM_EXT_ATTR7 ,
B.N_EXT_ATTR8 AS N_EXT_ATTR8 ,
B.UOM_EXT_ATTR8 AS UOM_EXT_ATTR8 ,
B.N_EXT_ATTR9 AS N_EXT_ATTR9 ,
B.UOM_EXT_ATTR9 AS UOM_EXT_ATTR9 ,
B.N_EXT_ATTR10 AS N_EXT_ATTR10 ,
B.UOM_EXT_ATTR10 AS UOM_EXT_ATTR10 ,
B.N_EXT_ATTR11 AS N_EXT_ATTR11 ,
B.UOM_EXT_ATTR11 AS UOM_EXT_ATTR11 ,
B.N_EXT_ATTR12 AS N_EXT_ATTR12 ,
B.UOM_EXT_ATTR12 AS UOM_EXT_ATTR12 ,
B.N_EXT_ATTR13 AS N_EXT_ATTR13 ,
B.UOM_EXT_ATTR13 AS UOM_EXT_ATTR13 ,
B.N_EXT_ATTR14 AS N_EXT_ATTR14 ,
B.UOM_EXT_ATTR14 AS UOM_EXT_ATTR14 ,
B.N_EXT_ATTR15 AS N_EXT_ATTR15 ,
B.UOM_EXT_ATTR15 AS UOM_EXT_ATTR15 ,
B.N_EXT_ATTR16 AS N_EXT_ATTR16 ,
B.UOM_EXT_ATTR16 AS UOM_EXT_ATTR16 ,
B.N_EXT_ATTR17 AS N_EXT_ATTR17 ,
B.UOM_EXT_ATTR17 AS UOM_EXT_ATTR17 ,
B.N_EXT_ATTR18 AS N_EXT_ATTR18 ,
B.UOM_EXT_ATTR18 AS UOM_EXT_ATTR18 ,
B.N_EXT_ATTR19 AS N_EXT_ATTR19 ,
B.UOM_EXT_ATTR19 AS UOM_EXT_ATTR19 ,
B.N_EXT_ATTR20 AS N_EXT_ATTR20 ,
B.UOM_EXT_ATTR20 AS UOM_EXT_ATTR20 ,
B.D_EXT_ATTR1 AS D_EXT_ATTR1 ,
B.D_EXT_ATTR2 AS D_EXT_ATTR2 ,
B.D_EXT_ATTR3 AS D_EXT_ATTR3 ,
B.D_EXT_ATTR4 AS D_EXT_ATTR4 ,
B.D_EXT_ATTR5 AS D_EXT_ATTR5 ,
B.D_EXT_ATTR6 AS D_EXT_ATTR6 ,
B.D_EXT_ATTR7 AS D_EXT_ATTR7 ,
B.D_EXT_ATTR8 AS D_EXT_ATTR8 ,
B.D_EXT_ATTR9 AS D_EXT_ATTR9 ,
B.D_EXT_ATTR10 AS D_EXT_ATTR10 ,
TL.TL_EXT_ATTR1 AS TL_EXT_ATTR1 ,
TL.TL_EXT_ATTR2 AS TL_EXT_ATTR2 ,
TL.TL_EXT_ATTR3 AS TL_EXT_ATTR3 ,
TL.TL_EXT_ATTR4 AS TL_EXT_ATTR4 ,
TL.TL_EXT_ATTR5 AS TL_EXT_ATTR5 ,
TL.TL_EXT_ATTR6 AS TL_EXT_ATTR6 ,
TL.TL_EXT_ATTR7 AS TL_EXT_ATTR7 ,
TL.TL_EXT_ATTR8 AS TL_EXT_ATTR8 ,
TL.TL_EXT_ATTR9 AS TL_EXT_ATTR9 ,
TL.TL_EXT_ATTR10 AS TL_EXT_ATTR10 ,
TL.TL_EXT_ATTR11 AS TL_EXT_ATTR11 ,
TL.TL_EXT_ATTR12 AS TL_EXT_ATTR12 ,
TL.TL_EXT_ATTR13 AS TL_EXT_ATTR13 ,
TL.TL_EXT_ATTR14 AS TL_EXT_ATTR14 ,
TL.TL_EXT_ATTR15 AS TL_EXT_ATTR15 ,
TL.TL_EXT_ATTR16 AS TL_EXT_ATTR16 ,
TL.TL_EXT_ATTR17 AS TL_EXT_ATTR17 ,
TL.TL_EXT_ATTR18 AS TL_EXT_ATTR18 ,
TL.TL_EXT_ATTR19 AS TL_EXT_ATTR19 ,
TL.TL_EXT_ATTR20 AS TL_EXT_ATTR20 ,
TL.TL_EXT_ATTR21 AS TL_EXT_ATTR21 ,
TL.TL_EXT_ATTR22 AS TL_EXT_ATTR22 ,
TL.TL_EXT_ATTR23 AS TL_EXT_ATTR23 ,
TL.TL_EXT_ATTR24 AS TL_EXT_ATTR24 ,
TL.TL_EXT_ATTR25 AS TL_EXT_ATTR25 ,
TL.TL_EXT_ATTR26 AS TL_EXT_ATTR26 ,
TL.TL_EXT_ATTR27 AS TL_EXT_ATTR27 ,
TL.TL_EXT_ATTR28 AS TL_EXT_ATTR28 ,
TL.TL_EXT_ATTR29 AS TL_EXT_ATTR29 ,
TL.TL_EXT_ATTR30 AS TL_EXT_ATTR30 ,
TL.TL_EXT_ATTR31 AS TL_EXT_ATTR31 ,
TL.TL_EXT_ATTR32 AS TL_EXT_ATTR32 ,
TL.TL_EXT_ATTR33 AS TL_EXT_ATTR33 ,
TL.TL_EXT_ATTR34 AS TL_EXT_ATTR34 ,
TL.TL_EXT_ATTR35 AS TL_EXT_ATTR35 ,
TL.TL_EXT_ATTR36 AS TL_EXT_ATTR36 ,
TL.TL_EXT_ATTR37 AS TL_EXT_ATTR37 ,
TL.TL_EXT_ATTR38 AS TL_EXT_ATTR38 ,
TL.TL_EXT_ATTR39 AS TL_EXT_ATTR39 ,
TL.TL_EXT_ATTR40 AS TL_EXT_ATTR40
FROM OE_ORDER_LINES_ALL_EXT_B B ,
OE_ORDER_LINES_ALL_EXT_TL TL WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')