[Home] [Help]
SELECT B.ROWID ROW_ID
,B.LAST_UPDATED_BY
,B.LAST_UPDATE_DATE
,B.LAST_UPDATE_LOGIN
,B.REQUEST_ID
,B.PROGRAM_APPLICATION_ID
,B.PROGRAM_ID
,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
,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')
SELECT B.ROWID ROW_ID
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, 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
, 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')
|
|
|
|