VIEW: APPS.DOM_DOC_REV_VERSIONS_EXT_VL

Source

View Text - Preformatted

SELECT B.DOCUMENT_ID,B.REVISION_ID,B.VERSION_ID,B.EXTENSION_ID,B.ATTR_GROUP_ID,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.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.C_EXT_ATTR31,B.C_EXT_ATTR32,B.C_EXT_ATTR33,B.C_EXT_ATTR34,B.C_EXT_ATTR35,B.C_EXT_ATTR36,B.C_EXT_ATTR37,B.C_EXT_ATTR38,B.C_EXT_ATTR39,B.C_EXT_ATTR40,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.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_ATTR1,B.D_EXT_ATTR2,B.D_EXT_ATTR3,B.D_EXT_ATTR4,B.D_EXT_ATTR5,B.D_EXT_ATTR6,B.D_EXT_ATTR7,B.D_EXT_ATTR8,B.D_EXT_ATTR9,B.D_EXT_ATTR10,B.UOM_EXT_ATTR1,B.UOM_EXT_ATTR2,B.UOM_EXT_ATTR3,B.UOM_EXT_ATTR4,B.UOM_EXT_ATTR5,B.UOM_EXT_ATTR6,B.UOM_EXT_ATTR7,B.UOM_EXT_ATTR8,B.UOM_EXT_ATTR9,B.UOM_EXT_ATTR10,B.UOM_EXT_ATTR11,B.UOM_EXT_ATTR12,B.UOM_EXT_ATTR13,B.UOM_EXT_ATTR14,B.UOM_EXT_ATTR15,B.UOM_EXT_ATTR16,B.UOM_EXT_ATTR17,B.UOM_EXT_ATTR18,B.UOM_EXT_ATTR19,B.UOM_EXT_ATTR20,T.TL_EXT_ATTR1,T.TL_EXT_ATTR2,T.TL_EXT_ATTR3,T.TL_EXT_ATTR4,T.TL_EXT_ATTR5,T.TL_EXT_ATTR6,T.TL_EXT_ATTR7,T.TL_EXT_ATTR8,T.TL_EXT_ATTR9,T.TL_EXT_ATTR10,T.TL_EXT_ATTR11,T.TL_EXT_ATTR12,T.TL_EXT_ATTR13,T.TL_EXT_ATTR14,T.TL_EXT_ATTR15,T.TL_EXT_ATTR16,T.TL_EXT_ATTR17,T.TL_EXT_ATTR18,T.TL_EXT_ATTR19,T.TL_EXT_ATTR20,T.TL_EXT_ATTR21,T.TL_EXT_ATTR22,T.TL_EXT_ATTR23,T.TL_EXT_ATTR24,T.TL_EXT_ATTR25,T.TL_EXT_ATTR26,T.TL_EXT_ATTR27,T.TL_EXT_ATTR28,T.TL_EXT_ATTR29,T.TL_EXT_ATTR30,T.TL_EXT_ATTR31,T.TL_EXT_ATTR32,T.TL_EXT_ATTR33,T.TL_EXT_ATTR34,T.TL_EXT_ATTR35,T.TL_EXT_ATTR36,T.TL_EXT_ATTR37,T.TL_EXT_ATTR38,T.TL_EXT_ATTR39,T.TL_EXT_ATTR40,B.CREATED_BY,B.CREATION_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,T.LANGUAGE,T.SOURCE_LANG,B.CATEGORY_ID FROM DOM_DOC_REV_VERSIONS_EXT_B B,DOM_DOC_REV_VERSIONS_EXT_TL T WHERE b.DOCUMENT_ID = t.DOCUMENT_ID AND b.REVISION_ID = t.REVISION_ID AND b.VERSION_ID = t.VERSION_ID AND b.EXTENSION_ID = t.EXTENSION_ID AND b.ATTR_GROUP_ID = t.ATTR_GROUP_ID AND t.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.DOCUMENT_ID
, B.REVISION_ID
, B.VERSION_ID
, B.EXTENSION_ID
, B.ATTR_GROUP_ID
, 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.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.C_EXT_ATTR31
, B.C_EXT_ATTR32
, B.C_EXT_ATTR33
, B.C_EXT_ATTR34
, B.C_EXT_ATTR35
, B.C_EXT_ATTR36
, B.C_EXT_ATTR37
, B.C_EXT_ATTR38
, B.C_EXT_ATTR39
, B.C_EXT_ATTR40
, 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.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_ATTR1
, B.D_EXT_ATTR2
, B.D_EXT_ATTR3
, B.D_EXT_ATTR4
, B.D_EXT_ATTR5
, B.D_EXT_ATTR6
, B.D_EXT_ATTR7
, B.D_EXT_ATTR8
, B.D_EXT_ATTR9
, B.D_EXT_ATTR10
, B.UOM_EXT_ATTR1
, B.UOM_EXT_ATTR2
, B.UOM_EXT_ATTR3
, B.UOM_EXT_ATTR4
, B.UOM_EXT_ATTR5
, B.UOM_EXT_ATTR6
, B.UOM_EXT_ATTR7
, B.UOM_EXT_ATTR8
, B.UOM_EXT_ATTR9
, B.UOM_EXT_ATTR10
, B.UOM_EXT_ATTR11
, B.UOM_EXT_ATTR12
, B.UOM_EXT_ATTR13
, B.UOM_EXT_ATTR14
, B.UOM_EXT_ATTR15
, B.UOM_EXT_ATTR16
, B.UOM_EXT_ATTR17
, B.UOM_EXT_ATTR18
, B.UOM_EXT_ATTR19
, B.UOM_EXT_ATTR20
, T.TL_EXT_ATTR1
, T.TL_EXT_ATTR2
, T.TL_EXT_ATTR3
, T.TL_EXT_ATTR4
, T.TL_EXT_ATTR5
, T.TL_EXT_ATTR6
, T.TL_EXT_ATTR7
, T.TL_EXT_ATTR8
, T.TL_EXT_ATTR9
, T.TL_EXT_ATTR10
, T.TL_EXT_ATTR11
, T.TL_EXT_ATTR12
, T.TL_EXT_ATTR13
, T.TL_EXT_ATTR14
, T.TL_EXT_ATTR15
, T.TL_EXT_ATTR16
, T.TL_EXT_ATTR17
, T.TL_EXT_ATTR18
, T.TL_EXT_ATTR19
, T.TL_EXT_ATTR20
, T.TL_EXT_ATTR21
, T.TL_EXT_ATTR22
, T.TL_EXT_ATTR23
, T.TL_EXT_ATTR24
, T.TL_EXT_ATTR25
, T.TL_EXT_ATTR26
, T.TL_EXT_ATTR27
, T.TL_EXT_ATTR28
, T.TL_EXT_ATTR29
, T.TL_EXT_ATTR30
, T.TL_EXT_ATTR31
, T.TL_EXT_ATTR32
, T.TL_EXT_ATTR33
, T.TL_EXT_ATTR34
, T.TL_EXT_ATTR35
, T.TL_EXT_ATTR36
, T.TL_EXT_ATTR37
, T.TL_EXT_ATTR38
, T.TL_EXT_ATTR39
, T.TL_EXT_ATTR40
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.LANGUAGE
, T.SOURCE_LANG
, B.CATEGORY_ID
FROM DOM_DOC_REV_VERSIONS_EXT_B B
, DOM_DOC_REV_VERSIONS_EXT_TL T
WHERE B.DOCUMENT_ID = T.DOCUMENT_ID
AND B.REVISION_ID = T.REVISION_ID
AND B.VERSION_ID = T.VERSION_ID
AND B.EXTENSION_ID = T.EXTENSION_ID
AND B.ATTR_GROUP_ID = T.ATTR_GROUP_ID
AND T.LANGUAGE = USERENV('LANG')