VIEW: ZX.ZX_CONDITION_GROUPS_B#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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