DBA Data[Home] [Help]

VIEW: APPS.FA_ASSET_KEYWORDS_KFV

Source

View Text - Preformatted

SELECT ROWID row_id, CODE_COMBINATION_ID, SEGMENT1 || '.' || SEGMENT2 concatenated_segments, RPAD ( NVL ( SEGMENT1, ' ') , 12 ) || '.' || RPAD ( NVL ( SEGMENT2, ' ') , 4 ) padded_concatenated_segments, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN FROM FA_ASSET_KEYWORDS 
View Text - HTML Formatted

SELECT ROWID ROW_ID
, CODE_COMBINATION_ID
, SEGMENT1 || '.' || SEGMENT2 CONCATENATED_SEGMENTS
, RPAD ( NVL ( SEGMENT1
, ' ')
, 12 ) || '.' || RPAD ( NVL ( SEGMENT2
, ' ')
, 4 ) PADDED_CONCATENATED_SEGMENTS
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FA_ASSET_KEYWORDS