VIEW: APPS.FA_LOCATIONS_KFV

Source

View Text - Preformatted

SELECT ROWID row_id, LOCATION_ID, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 concatenated_segments , RPAD ( NVL ( SEGMENT1, ' ') , 2 ) || '.' || RPAD ( NVL ( SEGMENT2, ' ') , 3 ) || '.' || RPAD ( NVL ( SEGMENT3, ' ') , 8 ) || '.' || RPAD ( NVL ( SEGMENT4, ' ') , 7 ) padded_concatenated_segments, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_CATEGORY_CODE FROM FA_LOCATIONS 

View Text - HTML Formatted

SELECT ROWID ROW_ID
, LOCATION_ID
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 CONCATENATED_SEGMENTS
, RPAD ( NVL ( SEGMENT1
, ' ')
, 2 ) || '.' || RPAD ( NVL ( SEGMENT2
, ' ')
, 3 ) || '.' || RPAD ( NVL ( SEGMENT3
, ' ')
, 8 ) || '.' || RPAD ( NVL ( SEGMENT4
, ' ')
, 7 ) PADDED_CONCATENATED_SEGMENTS
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
FROM FA_LOCATIONS