CN_SIM_MEASURE_RESULTS_ALL

Details

Schema: FUSION
Object owner: CN
Object type: VIEW

Columns

Name
SIMULATION_ID SIMULATION_DELETE_FLAG SIMULATION_RESULT_TYPE MEASURE_RESULT_ID CREDIT_ID TRANSACTION_ID PARTICIPANT_ID CREDITED_PARTICIPANT_ID SOURCE_EVENT_DATE SOURCE_EVENT_PERIOD_ID GRP_BY_MEASURE_RESULT_ID TRANSACTION_AMT_CALC_CURR CREDIT_AMT_CALC_CURR CALC_CURRENCY_CODE CREATED_DURING SOURCE_MEASURE_RESULT_ID EARNING_ID REVENUE_TYPE TRANSACTION_QTY MEASURE_TYPE TRANSACTION_TYPE ELIGIBLE_CAT_ID OBJECT_STATUS ADJUSTMENT_STATUS ADJUSTMENT_COMMENTS REASON_CODE SOURCE_ORG_ID ORG_ID SOURCE_TRX_NUMBER SPLIT_PCT COMMISSION_VALUE PLAN_COMPONENT_ID FORMULA_ID FORMULA_ECAT_ID TIER_SPLITS RATE_TABLE_VALUE_ID SRP_COMP_PLAN_ID ROLE_ID INPUT_ACHIEVED OUTPUT_ACHIEVED CREDIT_FACTOR EARNING_FACTOR EVENT_FACTOR_VALUE FORMULA_WEIGHT ERROR_REASON EARNING_TYPE_ID WORKER_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TRX_ATTRIBUTE1 TRX_ATTRIBUTE2 TRX_ATTRIBUTE3 TRX_ATTRIBUTE4 TRX_ATTRIBUTE5 TRX_ATTRIBUTE6 TRX_ATTRIBUTE7 TRX_ATTRIBUTE8 TRX_ATTRIBUTE9 TRX_ATTRIBUTE10 TRX_ATTRIBUTE11 TRX_ATTRIBUTE12 TRX_ATTRIBUTE13 TRX_ATTRIBUTE14 TRX_ATTRIBUTE15 TRX_ATTRIBUTE_NUMBER1 TRX_ATTRIBUTE_NUMBER2 TRX_ATTRIBUTE_NUMBER3 TRX_ATTRIBUTE_NUMBER4 TRX_ATTRIBUTE_NUMBER5 TRX_ATTRIBUTE_NUMBER6 TRX_ATTRIBUTE_NUMBER7 TRX_ATTRIBUTE_NUMBER8 TRX_ATTRIBUTE_NUMBER9 TRX_ATTRIBUTE_NUMBER10 TRX_ATTRIBUTE_NUMBER11 TRX_ATTRIBUTE_NUMBER12 TRX_ATTRIBUTE_NUMBER13 TRX_ATTRIBUTE_NUMBER14 TRX_ATTRIBUTE_NUMBER15 TRX_ATTRIBUTE_NUMBER16 TRX_ATTRIBUTE_NUMBER17 TRX_ATTRIBUTE_NUMBER18 TRX_ATTRIBUTE_NUMBER19 TRX_ATTRIBUTE_NUMBER20 TRX_ATTRIBUTE_NUMBER21 TRX_ATTRIBUTE_NUMBER22 TRX_ATTRIBUTE_NUMBER23 TRX_ATTRIBUTE_NUMBER24 TRX_ATTRIBUTE_NUMBER25 TRX_ATTRIBUTE_NUMBER26 TRX_ATTRIBUTE_NUMBER27 TRX_ATTRIBUTE_NUMBER28 TRX_ATTRIBUTE_NUMBER29 TRX_ATTRIBUTE_NUMBER30 TRX_ATTRIBUTE_NUMBER31 TRX_ATTRIBUTE_NUMBER32 TRX_ATTRIBUTE_NUMBER33 TRX_ATTRIBUTE_NUMBER34 TRX_ATTRIBUTE_NUMBER35 TRX_ATTRIBUTE_NUMBER36 TRX_ATTRIBUTE_NUMBER37 TRX_ATTRIBUTE_NUMBER38 TRX_ATTRIBUTE_NUMBER39 TRX_ATTRIBUTE_NUMBER40 TRX_ATTRIBUTE_NUMBER41 TRX_ATTRIBUTE_NUMBER42 TRX_ATTRIBUTE_NUMBER43 TRX_ATTRIBUTE_NUMBER44 TRX_ATTRIBUTE_NUMBER45 TRX_ATTRIBUTE_NUMBER46 TRX_ATTRIBUTE_NUMBER47 TRX_ATTRIBUTE_NUMBER48 TRX_ATTRIBUTE_NUMBER49 TRX_ATTRIBUTE_NUMBER50

Name

SIMULATION_ID

SIMULATION_DELETE_FLAG

SIMULATION_RESULT_TYPE

MEASURE_RESULT_ID

CREDIT_ID

TRANSACTION_ID

PARTICIPANT_ID

CREDITED_PARTICIPANT_ID

SOURCE_EVENT_DATE

SOURCE_EVENT_PERIOD_ID

GRP_BY_MEASURE_RESULT_ID

TRANSACTION_AMT_CALC_CURR

CREDIT_AMT_CALC_CURR

CALC_CURRENCY_CODE

CREATED_DURING

SOURCE_MEASURE_RESULT_ID

EARNING_ID

REVENUE_TYPE

TRANSACTION_QTY

MEASURE_TYPE

TRANSACTION_TYPE

ELIGIBLE_CAT_ID

OBJECT_STATUS

ADJUSTMENT_STATUS

ADJUSTMENT_COMMENTS

REASON_CODE

SOURCE_ORG_ID

ORG_ID

SOURCE_TRX_NUMBER

SPLIT_PCT

COMMISSION_VALUE

PLAN_COMPONENT_ID

FORMULA_ID

FORMULA_ECAT_ID

TIER_SPLITS

RATE_TABLE_VALUE_ID

SRP_COMP_PLAN_ID

ROLE_ID

INPUT_ACHIEVED

OUTPUT_ACHIEVED

CREDIT_FACTOR

EARNING_FACTOR

EVENT_FACTOR_VALUE

FORMULA_WEIGHT

ERROR_REASON

EARNING_TYPE_ID

WORKER_ID

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

TRX_ATTRIBUTE1

TRX_ATTRIBUTE2

TRX_ATTRIBUTE3

TRX_ATTRIBUTE4

TRX_ATTRIBUTE5

TRX_ATTRIBUTE6

TRX_ATTRIBUTE7

TRX_ATTRIBUTE8

TRX_ATTRIBUTE9

TRX_ATTRIBUTE10

TRX_ATTRIBUTE11

TRX_ATTRIBUTE12

TRX_ATTRIBUTE13

TRX_ATTRIBUTE14

TRX_ATTRIBUTE15

TRX_ATTRIBUTE_NUMBER1

TRX_ATTRIBUTE_NUMBER2

TRX_ATTRIBUTE_NUMBER3

TRX_ATTRIBUTE_NUMBER4

TRX_ATTRIBUTE_NUMBER5

TRX_ATTRIBUTE_NUMBER6

TRX_ATTRIBUTE_NUMBER7

TRX_ATTRIBUTE_NUMBER8

TRX_ATTRIBUTE_NUMBER9

TRX_ATTRIBUTE_NUMBER10

TRX_ATTRIBUTE_NUMBER11

TRX_ATTRIBUTE_NUMBER12

TRX_ATTRIBUTE_NUMBER13

TRX_ATTRIBUTE_NUMBER14

TRX_ATTRIBUTE_NUMBER15

TRX_ATTRIBUTE_NUMBER16

TRX_ATTRIBUTE_NUMBER17

TRX_ATTRIBUTE_NUMBER18

TRX_ATTRIBUTE_NUMBER19

TRX_ATTRIBUTE_NUMBER20

TRX_ATTRIBUTE_NUMBER21

TRX_ATTRIBUTE_NUMBER22

TRX_ATTRIBUTE_NUMBER23

TRX_ATTRIBUTE_NUMBER24

TRX_ATTRIBUTE_NUMBER25

TRX_ATTRIBUTE_NUMBER26

TRX_ATTRIBUTE_NUMBER27

TRX_ATTRIBUTE_NUMBER28

TRX_ATTRIBUTE_NUMBER29

TRX_ATTRIBUTE_NUMBER30

TRX_ATTRIBUTE_NUMBER31

TRX_ATTRIBUTE_NUMBER32

TRX_ATTRIBUTE_NUMBER33

TRX_ATTRIBUTE_NUMBER34

TRX_ATTRIBUTE_NUMBER35

TRX_ATTRIBUTE_NUMBER36

TRX_ATTRIBUTE_NUMBER37

TRX_ATTRIBUTE_NUMBER38

TRX_ATTRIBUTE_NUMBER39

TRX_ATTRIBUTE_NUMBER40

TRX_ATTRIBUTE_NUMBER41

TRX_ATTRIBUTE_NUMBER42

TRX_ATTRIBUTE_NUMBER43

TRX_ATTRIBUTE_NUMBER44

TRX_ATTRIBUTE_NUMBER45

TRX_ATTRIBUTE_NUMBER46

TRX_ATTRIBUTE_NUMBER47

TRX_ATTRIBUTE_NUMBER48

TRX_ATTRIBUTE_NUMBER49

TRX_ATTRIBUTE_NUMBER50

Query

SQL_Statement
select "SIMULATION_ID","SIMULATION_DELETE_FLAG","SIMULATION_RESULT_TYPE","MEASURE_RESULT_ID","CREDIT_ID","TRANSACTION_ID","PARTICIPANT_ID","CREDITED_PARTICIPANT_ID","SOURCE_EVENT_DATE","SOURCE_EVENT_PERIOD_ID","GRP_BY_MEASURE_RESULT_ID","TRANSACTION_AMT_CALC_CURR","CREDIT_AMT_CALC_CURR","CALC_CURRENCY_CODE","CREATED_DURING","SOURCE_MEASURE_RESULT_ID","EARNING_ID","REVENUE_TYPE","TRANSACTION_QTY","MEASURE_TYPE","TRANSACTION_TYPE","ELIGIBLE_CAT_ID","OBJECT_STATUS","ADJUSTMENT_STATUS","ADJUSTMENT_COMMENTS","REASON_CODE","SOURCE_ORG_ID","ORG_ID","SOURCE_TRX_NUMBER","SPLIT_PCT","COMMISSION_VALUE","PLAN_COMPONENT_ID","FORMULA_ID","FORMULA_ECAT_ID","TIER_SPLITS","RATE_TABLE_VALUE_ID","SRP_COMP_PLAN_ID","ROLE_ID","INPUT_ACHIEVED","OUTPUT_ACHIEVED","CREDIT_FACTOR","EARNING_FACTOR","EVENT_FACTOR_VALUE","FORMULA_WEIGHT","ERROR_REASON","EARNING_TYPE_ID","WORKER_ID","REQUEST_ID","JOB_DEFINITION_NAME","JOB_DEFINITION_PACKAGE","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","TRX_ATTRIBUTE1","TRX_ATTRIBUTE2","TRX_ATTRIBUTE3","TRX_ATTRIBUTE4","TRX_ATTRIBUTE5","TRX_ATTRIBUTE6","TRX_ATTRIBUTE7","TRX_ATTRIBUTE8","TRX_ATTRIBUTE9","TRX_ATTRIBUTE10","TRX_ATTRIBUTE11","TRX_ATTRIBUTE12","TRX_ATTRIBUTE13","TRX_ATTRIBUTE14","TRX_ATTRIBUTE15","TRX_ATTRIBUTE_NUMBER1","TRX_ATTRIBUTE_NUMBER2","TRX_ATTRIBUTE_NUMBER3","TRX_ATTRIBUTE_NUMBER4","TRX_ATTRIBUTE_NUMBER5","TRX_ATTRIBUTE_NUMBER6","TRX_ATTRIBUTE_NUMBER7","TRX_ATTRIBUTE_NUMBER8","TRX_ATTRIBUTE_NUMBER9","TRX_ATTRIBUTE_NUMBER10","TRX_ATTRIBUTE_NUMBER11","TRX_ATTRIBUTE_NUMBER12","TRX_ATTRIBUTE_NUMBER13","TRX_ATTRIBUTE_NUMBER14","TRX_ATTRIBUTE_NUMBER15","TRX_ATTRIBUTE_NUMBER16","TRX_ATTRIBUTE_NUMBER17","TRX_ATTRIBUTE_NUMBER18","TRX_ATTRIBUTE_NUMBER19","TRX_ATTRIBUTE_NUMBER20","TRX_ATTRIBUTE_NUMBER21","TRX_ATTRIBUTE_NUMBER22","TRX_ATTRIBUTE_NUMBER23","TRX_ATTRIBUTE_NUMBER24","TRX_ATTRIBUTE_NUMBER25","TRX_ATTRIBUTE_NUMBER26","TRX_ATTRIBUTE_NUMBER27","TRX_ATTRIBUTE_NUMBER28","TRX_ATTRIBUTE_NUMBER29","TRX_ATTRIBUTE_NUMBER30","TRX_ATTRIBUTE_NUMBER31","TRX_ATTRIBUTE_NUMBER32","TRX_ATTRIBUTE_NUMBER33","TRX_ATTRIBUTE_NUMBER34","TRX_ATTRIBUTE_NUMBER35","TRX_ATTRIBUTE_NUMBER36","TRX_ATTRIBUTE_NUMBER37","TRX_ATTRIBUTE_NUMBER38","TRX_ATTRIBUTE_NUMBER39","TRX_ATTRIBUTE_NUMBER40","TRX_ATTRIBUTE_NUMBER41","TRX_ATTRIBUTE_NUMBER42","TRX_ATTRIBUTE_NUMBER43","TRX_ATTRIBUTE_NUMBER44","TRX_ATTRIBUTE_NUMBER45","TRX_ATTRIBUTE_NUMBER46","TRX_ATTRIBUTE_NUMBER47","TRX_ATTRIBUTE_NUMBER48","TRX_ATTRIBUTE_NUMBER49","TRX_ATTRIBUTE_NUMBER50" from CN_SIM_MEASURE_RESULTS_ALL where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id'))

SQL_Statement

select "SIMULATION_ID","SIMULATION_DELETE_FLAG","SIMULATION_RESULT_TYPE","MEASURE_RESULT_ID","CREDIT_ID","TRANSACTION_ID","PARTICIPANT_ID","CREDITED_PARTICIPANT_ID","SOURCE_EVENT_DATE","SOURCE_EVENT_PERIOD_ID","GRP_BY_MEASURE_RESULT_ID","TRANSACTION_AMT_CALC_CURR","CREDIT_AMT_CALC_CURR","CALC_CURRENCY_CODE","CREATED_DURING","SOURCE_MEASURE_RESULT_ID","EARNING_ID","REVENUE_TYPE","TRANSACTION_QTY","MEASURE_TYPE","TRANSACTION_TYPE","ELIGIBLE_CAT_ID","OBJECT_STATUS","ADJUSTMENT_STATUS","ADJUSTMENT_COMMENTS","REASON_CODE","SOURCE_ORG_ID","ORG_ID","SOURCE_TRX_NUMBER","SPLIT_PCT","COMMISSION_VALUE","PLAN_COMPONENT_ID","FORMULA_ID","FORMULA_ECAT_ID","TIER_SPLITS","RATE_TABLE_VALUE_ID","SRP_COMP_PLAN_ID","ROLE_ID","INPUT_ACHIEVED","OUTPUT_ACHIEVED","CREDIT_FACTOR","EARNING_FACTOR","EVENT_FACTOR_VALUE","FORMULA_WEIGHT","ERROR_REASON","EARNING_TYPE_ID","WORKER_ID","REQUEST_ID","JOB_DEFINITION_NAME","JOB_DEFINITION_PACKAGE","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","TRX_ATTRIBUTE1","TRX_ATTRIBUTE2","TRX_ATTRIBUTE3","TRX_ATTRIBUTE4","TRX_ATTRIBUTE5","TRX_ATTRIBUTE6","TRX_ATTRIBUTE7","TRX_ATTRIBUTE8","TRX_ATTRIBUTE9","TRX_ATTRIBUTE10","TRX_ATTRIBUTE11","TRX_ATTRIBUTE12","TRX_ATTRIBUTE13","TRX_ATTRIBUTE14","TRX_ATTRIBUTE15","TRX_ATTRIBUTE_NUMBER1","TRX_ATTRIBUTE_NUMBER2","TRX_ATTRIBUTE_NUMBER3","TRX_ATTRIBUTE_NUMBER4","TRX_ATTRIBUTE_NUMBER5","TRX_ATTRIBUTE_NUMBER6","TRX_ATTRIBUTE_NUMBER7","TRX_ATTRIBUTE_NUMBER8","TRX_ATTRIBUTE_NUMBER9","TRX_ATTRIBUTE_NUMBER10","TRX_ATTRIBUTE_NUMBER11","TRX_ATTRIBUTE_NUMBER12","TRX_ATTRIBUTE_NUMBER13","TRX_ATTRIBUTE_NUMBER14","TRX_ATTRIBUTE_NUMBER15","TRX_ATTRIBUTE_NUMBER16","TRX_ATTRIBUTE_NUMBER17","TRX_ATTRIBUTE_NUMBER18","TRX_ATTRIBUTE_NUMBER19","TRX_ATTRIBUTE_NUMBER20","TRX_ATTRIBUTE_NUMBER21","TRX_ATTRIBUTE_NUMBER22","TRX_ATTRIBUTE_NUMBER23","TRX_ATTRIBUTE_NUMBER24","TRX_ATTRIBUTE_NUMBER25","TRX_ATTRIBUTE_NUMBER26","TRX_ATTRIBUTE_NUMBER27","TRX_ATTRIBUTE_NUMBER28","TRX_ATTRIBUTE_NUMBER29","TRX_ATTRIBUTE_NUMBER30","TRX_ATTRIBUTE_NUMBER31","TRX_ATTRIBUTE_NUMBER32","TRX_ATTRIBUTE_NUMBER33","TRX_ATTRIBUTE_NUMBER34","TRX_ATTRIBUTE_NUMBER35","TRX_ATTRIBUTE_NUMBER36","TRX_ATTRIBUTE_NUMBER37","TRX_ATTRIBUTE_NUMBER38","TRX_ATTRIBUTE_NUMBER39","TRX_ATTRIBUTE_NUMBER40","TRX_ATTRIBUTE_NUMBER41","TRX_ATTRIBUTE_NUMBER42","TRX_ATTRIBUTE_NUMBER43","TRX_ATTRIBUTE_NUMBER44","TRX_ATTRIBUTE_NUMBER45","TRX_ATTRIBUTE_NUMBER46","TRX_ATTRIBUTE_NUMBER47","TRX_ATTRIBUTE_NUMBER48","TRX_ATTRIBUTE_NUMBER49","TRX_ATTRIBUTE_NUMBER50" from CN_SIM_MEASURE_RESULTS_ALL

where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id'))