CN_INT_PROCESS_BATCHES_ALL_V
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
SIMULATION_ID PROCESS_BATCH_ID ORG_ID LOGICAL_BATCH_ID PHYSICAL_BATCH_ID PARTICIPANT_ID START_DATE END_DATE START_PERIOD_ID END_PERIOD_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE STATUS_CODE CURRENT_PHASE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SRP_PERIOD_ID PERIOD_ID PROCESS_BATCH_TYPE SALES_LINE_TOTAL CALC_COMP_PLANS |
Query
SQL_Statement |
---|
select simulation_id, PROCESS_BATCH_ID, ORG_ID, LOGICAL_BATCH_ID, PHYSICAL_BATCH_ID, PARTICIPANT_ID, START_DATE, END_DATE, START_PERIOD_ID, END_PERIOD_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, STATUS_CODE, CURRENT_PHASE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SRP_PERIOD_ID, PERIOD_ID, PROCESS_BATCH_TYPE, SALES_LINE_TOTAL, CALC_COMP_PLANS from ( select null simulation_id, 'N' simulation_delete_flag, PROCESS_BATCH_ID, ORG_ID, LOGICAL_BATCH_ID, PHYSICAL_BATCH_ID, PARTICIPANT_ID, START_DATE, END_DATE, START_PERIOD_ID, END_PERIOD_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, STATUS_CODE, CURRENT_PHASE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SRP_PERIOD_ID, PERIOD_ID, PROCESS_BATCH_TYPE, SALES_LINE_TOTAL, CALC_COMP_PLANS from cn_tp_process_batches_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_process_batches_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and tp.PROCESS_BATCH_ID = sim.PROCESS_BATCH_ID ) ) union all ( select simulation_id, simulation_delete_flag, PROCESS_BATCH_ID, ORG_ID, LOGICAL_BATCH_ID, PHYSICAL_BATCH_ID, PARTICIPANT_ID, START_DATE, END_DATE, START_PERIOD_ID, END_PERIOD_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, STATUS_CODE, CURRENT_PHASE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SRP_PERIOD_ID, PERIOD_ID, PROCESS_BATCH_TYPE, SALES_LINE_TOTAL, CALC_COMP_PLANS from cn_sim_process_batches_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' ) ) |