VIEW: APPS.AMW_PROCESS_EXT_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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