View: ZX_CONDITION_GROUPS_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_CONDITION_GROUPS_VL

View Text

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')