XLA_FSN_MAP_SET_VAL_VIEW

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

MAPPING_SET_CODE AMB_CONTEXT_CODE VALUE_CONSTANT VALUE_CODE_COMBINATION_ID EFFECTIVE_DATE_FROM EFFECTIVE_DATE_TO ENABLED_FLAG INPUT_VALUE_TYPE_CODE INPUT_VALUE_CONSTANT1 INPUT_VALUE_CONSTANT2 INPUT_VALUE_CONSTANT3 INPUT_VALUE_CONSTANT4 INPUT_VALUE_CONSTANT5 INPUT_VALUE_CONSTANT6 INPUT_VALUE_CONSTANT7 INPUT_VALUE_CONSTANT8 INPUT_VALUE_CONSTANT9 INPUT_VALUE_CONSTANT10 CONCAT_INPUT MAP_PREC FLAVOR_ID STRIPE_TYPE_CODE INPUT_COA_ID

Query

SQL_Statement

Select V.MAPPING_SET_CODE Mapping_Set_Code, V.AMB_CONTEXT_CODE AMB_Context_Code, V.VALUE_CONSTANT Value_Constant, V.VALUE_CODE_COMBINATION_ID Value_Code_Combination_ID, V.effective_start_date as Effective_Date_From, V.effective_end_date as Effective_Date_To, V.ENABLED_FLAG Enabled_Flag, 'I' Input_Value_Type_Code, V.INPUT_VALUE_CONSTANT1 Input_Value_Constant1, V.INPUT_VALUE_CONSTANT2 Input_Value_Constant2, V.INPUT_VALUE_CONSTANT3 Input_Value_Constant3, V.INPUT_VALUE_CONSTANT4 Input_Value_Constant4, V.INPUT_VALUE_CONSTANT5 Input_Value_Constant5, V.INPUT_VALUE_CONSTANT6 Input_Value_Constant6, V.INPUT_VALUE_CONSTANT7 Input_Value_Constant7, V.INPUT_VALUE_CONSTANT8 Input_Value_Constant8, V.INPUT_VALUE_CONSTANT9 Input_Value_Constant9, V.INPUT_VALUE_CONSTANT10 Input_Value_Constant10, V.CONCAT_INPUT Concat_Input, V.MAP_PREC Map_Prec, V.STRIPE_ID Flavor_ID, DECODE(B.FLEXFIELD_ASSIGN_MODE_CODE, 'V', 'V', 'C') Stripe_Type_Code, nvl(V.transaction_coa_id, -1) input_coa_id from XLA_MAPPING_SET_VALUES V, XLA_MAPPING_SETS_B B where B.MAPPING_SET_CODE = V.MAPPING_SET_CODE and B.AMB_CONTEXT_CODE = V.AMB_CONTEXT_CODE and B.APPLICATION_ID = V.APPLICATION_ID UNION/* Default Values */ Select B.MAPPING_SET_CODE Mapping_Set_Code, B.AMB_CONTEXT_CODE AMB_Context_Code, F.DEFAULT_CONSTANT Value_Constant, F.DEFAULT_CCID Value_Code_Combination_ID, TO_DATE('01-01-1951', 'DD-MM-YYYY') Effective_Date_From, Null Effective_Date_To, B.ENABLED_FLAG Enabled_Flag, 'D' Input_Value_Type_Code, Null Input_Value_Constant1, Null Input_Value_Constant2, Null Input_Value_Constant3, Null Input_Value_Constant4, Null Input_Value_Constant5, Null Input_Value_Constant6, Null Input_Value_Constant7, Null Input_Value_Constant8, Null Input_Value_Constant9, Null Input_Value_Constant10, Null Concat_Input, 99 Map_Prec, F.STRIPE_ID Flavor_ID, DECODE(B.FLEXFIELD_ASSIGN_MODE_CODE, 'V', 'V', 'C') Stripe_Type_Code, -1 input_coa_id from XLA_MAPPING_SETS_B B, XLA_MAPPING_SET_FLAVORS F where B.MAPPING_SET_CODE = F.MAPPING_SET_CODE and B.AMB_CONTEXT_CODE = F.AMB_CONTEXT_CODE and B.APPLICATION_ID = F.APPLICATION_ID