VIEW: APPS.US_GOV_APPRAISAL_TYPE

Source

View Text - Preformatted

SELECT ROWID, ANALYSIS_CRITERIA_ID, SEGMENT1, SEGMENT2, TO_DATE(SEGMENT3, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT4, SEGMENT5, TO_DATE(SEGMENT17, 'YYYY/MM/DD HH24:MI:SS'), TO_DATE(SEGMENT6, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, TO_DATE(SEGMENT12, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT13, TO_DATE(SEGMENT14, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT15, FND_NUMBER.CANONICAL_TO_NUMBER(SEGMENT16), PROGRAM_UPDATE_DATE, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID 
 FROM PER_ANALYSIS_CRITERIA 
 WHERE ID_FLEX_NUM = 6

View Text - HTML Formatted

SELECT ROWID
, ANALYSIS_CRITERIA_ID
, SEGMENT1
, SEGMENT2
, TO_DATE(SEGMENT3
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT4
, SEGMENT5
, TO_DATE(SEGMENT17
, 'YYYY/MM/DD HH24:MI:SS')
, TO_DATE(SEGMENT6
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, TO_DATE(SEGMENT12
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT13
, TO_DATE(SEGMENT14
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT15
, FND_NUMBER.CANONICAL_TO_NUMBER(SEGMENT16)
, PROGRAM_UPDATE_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
FROM PER_ANALYSIS_CRITERIA
WHERE ID_FLEX_NUM = 6