CN_INT_SRP_PER_FORM_METR_ALL_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

SIMULATION_ID SRP_PER_FORM_METRIC_ID SRP_COMP_PLAN_ID SRP_PLAN_COMPONENT_ID SRP_FORM_METRIC_ID PLAN_COMPONENT_ID FORMULA_ID GOAL_ID PARTICIPANT_ID PERIOD_ID COMMISSION_PAID_PTD COMMISSION_PAID_ITD INPUT_ACHIEVED_PTD INPUT_ACHIEVED_ITD OUTPUT_ACHIEVED_PTD OUTPUT_ACHIEVED_ITD ADVANCE_RECOVERED_PTD ADVANCE_RECOVERED_ITD ADVANCE_TO_REC_PTD ADVANCE_TO_REC_ITD COMMISSION_PEND_PTD COMMISSION_PEND_ITD RECOVERY_AMOUNT_PTD RECOVERY_AMOUNT_ITD ROLLOVER TRANSACTION_AMOUNT_PTD TRANSACTION_AMOUNT_ITD PARTICIPANT_RANK RANK_REQUEST_ID 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 COMP_PLAN_ID CURRENCY_CODE COMMISSION_PAID_TUITD

Query

SQL_Statement

select simulation_id, SRP_PER_FORM_METRIC_ID, SRP_COMP_PLAN_ID, SRP_PLAN_COMPONENT_ID, SRP_FORM_METRIC_ID, PLAN_COMPONENT_ID, FORMULA_ID, GOAL_ID, PARTICIPANT_ID, PERIOD_ID, COMMISSION_PAID_PTD, COMMISSION_PAID_ITD, INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD, OUTPUT_ACHIEVED_PTD, OUTPUT_ACHIEVED_ITD, ADVANCE_RECOVERED_PTD, ADVANCE_RECOVERED_ITD, ADVANCE_TO_REC_PTD, ADVANCE_TO_REC_ITD, COMMISSION_PEND_PTD, COMMISSION_PEND_ITD, RECOVERY_AMOUNT_PTD, RECOVERY_AMOUNT_ITD, ROLLOVER, TRANSACTION_AMOUNT_PTD, TRANSACTION_AMOUNT_ITD, PARTICIPANT_RANK, RANK_REQUEST_ID, 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, COMP_PLAN_ID, CURRENCY_CODE, COMMISSION_PAID_TUITD from ( select null simulation_id, 'N' simulation_delete_flag, SRP_PER_FORM_METRIC_ID, SRP_COMP_PLAN_ID, SRP_PLAN_COMPONENT_ID, SRP_FORM_METRIC_ID, PLAN_COMPONENT_ID, FORMULA_ID, GOAL_ID, PARTICIPANT_ID, PERIOD_ID, COMMISSION_PAID_PTD, COMMISSION_PAID_ITD, INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD, OUTPUT_ACHIEVED_PTD, OUTPUT_ACHIEVED_ITD, ADVANCE_RECOVERED_PTD, ADVANCE_RECOVERED_ITD, ADVANCE_TO_REC_PTD, ADVANCE_TO_REC_ITD, COMMISSION_PEND_PTD, COMMISSION_PEND_ITD, RECOVERY_AMOUNT_PTD, RECOVERY_AMOUNT_ITD, ROLLOVER, TRANSACTION_AMOUNT_PTD, TRANSACTION_AMOUNT_ITD, PARTICIPANT_RANK, RANK_REQUEST_ID, 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, COMP_PLAN_ID, CURRENCY_CODE, COMMISSION_PAID_TUITD from cn_srp_per_form_metrics_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_metr_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and tp.SRP_PER_FORM_METRIC_ID = sim.SRP_PER_FORM_METRIC_ID ) ) union all ( select simulation_id, simulation_delete_flag, SRP_PER_FORM_METRIC_ID, SRP_COMP_PLAN_ID, SRP_PLAN_COMPONENT_ID, SRP_FORM_METRIC_ID, PLAN_COMPONENT_ID, FORMULA_ID, GOAL_ID, PARTICIPANT_ID, PERIOD_ID, COMMISSION_PAID_PTD, COMMISSION_PAID_ITD, INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD, OUTPUT_ACHIEVED_PTD, OUTPUT_ACHIEVED_ITD, ADVANCE_RECOVERED_PTD, ADVANCE_RECOVERED_ITD, ADVANCE_TO_REC_PTD, ADVANCE_TO_REC_ITD, COMMISSION_PEND_PTD, COMMISSION_PEND_ITD, RECOVERY_AMOUNT_PTD, RECOVERY_AMOUNT_ITD, ROLLOVER, TRANSACTION_AMOUNT_PTD, TRANSACTION_AMOUNT_ITD, PARTICIPANT_RANK, RANK_REQUEST_ID, 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, COMP_PLAN_ID, CURRENCY_CODE, COMMISSION_PAID_TUITD from cn_sim_srp_per_form_metr_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' ) )