VIEW: APPS.US_GOV_CONDUCT_PERFORMANCE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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