VIEW: APPS.ZX_API_CODE_COMBINATIONS_KFV

Source

View Text - Preformatted

SELECT ROWID, CODE_COMBINATION_ID, CONTEXT_FLEX_STRUCTURE_ID,  
 (DECODE(CONTEXT_FLEX_STRUCTURE_ID,  
      50283, SEGMENT_ATTRIBUTE1 || '.' || SEGMENT_ATTRIBUTE2,  
      50284, SEGMENT_ATTRIBUTE1, NULL)),  
 (DECODE(CONTEXT_FLEX_STRUCTURE_ID,  
      50283, RPAD(NVL(SEGMENT_ATTRIBUTE1, ' '), 30) || '.' || RPAD(NVL(SEGMENT_ATTRIBUTE2, ' '), 30),  
      50284, RPAD(NVL(SEGMENT_ATTRIBUTE1, ' '), 30), NULL)),  
 ENABLED_FLAG, DESCRIPTION, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_LOGIN, SEGMENT_ATTRIBUTE1, SEGMENT_ATTRIBUTE2, SEGMENT_ATTRIBUTE3, SEGMENT_ATTRIBUTE4, SEGMENT_ATTRIBUTE5, SEGMENT_ATTRIBUTE6, SEGMENT_ATTRIBUTE7, SEGMENT_ATTRIBUTE8, SEGMENT_ATTRIBUTE9, SEGMENT_ATTRIBUTE10, SEGMENT_ATTRIBUTE11, SEGMENT_ATTRIBUTE12, SEGMENT_ATTRIBUTE13, SEGMENT_ATTRIBUTE14, SEGMENT_ATTRIBUTE15, SUMMARY_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, RECORD_TYPE_CODE 
 FROM ZX_API_CODE_COMBINATIONS

View Text - HTML Formatted

SELECT ROWID
, CODE_COMBINATION_ID
, CONTEXT_FLEX_STRUCTURE_ID
, (DECODE(CONTEXT_FLEX_STRUCTURE_ID
, 50283
, SEGMENT_ATTRIBUTE1 || '.' || SEGMENT_ATTRIBUTE2
, 50284
, SEGMENT_ATTRIBUTE1
, NULL))
, (DECODE(CONTEXT_FLEX_STRUCTURE_ID
, 50283
, RPAD(NVL(SEGMENT_ATTRIBUTE1
, ' ')
, 30) || '.' || RPAD(NVL(SEGMENT_ATTRIBUTE2
, ' ')
, 30)
, 50284
, RPAD(NVL(SEGMENT_ATTRIBUTE1
, ' ')
, 30)
, NULL))
, ENABLED_FLAG
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_LOGIN
, SEGMENT_ATTRIBUTE1
, SEGMENT_ATTRIBUTE2
, SEGMENT_ATTRIBUTE3
, SEGMENT_ATTRIBUTE4
, SEGMENT_ATTRIBUTE5
, SEGMENT_ATTRIBUTE6
, SEGMENT_ATTRIBUTE7
, SEGMENT_ATTRIBUTE8
, SEGMENT_ATTRIBUTE9
, SEGMENT_ATTRIBUTE10
, SEGMENT_ATTRIBUTE11
, SEGMENT_ATTRIBUTE12
, SEGMENT_ATTRIBUTE13
, SEGMENT_ATTRIBUTE14
, SEGMENT_ATTRIBUTE15
, SUMMARY_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, RECORD_TYPE_CODE
FROM ZX_API_CODE_COMBINATIONS