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.SO_LINE_ATTRIBUTES1_DFV

Source

View Text - Preformatted


SELECT ROWID, GLOBAL_ATTRIBUTE_CATEGORY, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.OEXORRSO.Lines', GLOBAL_ATTRIBUTE5, 'JL.CO.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE5, 'JL.CO.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE5, 'JL.BR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE5, 'JL.BR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE5, 'JL.BR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE5, 'JL.AR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE5, 'JL.AR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE5, 'JL.AR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE5, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.OEXORRSO.Lines', GLOBAL_ATTRIBUTE6, 'JL.CO.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE6, 'JL.CO.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE6, 'JL.BR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE6, 'JL.BR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE6, 'JL.BR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE6, 'JL.AR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE6, 'JL.AR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE6, 'JL.AR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE6, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.OEXORRSO.Lines', GLOBAL_ATTRIBUTE7, 'JL.CO.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE7, 'JL.CO.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE7, 'JL.BR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE7, 'JL.BR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE7, 'JL.BR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE7, 'JL.AR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE7, 'JL.AR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE7, 'JL.AR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE7, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.OEXORRSO.Lines', GLOBAL_ATTRIBUTE8, 'JL.CO.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE8, 'JL.CO.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE8, 'JL.BR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE8, 'JL.BR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE8, 'JL.BR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE8, 'JL.AR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE8, 'JL.AR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE8, 'JL.AR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE8, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE1, 'JL.BR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE1, 'JL.BR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE1, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.OEXOEMOE.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.OEXORRSO.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3), 'JL.BR.OEXOEVOR.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3), 'JL.BR.OEXOEMOE.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.OEXORRSO.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4), 'JL.BR.OEXOEVOR.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4), 'JL.BR.OEXOEMOE.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.OEXORRSO.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2), 'JL.BR.OEXOEVOR.Lines', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2), NULL)),  
 (DECODE (GLOBAL_ATTRIBUTE_CATEGORY,  
      'JL.AR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.AR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.AR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.BR.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.BR.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.BR.OEXORRSO.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.CO.OEXOEMOE.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.CO.OEXOEVOR.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.CO.OEXORRSO.Lines', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8, NULL)) 
 FROM SO_LINE_ATTRIBUTES

View Text - HTML Formatted

SELECT ROWID
, GLOBAL_ATTRIBUTE_CATEGORY
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.CO.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.CO.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.BR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.BR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.BR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.AR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.AR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE5
, 'JL.AR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE5
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.CO.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.CO.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.BR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.BR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.BR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.AR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.AR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE6
, 'JL.AR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE6
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.CO.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.CO.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.BR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.BR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.BR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.AR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.AR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE7
, 'JL.AR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE7
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.CO.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.CO.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.BR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.BR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.BR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.AR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.AR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE8
, 'JL.AR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE8
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE1
, 'JL.BR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE1
, 'JL.BR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE1
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.OEXOEMOE.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.OEXORRSO.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3)
, 'JL.BR.OEXOEVOR.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3)
, 'JL.BR.OEXOEMOE.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.OEXORRSO.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4)
, 'JL.BR.OEXOEVOR.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4)
, 'JL.BR.OEXOEMOE.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.OEXORRSO.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2)
, 'JL.BR.OEXOEVOR.LINES'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.AR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.AR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.AR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.BR.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.BR.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.BR.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.CO.OEXOEMOE.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.CO.OEXOEVOR.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.CO.OEXORRSO.LINES'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, NULL))
FROM SO_LINE_ATTRIBUTES