CN_INT_CALC_JOBS_ALL_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
SIMULATION_ID CALC_JOB_ID OBJECT_VERSION_NUMBER ORG_ID REQUEST_ID BATCH_NAME START_DATE END_DATE INTELLIGENT_FLAG PARTICIPANT_OPTION JOB_STATUS PROCESS_AUDIT_ID LOGICAL_BATCH_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CALCULATE_FOR

Query

SQL_Statement

select simulation_id, CALC_JOB_ID, OBJECT_VERSION_NUMBER, ORG_ID, REQUEST_ID, BATCH_NAME, START_DATE, END_DATE, INTELLIGENT_FLAG, PARTICIPANT_OPTION, JOB_STATUS, PROCESS_AUDIT_ID, LOGICAL_BATCH_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CALCULATE_FOR from ( select null simulation_id, 'N' simulation_delete_flag, CALC_JOB_ID, OBJECT_VERSION_NUMBER, ORG_ID, REQUEST_ID, BATCH_NAME, START_DATE, END_DATE, INTELLIGENT_FLAG, PARTICIPANT_OPTION, JOB_STATUS, PROCESS_AUDIT_ID, LOGICAL_BATCH_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CALCULATE_FOR from cn_tp_calc_jobs_all tp where sys_context('fusion_ic_cn', 'calc_mode') = 'R' or (sys_context('fusion_ic_cn', 'calc_mode') = 'S' and not exists ( select 1 from cn_sim_calc_jobs_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and tp.CALC_JOB_ID = sim.CALC_JOB_ID ) ) union all ( select simulation_id, simulation_delete_flag, CALC_JOB_ID, OBJECT_VERSION_NUMBER, ORG_ID, REQUEST_ID, BATCH_NAME, START_DATE, END_DATE, INTELLIGENT_FLAG, PARTICIPANT_OPTION, JOB_STATUS, PROCESS_AUDIT_ID, LOGICAL_BATCH_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CALCULATE_FOR from cn_sim_calc_jobs_all sim where sys_context('fusion_ic_cn', 'calc_mode') = 'S' and simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and simulation_delete_flag = 'N' ) )