ZX_CONDITION_GROUPS_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID COUNTRY_CODE CONDITION_GROUP_ID CONDITION_GROUP_CODE DET_FACTOR_TEMPL_CODE LEDGER_ID CHART_OF_ACCOUNTS_ID MORE_THAN_MAX_COND_FLAG ENABLED_FLAG CONSTRAINT_ID DETERMINING_FACTOR_CODE1 TAX_PARAMETER_CODE1 DATA_TYPE1_CODE DETERMINING_FACTOR_CLASS1_CODE DETERMINING_FACTOR_CQ1_CODE OPERATOR1_CODE NUMERIC_VALUE1 DATE_VALUE1 ALPHANUMERIC_VALUE1 VALUE_LOW1 VALUE_HIGH1 DETERMINING_FACTOR_CODE2 TAX_PARAMETER_CODE2 DATA_TYPE2_CODE DETERMINING_FACTOR_CLASS2_CODE DETERMINING_FACTOR_CQ2_CODE OPERATOR2_CODE NUMERIC_VALUE2 DATE_VALUE2 ALPHANUMERIC_VALUE2 VALUE_LOW2 VALUE_HIGH2 DETERMINING_FACTOR_CODE3 TAX_PARAMETER_CODE3 DATA_TYPE3_CODE DETERMINING_FACTOR_CLASS3_CODE DETERMINING_FACTOR_CQ3_CODE OPERATOR3_CODE NUMERIC_VALUE3 DATE_VALUE3 ALPHANUMERIC_VALUE3 VALUE_LOW3 VALUE_HIGH3 DETERMINING_FACTOR_CODE4 TAX_PARAMETER_CODE4 DATA_TYPE4_CODE DETERMINING_FACTOR_CLASS4_CODE DETERMINING_FACTOR_CQ4_CODE OPERATOR4_CODE NUMERIC_VALUE4 DATE_VALUE4 ALPHANUMERIC_VALUE4 VALUE_LOW4 VALUE_HIGH4 DETERMINING_FACTOR_CODE5 TAX_PARAMETER_CODE5 DATA_TYPE5_CODE DETERMINING_FACTOR_CLASS5_CODE DETERMINING_FACTOR_CQ5_CODE OPERATOR5_CODE NUMERIC_VALUE5 DATE_VALUE5 ALPHANUMERIC_VALUE5 VALUE_LOW5 VALUE_HIGH5 DETERMINING_FACTOR_CODE6 TAX_PARAMETER_CODE6 DATA_TYPE6_CODE DETERMINING_FACTOR_CLASS6_CODE DETERMINING_FACTOR_CQ6_CODE OPERATOR6_CODE NUMERIC_VALUE6 DATE_VALUE6 ALPHANUMERIC_VALUE6 VALUE_LOW6 VALUE_HIGH6 DETERMINING_FACTOR_CODE7 TAX_PARAMETER_CODE7 DATA_TYPE7_CODE DETERMINING_FACTOR_CLASS7_CODE DETERMINING_FACTOR_CQ7_CODE OPERATOR7_CODE NUMERIC_VALUE7 DATE_VALUE7 ALPHANUMERIC_VALUE7 VALUE_LOW7 VALUE_HIGH7 DETERMINING_FACTOR_CODE8 TAX_PARAMETER_CODE8 DATA_TYPE8_CODE DETERMINING_FACTOR_CLASS8_CODE DETERMINING_FACTOR_CQ8_CODE OPERATOR8_CODE NUMERIC_VALUE8 DATE_VALUE8 ALPHANUMERIC_VALUE8 VALUE_LOW8 VALUE_HIGH8 DETERMINING_FACTOR_CODE9 TAX_PARAMETER_CODE9 DATA_TYPE9_CODE DETERMINING_FACTOR_CLASS9_CODE DETERMINING_FACTOR_CQ9_CODE OPERATOR9_CODE NUMERIC_VALUE9 DATE_VALUE9 ALPHANUMERIC_VALUE9 VALUE_LOW9 VALUE_HIGH9 DETERMINING_FACTOR_CODE10 TAX_PARAMETER_CODE10 DATA_TYPE10_CODE DETERMINING_FACTOR_CLAS10_CODE DETERMINING_FACTOR_CQ10_CODE OPERATOR10_CODE NUMERIC_VALUE10 DATE_VALUE10 ALPHANUMERIC_VALUE10 VALUE_LOW10 VALUE_HIGH10 CREATION_DATE RECORD_TYPE_CODE CREATED_BY OBJECT_VERSION_NUMBER FLEX_FILTER_VALUE CONDITION_GROUP_NAME CONDITION_GROUP_DESC

Query

SQL_Statement

SELECT B.ROWID ROW_ID ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.REQUEST_ID ,B.PROGRAM_APP_NAME ,B.PROGRAM_NAME ,B.PROGRAM_LOGIN_ID ,B.COUNTRY_CODE ,B.CONDITION_GROUP_ID ,B.CONDITION_GROUP_CODE ,B.DET_FACTOR_TEMPL_CODE ,B.LEDGER_ID ,B.CHART_OF_ACCOUNTS_ID ,B.MORE_THAN_MAX_COND_FLAG ,B.ENABLED_FLAG ,B.CONSTRAINT_ID ,B.DETERMINING_FACTOR_CODE1 ,B.TAX_PARAMETER_CODE1 ,B.DATA_TYPE1_CODE ,B.DETERMINING_FACTOR_CLASS1_CODE ,B.DETERMINING_FACTOR_CQ1_CODE ,B.OPERATOR1_CODE ,B.NUMERIC_VALUE1 ,B.DATE_VALUE1 ,B.ALPHANUMERIC_VALUE1 ,B.VALUE_LOW1 ,B.VALUE_HIGH1 ,B.DETERMINING_FACTOR_CODE2 ,B.TAX_PARAMETER_CODE2 ,B.DATA_TYPE2_CODE ,B.DETERMINING_FACTOR_CLASS2_CODE ,B.DETERMINING_FACTOR_CQ2_CODE ,B.OPERATOR2_CODE ,B.NUMERIC_VALUE2 ,B.DATE_VALUE2 ,B.ALPHANUMERIC_VALUE2 ,B.VALUE_LOW2 ,B.VALUE_HIGH2 ,B.DETERMINING_FACTOR_CODE3 ,B.TAX_PARAMETER_CODE3 ,B.DATA_TYPE3_CODE ,B.DETERMINING_FACTOR_CLASS3_CODE ,B.DETERMINING_FACTOR_CQ3_CODE ,B.OPERATOR3_CODE ,B.NUMERIC_VALUE3 ,B.DATE_VALUE3 ,B.ALPHANUMERIC_VALUE3 ,B.VALUE_LOW3 ,B.VALUE_HIGH3 ,B.DETERMINING_FACTOR_CODE4 ,B.TAX_PARAMETER_CODE4 ,B.DATA_TYPE4_CODE ,B.DETERMINING_FACTOR_CLASS4_CODE ,B.DETERMINING_FACTOR_CQ4_CODE ,B.OPERATOR4_CODE ,B.NUMERIC_VALUE4 ,B.DATE_VALUE4 ,B.ALPHANUMERIC_VALUE4 ,B.VALUE_LOW4 ,B.VALUE_HIGH4 ,B.DETERMINING_FACTOR_CODE5 ,B.TAX_PARAMETER_CODE5 ,B.DATA_TYPE5_CODE ,B.DETERMINING_FACTOR_CLASS5_CODE ,B.DETERMINING_FACTOR_CQ5_CODE ,B.OPERATOR5_CODE ,B.NUMERIC_VALUE5 ,B.DATE_VALUE5 ,B.ALPHANUMERIC_VALUE5 ,B.VALUE_LOW5 ,B.VALUE_HIGH5 ,B.DETERMINING_FACTOR_CODE6 ,B.TAX_PARAMETER_CODE6 ,B.DATA_TYPE6_CODE ,B.DETERMINING_FACTOR_CLASS6_CODE ,B.DETERMINING_FACTOR_CQ6_CODE ,B.OPERATOR6_CODE ,B.NUMERIC_VALUE6 ,B.DATE_VALUE6 ,B.ALPHANUMERIC_VALUE6 ,B.VALUE_LOW6 ,B.VALUE_HIGH6 ,B.DETERMINING_FACTOR_CODE7 ,B.TAX_PARAMETER_CODE7 ,B.DATA_TYPE7_CODE ,B.DETERMINING_FACTOR_CLASS7_CODE ,B.DETERMINING_FACTOR_CQ7_CODE ,B.OPERATOR7_CODE ,B.NUMERIC_VALUE7 ,B.DATE_VALUE7 ,B.ALPHANUMERIC_VALUE7 ,B.VALUE_LOW7 ,B.VALUE_HIGH7 ,B.DETERMINING_FACTOR_CODE8 ,B.TAX_PARAMETER_CODE8 ,B.DATA_TYPE8_CODE ,B.DETERMINING_FACTOR_CLASS8_CODE ,B.DETERMINING_FACTOR_CQ8_CODE ,B.OPERATOR8_CODE ,B.NUMERIC_VALUE8 ,B.DATE_VALUE8 ,B.ALPHANUMERIC_VALUE8 ,B.VALUE_LOW8 ,B.VALUE_HIGH8 ,B.DETERMINING_FACTOR_CODE9 ,B.TAX_PARAMETER_CODE9 ,B.DATA_TYPE9_CODE ,B.DETERMINING_FACTOR_CLASS9_CODE ,B.DETERMINING_FACTOR_CQ9_CODE ,B.OPERATOR9_CODE ,B.NUMERIC_VALUE9 ,B.DATE_VALUE9 ,B.ALPHANUMERIC_VALUE9 ,B.VALUE_LOW9 ,B.VALUE_HIGH9 ,B.DETERMINING_FACTOR_CODE10 ,B.TAX_PARAMETER_CODE10 ,B.DATA_TYPE10_CODE ,B.DETERMINING_FACTOR_CLAS10_CODE ,B.DETERMINING_FACTOR_CQ10_CODE ,B.OPERATOR10_CODE ,B.NUMERIC_VALUE10 ,B.DATE_VALUE10 ,B.ALPHANUMERIC_VALUE10 ,B.VALUE_LOW10 ,B.VALUE_HIGH10 ,B.CREATION_DATE ,B.RECORD_TYPE_CODE ,B.CREATED_BY ,B.OBJECT_VERSION_NUMBER ,B.FLEX_FILTER_VALUE ,T.CONDITION_GROUP_NAME ,T.CONDITION_GROUP_DESC FROM ZX_CONDITION_GROUPS_TL T, ZX_CONDITION_GROUPS_B B WHERE B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID AND T.LANGUAGE = userenv('LANG')