CN_INT_EARNINGS_ALL_V
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
SIMULATION_ID EARNING_ID CREDIT_ID TRANSACTION_ID PARTICIPANT_ID CREDITED_PARTICIPANT_ID SOURCE_EVENT_DATE SOURCE_EVENT_PERIOD_ID PAY_PERIOD_ID COMM_AMT_HOME_CURR HOME_CURRENCY_CODE CALC_TO_HOME_CURR_CNVRT COMM_AMT_FUNC_CURR CALC_TO_FUNC_CURR_CNVRT COMM_AMT_CALC_CURR TRANSACTION_AMT_CALC_CURR CREDIT_AMT_CALC_CURR CALC_CURRENCY_CODE CREATED_DURING SOURCE_EARNING_ID REVENUE_TYPE TRANSACTION_QTY EARNING_TYPE TRANSACTION_TYPE ELIGIBLE_CAT_ID OBJECT_STATUS ADJUSTMENT_STATUS ADJUSTMENT_COMMENTS REASON_CODE PROCESS_CODE SOURCE_ORG_ID ORG_ID SOURCE_TRX_NUMBER SPLIT_PCT COMMISSION_VALUE PLAN_COMPONENT_ID FORMULA_ID FORMULA_ECAT_ID RATE_TABLE_VALUE_ID SRP_COMP_PLAN_ID ROLE_ID SRP_ALTERNATE_PAYEE_ID POSTING_STATUS INPUT_ACHIEVED OUTPUT_ACHIEVED CREDIT_FACTOR EARNING_FACTOR EVENT_FACTOR_VALUE FORMULA_WEIGHT ERROR_REASON PENDING_STATUS PENDING_DATE 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 TIER_SPLITS |
Query
SQL_Statement |
---|
select simulation_id, EARNING_ID, CREDIT_ID, TRANSACTION_ID, PARTICIPANT_ID, CREDITED_PARTICIPANT_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, PAY_PERIOD_ID, COMM_AMT_HOME_CURR, HOME_CURRENCY_CODE, CALC_TO_HOME_CURR_CNVRT, COMM_AMT_FUNC_CURR, CALC_TO_FUNC_CURR_CNVRT, COMM_AMT_CALC_CURR, TRANSACTION_AMT_CALC_CURR, CREDIT_AMT_CALC_CURR, CALC_CURRENCY_CODE, CREATED_DURING, SOURCE_EARNING_ID, REVENUE_TYPE, TRANSACTION_QTY, EARNING_TYPE, TRANSACTION_TYPE, ELIGIBLE_CAT_ID, OBJECT_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, REASON_CODE, PROCESS_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SPLIT_PCT, COMMISSION_VALUE, PLAN_COMPONENT_ID, FORMULA_ID, FORMULA_ECAT_ID, RATE_TABLE_VALUE_ID, SRP_COMP_PLAN_ID, ROLE_ID, SRP_ALTERNATE_PAYEE_ID, POSTING_STATUS, INPUT_ACHIEVED, OUTPUT_ACHIEVED, CREDIT_FACTOR, EARNING_FACTOR, EVENT_FACTOR_VALUE, FORMULA_WEIGHT, ERROR_REASON, PENDING_STATUS, PENDING_DATE, 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, TIER_SPLITS from ( select null simulation_id, 'N' simulation_delete_flag, EARNING_ID, CREDIT_ID, TRANSACTION_ID, PARTICIPANT_ID, CREDITED_PARTICIPANT_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, PAY_PERIOD_ID, COMM_AMT_HOME_CURR, HOME_CURRENCY_CODE, CALC_TO_HOME_CURR_CNVRT, COMM_AMT_FUNC_CURR, CALC_TO_FUNC_CURR_CNVRT, COMM_AMT_CALC_CURR, TRANSACTION_AMT_CALC_CURR, CREDIT_AMT_CALC_CURR, CALC_CURRENCY_CODE, CREATED_DURING, SOURCE_EARNING_ID, REVENUE_TYPE, TRANSACTION_QTY, EARNING_TYPE, TRANSACTION_TYPE, ELIGIBLE_CAT_ID, OBJECT_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, REASON_CODE, PROCESS_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SPLIT_PCT, COMMISSION_VALUE, PLAN_COMPONENT_ID, FORMULA_ID, FORMULA_ECAT_ID, RATE_TABLE_VALUE_ID, SRP_COMP_PLAN_ID, ROLE_ID, SRP_ALTERNATE_PAYEE_ID, POSTING_STATUS, INPUT_ACHIEVED, OUTPUT_ACHIEVED, CREDIT_FACTOR, EARNING_FACTOR, EVENT_FACTOR_VALUE, FORMULA_WEIGHT, ERROR_REASON, PENDING_STATUS, PENDING_DATE, 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, TIER_SPLITS from cn_tp_earnings_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_earnings_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and tp.EARNING_ID = sim.EARNING_ID ) ) union all ( select simulation_id, simulation_delete_flag, EARNING_ID, CREDIT_ID, TRANSACTION_ID, PARTICIPANT_ID, CREDITED_PARTICIPANT_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, PAY_PERIOD_ID, COMM_AMT_HOME_CURR, HOME_CURRENCY_CODE, CALC_TO_HOME_CURR_CNVRT, COMM_AMT_FUNC_CURR, CALC_TO_FUNC_CURR_CNVRT, COMM_AMT_CALC_CURR, TRANSACTION_AMT_CALC_CURR, CREDIT_AMT_CALC_CURR, CALC_CURRENCY_CODE, CREATED_DURING, SOURCE_EARNING_ID, REVENUE_TYPE, TRANSACTION_QTY, EARNING_TYPE, TRANSACTION_TYPE, ELIGIBLE_CAT_ID, OBJECT_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, REASON_CODE, PROCESS_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SPLIT_PCT, COMMISSION_VALUE, PLAN_COMPONENT_ID, FORMULA_ID, FORMULA_ECAT_ID, RATE_TABLE_VALUE_ID, SRP_COMP_PLAN_ID, ROLE_ID, SRP_ALTERNATE_PAYEE_ID, POSTING_STATUS, INPUT_ACHIEVED, OUTPUT_ACHIEVED, CREDIT_FACTOR, EARNING_FACTOR, EVENT_FACTOR_VALUE, FORMULA_WEIGHT, ERROR_REASON, PENDING_STATUS, PENDING_DATE, 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, TIER_SPLITS from cn_sim_earnings_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' ) ) |