VIEW: APPS.US_GOV_CONDITIONS_OF_EMPLMT

Source

View Text - Preformatted

SELECT ROWID, ANALYSIS_CRITERIA_ID, TO_DATE(SEGMENT1, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT2, TO_DATE(SEGMENT3, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT4, TO_DATE(SEGMENT5, 'YYYY/MM/DD HH24:MI:SS'), TO_DATE(SEGMENT6, 'YYYY/MM/DD HH24:MI:SS'), REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, 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 
 FROM PER_ANALYSIS_CRITERIA 
 WHERE ID_FLEX_NUM = 3

View Text - HTML Formatted

SELECT ROWID
, ANALYSIS_CRITERIA_ID
, TO_DATE(SEGMENT1
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT2
, TO_DATE(SEGMENT3
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT4
, TO_DATE(SEGMENT5
, 'YYYY/MM/DD HH24:MI:SS')
, TO_DATE(SEGMENT6
, 'YYYY/MM/DD HH24:MI:SS')
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, 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
FROM PER_ANALYSIS_CRITERIA
WHERE ID_FLEX_NUM = 3