SELECT ROWID, ANALYSIS_CRITERIA_ID, SEGMENT1, SEGMENT2, FND_NUMBER.CANONICAL_TO_NUMBER(SEGMENT3), SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, TO_DATE(SEGMENT9, '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 = 2
SELECT ROWID
, ANALYSIS_CRITERIA_ID
, SEGMENT1
, SEGMENT2
, FND_NUMBER.CANONICAL_TO_NUMBER(SEGMENT3)
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, TO_DATE(SEGMENT9
, '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 = 2
|
|
|