VIEW: APPS.FND_PRINTER_DRIVERS_DFV

Source

View Text - Preformatted

SELECT ROWID, ATTR_CATEGORY, (DECODE (ATTR_CATEGORY, 'PORTRAITSUB9', ATTRIBUTE1, 'PORTRAITSUB17', ATTRIBUTE1, 'LANDWIDESUB9', ATTRIBUTE1, 'LANDWIDESUB17', ATTRIBUTE1, 'LANDSCAPESUB9', ATTRIBUTE1, 'LANDSCAPESUB17', ATTRIBUTE1, 'A4SUB9', ATTRIBUTE1, 'A4SUB17', ATTRIBUTE1, NULL)), (DECODE (ATTR_CATEGORY, 'PORTRAITSUB17', FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2), 'LANDWIDESUB17', FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2), 'LANDSCAPESUB17', FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2), 'A4SUB17', FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2), NULL)), (DECODE (ATTR_CATEGORY, 'PORTRAITSUB17', ATTRIBUTE3, 'LANDWIDESUB17', ATTRIBUTE3, 'LANDSCAPESUB17', ATTRIBUTE3, 'A4SUB17', ATTRIBUTE3, NULL)), (DECODE (ATTR_CATEGORY, 'PORTRAITSUB9', HEADER_FLAG, 'LANDWIDESUB9', HEADER_FLAG, 'LANDSCAPESUB9', HEADER_FLAG, 'A4SUB9', HEADER_FLAG, NULL)),  
 (DECODE (ATTR_CATEGORY,  
      'A4SUB17', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3,  
      'A4SUB9', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG,  
      'LANDSCAPESUB17', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3,  
      'LANDSCAPESUB9', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG,  
      'LANDWIDESUB17', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3,  
      'LANDWIDESUB9', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG,  
      'PORTRAITSUB17', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3,  
      'PORTRAITSUB9', ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG, NULL)) 
 FROM FND_PRINTER_DRIVERS

View Text - HTML Formatted

SELECT ROWID
, ATTR_CATEGORY
, (DECODE (ATTR_CATEGORY
, 'PORTRAITSUB9'
, ATTRIBUTE1
, 'PORTRAITSUB17'
, ATTRIBUTE1
, 'LANDWIDESUB9'
, ATTRIBUTE1
, 'LANDWIDESUB17'
, ATTRIBUTE1
, 'LANDSCAPESUB9'
, ATTRIBUTE1
, 'LANDSCAPESUB17'
, ATTRIBUTE1
, 'A4SUB9'
, ATTRIBUTE1
, 'A4SUB17'
, ATTRIBUTE1
, NULL))
, (DECODE (ATTR_CATEGORY
, 'PORTRAITSUB17'
, FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2)
, 'LANDWIDESUB17'
, FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2)
, 'LANDSCAPESUB17'
, FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2)
, 'A4SUB17'
, FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE2)
, NULL))
, (DECODE (ATTR_CATEGORY
, 'PORTRAITSUB17'
, ATTRIBUTE3
, 'LANDWIDESUB17'
, ATTRIBUTE3
, 'LANDSCAPESUB17'
, ATTRIBUTE3
, 'A4SUB17'
, ATTRIBUTE3
, NULL))
, (DECODE (ATTR_CATEGORY
, 'PORTRAITSUB9'
, HEADER_FLAG
, 'LANDWIDESUB9'
, HEADER_FLAG
, 'LANDSCAPESUB9'
, HEADER_FLAG
, 'A4SUB9'
, HEADER_FLAG
, NULL))
, (DECODE (ATTR_CATEGORY
, 'A4SUB17'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3
, 'A4SUB9'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG
, 'LANDSCAPESUB17'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3
, 'LANDSCAPESUB9'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG
, 'LANDWIDESUB17'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3
, 'LANDWIDESUB9'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG
, 'PORTRAITSUB17'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || ATTRIBUTE2 || '.' || ATTRIBUTE3
, 'PORTRAITSUB9'
, ATTR_CATEGORY || '.' || ATTRIBUTE1 || '.' || HEADER_FLAG
, NULL))
FROM FND_PRINTER_DRIVERS