VIEW: APPS.MTL_CATEGORIES_B_KFV

Source

View Text - Preformatted

SELECT ROWID, CATEGORY_ID, STRUCTURE_ID,  
 (DECODE(STRUCTURE_ID,  
      3, SEGMENT1,  
      4, SEGMENT1,  
      5, SEGMENT1,  
      6, SEGMENT1,  
      201, SEGMENT1,  
      50136, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3,  
      50152, SEGMENT1,  
      50153, SEGMENT1,  
      50168, SEGMENT1 || '.' || SEGMENT2,  
      50169, SEGMENT1,  
      50190, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4,  
      50208, SEGMENT1,  
      50229, SEGMENT1,  
      50268, SEGMENT1,  
      50272, SEGMENT1,  
      50308, SEGMENT1 || '.' || SEGMENT2, NULL)),  
 (DECODE(STRUCTURE_ID,  
      3, RPAD(NVL(SEGMENT1, ' '), 30),  
      4, RPAD(NVL(SEGMENT1, ' '), 30),  
      5, RPAD(NVL(SEGMENT1, ' '), 30),  
      6, RPAD(NVL(SEGMENT1, ' '), 30),  
      201, RPAD(NVL(SEGMENT1, ' '), 40),  
      50136, LPAD(NVL(SEGMENT1, ' '), 22) || '.' || LPAD(NVL(SEGMENT2, ' '), 22) || '.' || LPAD(NVL(SEGMENT3, ' '), 22),  
      50152, RPAD(NVL(SEGMENT1, ' '), 40),  
      50153, RPAD(NVL(SEGMENT1, ' '), 40),  
      50168, RPAD(NVL(SEGMENT1, ' '), 40) || '.' || RPAD(NVL(SEGMENT2, ' '), 40),  
      50169, RPAD(NVL(SEGMENT1, ' '), 30),  
      50190, RPAD(NVL(SEGMENT1, ' '), 30) || '.' || RPAD(NVL(SEGMENT2, ' '), 40) || '.' || RPAD(NVL(SEGMENT3, ' '), 40) || '.' || RPAD(NVL(SEGMENT4, ' '), 1),  
      50208, RPAD(NVL(SEGMENT1, ' '), 40),  
      50229, RPAD(NVL(SEGMENT1, ' '), 40),  
      50268, LPAD(NVL(SEGMENT1, ' '), 4),  
      50272, RPAD(NVL(SEGMENT1, ' '), 40),  
      50308, RPAD(NVL(SEGMENT1, ' '), 40) || '.' || RPAD(NVL(SEGMENT2, ' '), 40), NULL)),  
 ATTRIBUTE13, ATTRIBUTE12, ATTRIBUTE14, PROGRAM_ID, SEGMENT5, SEGMENT19, ENABLED_FLAG, SEGMENT8, LAST_UPDATE_DATE, CREATION_DATE, ATTRIBUTE4, PROGRAM_APPLICATION_ID, END_DATE_ACTIVE, SEGMENT2, SEGMENT12, REQUEST_ID, ATTRIBUTE2, WEB_STATUS, SEGMENT17, SEGMENT7, SEGMENT14, ATTRIBUTE5, LAST_UPDATED_BY, ATTRIBUTE1, LAST_UPDATE_LOGIN, SEGMENT16, ATTRIBUTE8, SEGMENT6, ATTRIBUTE11, SEGMENT9, DISABLE_DATE, SEGMENT10, SEGMENT18, ATTRIBUTE7, SEGMENT11, CREATED_BY, ATTRIBUTE15, ATTRIBUTE9, SEGMENT4, SUPPLIER_ENABLED_FLAG, ATTRIBUTE_CATEGORY, DESCRIPTION, SEGMENT3, SEGMENT1, ATTRIBUTE3, ATTRIBUTE10, START_DATE_ACTIVE, SEGMENT15, PROGRAM_UPDATE_DATE, ATTRIBUTE6, SUMMARY_FLAG, SEGMENT13, SEGMENT20 
 FROM MTL_CATEGORIES_B

View Text - HTML Formatted

SELECT ROWID
, CATEGORY_ID
, STRUCTURE_ID
, (DECODE(STRUCTURE_ID
, 3
, SEGMENT1
, 4
, SEGMENT1
, 5
, SEGMENT1
, 6
, SEGMENT1
, 201
, SEGMENT1
, 50136
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3
, 50152
, SEGMENT1
, 50153
, SEGMENT1
, 50168
, SEGMENT1 || '.' || SEGMENT2
, 50169
, SEGMENT1
, 50190
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4
, 50208
, SEGMENT1
, 50229
, SEGMENT1
, 50268
, SEGMENT1
, 50272
, SEGMENT1
, 50308
, SEGMENT1 || '.' || SEGMENT2
, NULL))
, (DECODE(STRUCTURE_ID
, 3
, RPAD(NVL(SEGMENT1
, ' ')
, 30)
, 4
, RPAD(NVL(SEGMENT1
, ' ')
, 30)
, 5
, RPAD(NVL(SEGMENT1
, ' ')
, 30)
, 6
, RPAD(NVL(SEGMENT1
, ' ')
, 30)
, 201
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, 50136
, LPAD(NVL(SEGMENT1
, ' ')
, 22) || '.' || LPAD(NVL(SEGMENT2
, ' ')
, 22) || '.' || LPAD(NVL(SEGMENT3
, ' ')
, 22)
, 50152
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, 50153
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, 50168
, RPAD(NVL(SEGMENT1
, ' ')
, 40) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 40)
, 50169
, RPAD(NVL(SEGMENT1
, ' ')
, 30)
, 50190
, RPAD(NVL(SEGMENT1
, ' ')
, 30) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 40) || '.' || RPAD(NVL(SEGMENT3
, ' ')
, 40) || '.' || RPAD(NVL(SEGMENT4
, ' ')
, 1)
, 50208
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, 50229
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, 50268
, LPAD(NVL(SEGMENT1
, ' ')
, 4)
, 50272
, RPAD(NVL(SEGMENT1
, ' ')
, 40)
, 50308
, RPAD(NVL(SEGMENT1
, ' ')
, 40) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 40)
, NULL))
, ATTRIBUTE13
, ATTRIBUTE12
, ATTRIBUTE14
, PROGRAM_ID
, SEGMENT5
, SEGMENT19
, ENABLED_FLAG
, SEGMENT8
, LAST_UPDATE_DATE
, CREATION_DATE
, ATTRIBUTE4
, PROGRAM_APPLICATION_ID
, END_DATE_ACTIVE
, SEGMENT2
, SEGMENT12
, REQUEST_ID
, ATTRIBUTE2
, WEB_STATUS
, SEGMENT17
, SEGMENT7
, SEGMENT14
, ATTRIBUTE5
, LAST_UPDATED_BY
, ATTRIBUTE1
, LAST_UPDATE_LOGIN
, SEGMENT16
, ATTRIBUTE8
, SEGMENT6
, ATTRIBUTE11
, SEGMENT9
, DISABLE_DATE
, SEGMENT10
, SEGMENT18
, ATTRIBUTE7
, SEGMENT11
, CREATED_BY
, ATTRIBUTE15
, ATTRIBUTE9
, SEGMENT4
, SUPPLIER_ENABLED_FLAG
, ATTRIBUTE_CATEGORY
, DESCRIPTION
, SEGMENT3
, SEGMENT1
, ATTRIBUTE3
, ATTRIBUTE10
, START_DATE_ACTIVE
, SEGMENT15
, PROGRAM_UPDATE_DATE
, ATTRIBUTE6
, SUMMARY_FLAG
, SEGMENT13
, SEGMENT20
FROM MTL_CATEGORIES_B