CN_INT_SRP_PER_FORM_EXTS_ALL_V
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
SIMULATION_ID SRP_PER_FORMULA_EXT_ID SRP_PER_FORM_METRIC_ID FORMULA_ID INPUT_SEQUENCE INPUT_ACHIEVED_PTD INPUT_ACHIEVED_ITD ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ORG_ID OBJECT_VERSION_NUMBER PARTICIPANT_ID COMP_PLAN_ID PLAN_COMPONENT_ID PERIOD_ID SRP_COMP_PLAN_ID |
Query
SQL_Statement |
---|
select simulation_id, SRP_PER_FORMULA_EXT_ID, SRP_PER_FORM_METRIC_ID, FORMULA_ID, INPUT_SEQUENCE, INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ORG_ID, OBJECT_VERSION_NUMBER, PARTICIPANT_ID, COMP_PLAN_ID, PLAN_COMPONENT_ID, PERIOD_ID, SRP_COMP_PLAN_ID from ( select null simulation_id, 'N' simulation_delete_flag, SRP_PER_FORMULA_EXT_ID, SRP_PER_FORM_METRIC_ID, FORMULA_ID, INPUT_SEQUENCE, INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ORG_ID, OBJECT_VERSION_NUMBER, PARTICIPANT_ID, COMP_PLAN_ID, PLAN_COMPONENT_ID, PERIOD_ID, SRP_COMP_PLAN_ID from cn_srp_per_formula_exts_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_srp_per_form_exts_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and tp.SRP_PER_FORMULA_EXT_ID = sim.SRP_PER_FORMULA_EXT_ID ) ) union all ( select simulation_id, simulation_delete_flag, SRP_PER_FORMULA_EXT_ID, SRP_PER_FORM_METRIC_ID, FORMULA_ID, INPUT_SEQUENCE, INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ORG_ID, OBJECT_VERSION_NUMBER, PARTICIPANT_ID, COMP_PLAN_ID, PLAN_COMPONENT_ID, PERIOD_ID, SRP_COMP_PLAN_ID from cn_sim_srp_per_form_exts_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' ) ) |