VIEW: APPS.MTH_OTHERS_EXT_VL

Source

View Text - Preformatted

SELECT B.EXTENSION_ID,B.OTHER_PK_KEY,B.ATTR_GROUP_ID,B.CREATED_BY,B.CREATION_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,TL.SOURCE_LANG,TL.LANGUAGE,B.C_EXT_ATTR1,B.C_EXT_ATTR2,B.C_EXT_ATTR3,B.C_EXT_ATTR4,B.C_EXT_ATTR5,B.C_EXT_ATTR6,B.C_EXT_ATTR7,B.C_EXT_ATTR8,B.C_EXT_ATTR9,B.C_EXT_ATTR10,B.C_EXT_ATTR11,B.C_EXT_ATTR12,B.C_EXT_ATTR13,B.C_EXT_ATTR14,B.C_EXT_ATTR15,B.C_EXT_ATTR16,B.C_EXT_ATTR17,B.C_EXT_ATTR18,B.C_EXT_ATTR19,B.C_EXT_ATTR20,B.N_EXT_ATTR1,B.N_EXT_ATTR2,B.N_EXT_ATTR3,B.N_EXT_ATTR4,B.N_EXT_ATTR5,B.N_EXT_ATTR6,B.N_EXT_ATTR7,B.N_EXT_ATTR8,B.N_EXT_ATTR9,B.N_EXT_ATTR10,B.D_EXT_ATTR1,B.D_EXT_ATTR2,B.D_EXT_ATTR3,B.D_EXT_ATTR4,B.D_EXT_ATTR5,B.C_EXT_ATTR21,B.C_EXT_ATTR22,B.C_EXT_ATTR23,B.C_EXT_ATTR24,B.C_EXT_ATTR25,B.C_EXT_ATTR26,B.C_EXT_ATTR27,B.C_EXT_ATTR28,B.C_EXT_ATTR29,B.C_EXT_ATTR30,B.N_EXT_ATTR11,B.N_EXT_ATTR12,B.N_EXT_ATTR13,B.N_EXT_ATTR14,B.N_EXT_ATTR15,B.N_EXT_ATTR16,B.N_EXT_ATTR17,B.N_EXT_ATTR18,B.N_EXT_ATTR19,B.N_EXT_ATTR20,B.D_EXT_ATTR6,B.D_EXT_ATTR7,B.D_EXT_ATTR8,B.D_EXT_ATTR9,B.D_EXT_ATTR10,B.D_EXT_ATTR11,B.D_EXT_ATTR13,B.D_EXT_ATTR14,B.D_EXT_ATTR15,B.D_EXT_ATTR12,B.D_EXT_ATTR16,B.D_EXT_ATTR17,B.D_EXT_ATTR18,B.D_EXT_ATTR19,B.D_EXT_ATTR20,TL.TL_EXT_ATTR1,TL.TL_EXT_ATTR2,TL.TL_EXT_ATTR3,TL.TL_EXT_ATTR4,TL.TL_EXT_ATTR5,TL.TL_EXT_ATTR6,TL.TL_EXT_ATTR7,TL.TL_EXT_ATTR8,TL.TL_EXT_ATTR9,TL.TL_EXT_ATTR10,TL.TL_EXT_ATTR11,TL.TL_EXT_ATTR12,TL.TL_EXT_ATTR13,TL.TL_EXT_ATTR14,TL.TL_EXT_ATTR15,TL.TL_EXT_ATTR16,TL.TL_EXT_ATTR17,TL.TL_EXT_ATTR18,TL.TL_EXT_ATTR19,TL.TL_EXT_ATTR20,TL.TL_EXT_ATTR21,TL.TL_EXT_ATTR22,TL.TL_EXT_ATTR23,TL.TL_EXT_ATTR24,TL.TL_EXT_ATTR25,TL.TL_EXT_ATTR26,TL.TL_EXT_ATTR27,TL.TL_EXT_ATTR28,TL.TL_EXT_ATTR29,TL.TL_EXT_ATTR30 FROM MTH_OTHERS_EXT_B B,MTH_OTHERS_EXT_TL TL WHERE B.EXTENSION_ID = TL.EXTENSION_ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.EXTENSION_ID
, B.OTHER_PK_KEY
, B.ATTR_GROUP_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, TL.SOURCE_LANG
, TL.LANGUAGE
, B.C_EXT_ATTR1
, B.C_EXT_ATTR2
, B.C_EXT_ATTR3
, B.C_EXT_ATTR4
, B.C_EXT_ATTR5
, B.C_EXT_ATTR6
, B.C_EXT_ATTR7
, B.C_EXT_ATTR8
, B.C_EXT_ATTR9
, B.C_EXT_ATTR10
, B.C_EXT_ATTR11
, B.C_EXT_ATTR12
, B.C_EXT_ATTR13
, B.C_EXT_ATTR14
, B.C_EXT_ATTR15
, B.C_EXT_ATTR16
, B.C_EXT_ATTR17
, B.C_EXT_ATTR18
, B.C_EXT_ATTR19
, B.C_EXT_ATTR20
, B.N_EXT_ATTR1
, B.N_EXT_ATTR2
, B.N_EXT_ATTR3
, B.N_EXT_ATTR4
, B.N_EXT_ATTR5
, B.N_EXT_ATTR6
, B.N_EXT_ATTR7
, B.N_EXT_ATTR8
, B.N_EXT_ATTR9
, B.N_EXT_ATTR10
, B.D_EXT_ATTR1
, B.D_EXT_ATTR2
, B.D_EXT_ATTR3
, B.D_EXT_ATTR4
, B.D_EXT_ATTR5
, B.C_EXT_ATTR21
, B.C_EXT_ATTR22
, B.C_EXT_ATTR23
, B.C_EXT_ATTR24
, B.C_EXT_ATTR25
, B.C_EXT_ATTR26
, B.C_EXT_ATTR27
, B.C_EXT_ATTR28
, B.C_EXT_ATTR29
, B.C_EXT_ATTR30
, B.N_EXT_ATTR11
, B.N_EXT_ATTR12
, B.N_EXT_ATTR13
, B.N_EXT_ATTR14
, B.N_EXT_ATTR15
, B.N_EXT_ATTR16
, B.N_EXT_ATTR17
, B.N_EXT_ATTR18
, B.N_EXT_ATTR19
, B.N_EXT_ATTR20
, B.D_EXT_ATTR6
, B.D_EXT_ATTR7
, B.D_EXT_ATTR8
, B.D_EXT_ATTR9
, B.D_EXT_ATTR10
, B.D_EXT_ATTR11
, B.D_EXT_ATTR13
, B.D_EXT_ATTR14
, B.D_EXT_ATTR15
, B.D_EXT_ATTR12
, B.D_EXT_ATTR16
, B.D_EXT_ATTR17
, B.D_EXT_ATTR18
, B.D_EXT_ATTR19
, B.D_EXT_ATTR20
, TL.TL_EXT_ATTR1
, TL.TL_EXT_ATTR2
, TL.TL_EXT_ATTR3
, TL.TL_EXT_ATTR4
, TL.TL_EXT_ATTR5
, TL.TL_EXT_ATTR6
, TL.TL_EXT_ATTR7
, TL.TL_EXT_ATTR8
, TL.TL_EXT_ATTR9
, TL.TL_EXT_ATTR10
, TL.TL_EXT_ATTR11
, TL.TL_EXT_ATTR12
, TL.TL_EXT_ATTR13
, TL.TL_EXT_ATTR14
, TL.TL_EXT_ATTR15
, TL.TL_EXT_ATTR16
, TL.TL_EXT_ATTR17
, TL.TL_EXT_ATTR18
, TL.TL_EXT_ATTR19
, TL.TL_EXT_ATTR20
, TL.TL_EXT_ATTR21
, TL.TL_EXT_ATTR22
, TL.TL_EXT_ATTR23
, TL.TL_EXT_ATTR24
, TL.TL_EXT_ATTR25
, TL.TL_EXT_ATTR26
, TL.TL_EXT_ATTR27
, TL.TL_EXT_ATTR28
, TL.TL_EXT_ATTR29
, TL.TL_EXT_ATTR30
FROM MTH_OTHERS_EXT_B B
, MTH_OTHERS_EXT_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')