CN_SIM_CREDITS_ALL_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

SIMULATION_ID SIMULATION_DELETE_FLAG CREDIT_ID OBJECT_VERSION_NUMBER TRANSACTION_ID SOURCE_CREDIT_ID SUMMARY_CREDIT_ID TRANSACTION_TYPE CREDIT_TYPE CREATED_DURING PARTICIPANT_ID CREDITED_PARTICIPANT_ID ROLE_ID SOURCE_EVENT_DATE SOURCE_EVENT_PERIOD_ID ROLLUP_DATE CREDIT_DATE CREDIT_AMT_SOURCE_CURR TRANSACTION_AMT_SOURCE_CURR SOURCE_CURRENCY_CODE CALC_TO_SOURCE_CURR_CNVRT CREDIT_AMT_FUNC_CURR TRANSACTION_AMT_FUNC_CURR CALC_TO_FUNC_CURR_CNVRT SOURCE_TO_FUNC_CURR_CNVRT CREDIT_AMT_HOME_CURR TRANSACTION_AMT_HOME_CURR HOME_CURRENCY_CODE CALC_TO_HOME_CURR_CNVRT SOURCE_TO_HOME_CURR_CNVRT CREDIT_AMT_CALC_CURR TRANSACTION_AMT_CALC_CURR CALC_CURRENCY_CODE SOURCE_TO_CALC_CURR_CNVRT TRANSACTION_QTY REVENUE_TYPE NEW_CREDIT_ID ELIGIBLE_CAT_ID SOURCE_TYPE OBJECT_STATUS ADJUSTMENT_STATUS ADJUSTMENT_COMMENTS PROCESS_CODE REASON_CODE SOURCE_ORG_ID ORG_ID SOURCE_TRX_NUMBER SPLIT_PCT CLSFN_RULE_ID CREDIT_RULE_ID DIRECT_RULE_ID ROLLUP_LEVEL CHANGED_CREDIT_FLAG WORKER_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN 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 COLLECTION_STATUS HOLD_FLAG ERROR_CODE

Query

SQL_Statement

select simulation_id, SIMULATION_DELETE_FLAG, CREDIT_ID, OBJECT_VERSION_NUMBER, TRANSACTION_ID, SOURCE_CREDIT_ID, SUMMARY_CREDIT_ID, TRANSACTION_TYPE, CREDIT_TYPE, CREATED_DURING, PARTICIPANT_ID, CREDITED_PARTICIPANT_ID, ROLE_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, ROLLUP_DATE, CREDIT_DATE, CREDIT_AMT_SOURCE_CURR, TRANSACTION_AMT_SOURCE_CURR, SOURCE_CURRENCY_CODE, CALC_TO_SOURCE_CURR_CNVRT, CREDIT_AMT_FUNC_CURR, TRANSACTION_AMT_FUNC_CURR, CALC_TO_FUNC_CURR_CNVRT, SOURCE_TO_FUNC_CURR_CNVRT, CREDIT_AMT_HOME_CURR, TRANSACTION_AMT_HOME_CURR, HOME_CURRENCY_CODE, CALC_TO_HOME_CURR_CNVRT, SOURCE_TO_HOME_CURR_CNVRT, CREDIT_AMT_CALC_CURR, TRANSACTION_AMT_CALC_CURR, CALC_CURRENCY_CODE, SOURCE_TO_CALC_CURR_CNVRT, TRANSACTION_QTY, REVENUE_TYPE, NEW_CREDIT_ID, ELIGIBLE_CAT_ID, SOURCE_TYPE, OBJECT_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, PROCESS_CODE, REASON_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SPLIT_PCT, CLSFN_RULE_ID, CREDIT_RULE_ID, DIRECT_RULE_ID, ROLLUP_LEVEL, CHANGED_CREDIT_FLAG, WORKER_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, 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, COLLECTION_STATUS, HOLD_FLAG, ERROR_CODE from cn_sim_credits_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id'))