eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OE_ORDER_LINES_ALL_EXT_VL

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')