VIEW: APPS.US_GOV_SPECIAL_CONSIDERATION

Source

View Text - Preformatted

SELECT ROWID, ANALYSIS_CRITERIA_ID, SEGMENT1, TO_DATE(SEGMENT2, 'YYYY/MM/DD HH24:MI:SS'), TO_DATE(SEGMENT3, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, TO_DATE(SEGMENT14, 'YYYY/MM/DD HH24:MI:SS'), 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 = 7

View Text - HTML Formatted

SELECT ROWID
, ANALYSIS_CRITERIA_ID
, SEGMENT1
, TO_DATE(SEGMENT2
, 'YYYY/MM/DD HH24:MI:SS')
, TO_DATE(SEGMENT3
, 'YYYY/MM/DD HH24:MI:SS')
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, TO_DATE(SEGMENT14
, 'YYYY/MM/DD HH24:MI:SS')
, 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 = 7