[Home] [Help] [Dependency Information]
Object Name: | ZX_CONDITION_GROUPS_B |
---|---|
Object Type: | TABLE |
Owner: | ZX |
FND Design Data: | ZX.ZX_CONDITION_GROUPS_B |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_CONDITION_GROUPS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CONDITION_GROUP_ID |
ZX_CONDITION_GROUPS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CONDITION_GROUP_CODE
CONSTRAINT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONDITION_GROUP_CODE | VARCHAR2 | (50) | Yes | Condition group code |
DET_FACTOR_TEMPL_CODE | VARCHAR2 | (30) | Yes | Determining factor template code |
COUNTRY_CODE | VARCHAR2 | (2) | Country code for which the condition group is defined. This is NULL for condition groups that are generic for all countries. | |
MORE_THAN_MAX_COND_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether the Condition Group has more than 10 conditions |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates if the Condition Group is enabled or disabled |
DETERMINING_FACTOR_CODE1 | VARCHAR2 | (30) | Determining factor code for first condition | |
TAX_PARAMETER_CODE1 | VARCHAR2 | (50) | Tax parameter code for the determining factor of first condition | |
DATA_TYPE1_CODE | VARCHAR2 | (30) | Data type of the determining factor for first condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS1_CODE | VARCHAR2 | (30) | Determining factor class code for first condition | |
DETERMINING_FACTOR_CQ1_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for first condition. This is a sub classification of the determining factor class. | |
OPERATOR1_CODE | VARCHAR2 | (30) | Operator used for defining first condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE1 | NUMBER | Column for recording the numeric value to be compared with the determining factor for first condition | ||
DATE_VALUE1 | DATE | Column for recording the date value to be compared with the determining factor for first condition | ||
ALPHANUMERIC_VALUE1 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for first condition | |
VALUE_LOW1 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for first condition, when operator is BETWEEN | |
VALUE_HIGH1 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for first condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE2 | VARCHAR2 | (30) | Determining factor code for second condition | |
TAX_PARAMETER_CODE2 | VARCHAR2 | (50) | Tax parameter code for the determining factor of second condition | |
DATA_TYPE2_CODE | VARCHAR2 | (30) | Data type of the determining factor for second condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS2_CODE | VARCHAR2 | (30) | Determining factor class code for second condition | |
DETERMINING_FACTOR_CQ2_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for second condition. This is a sub classification of the determining factor class. | |
OPERATOR2_CODE | VARCHAR2 | (30) | Operator used for defining second condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE2 | NUMBER | Column for recording the numeric value to be compared with the determining factor for second condition | ||
DATE_VALUE2 | DATE | Column for recording the date value to be compared with the determining factor for second condition | ||
ALPHANUMERIC_VALUE2 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for second condition | |
VALUE_LOW2 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for second condition, when operator is BETWEEN | |
VALUE_HIGH2 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for second condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE3 | VARCHAR2 | (30) | Determining factor code for third condition | |
TAX_PARAMETER_CODE3 | VARCHAR2 | (50) | Tax parameter code for the determining factor of third condition | |
DATA_TYPE3_CODE | VARCHAR2 | (30) | Data type of the determining factor for third condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS3_CODE | VARCHAR2 | (30) | Determining factor class code for third condition | |
DETERMINING_FACTOR_CQ3_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for third condition. This is a sub classification of the determining factor class. | |
OPERATOR3_CODE | VARCHAR2 | (30) | Operator used for defining third condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE3 | NUMBER | Column for recording the numeric value to be compared with the determining factor for third condition | ||
DATE_VALUE3 | DATE | Column for recording the date value to be compared with the determining factor for third condition | ||
ALPHANUMERIC_VALUE3 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for third condition | |
VALUE_LOW3 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for third condition, when operator is BETWEEN | |
VALUE_HIGH3 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for third condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE4 | VARCHAR2 | (30) | Determining factor code for fourth condition | |
TAX_PARAMETER_CODE4 | VARCHAR2 | (50) | Tax parameter code for the determining factor of fourth condition | |
DATA_TYPE4_CODE | VARCHAR2 | (30) | Data type of the determining factor for fourth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS4_CODE | VARCHAR2 | (30) | Determining factor class code for fourth condition | |
DETERMINING_FACTOR_CQ4_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for fourth condition. This is a sub classification of the determining factor class. | |
OPERATOR4_CODE | VARCHAR2 | (30) | Operator used for defining fourth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE4 | NUMBER | Column for recording the numeric value to be compared with the determining factor for fourth condition | ||
DATE_VALUE4 | DATE | Column for recording the date value to be compared with the determining factor for fourth condition | ||
ALPHANUMERIC_VALUE4 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for fourth condition | |
VALUE_LOW4 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for fourth condition, when operator is BETWEEN | |
VALUE_HIGH4 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for fourth condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE5 | VARCHAR2 | (30) | Determining factor code for fifth condition | |
TAX_PARAMETER_CODE5 | VARCHAR2 | (50) | Tax parameter code for the determining factor of fifth condition | |
DATA_TYPE5_CODE | VARCHAR2 | (30) | Data type of the determining factor for fifth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS5_CODE | VARCHAR2 | (30) | Determining factor class code for fifth condition | |
DETERMINING_FACTOR_CQ5_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for fifth condition. This is a sub classification of the determining factor class. | |
OPERATOR5_CODE | VARCHAR2 | (30) | Operator used for defining fifth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE5 | NUMBER | Column for recording the numeric value to be compared with the determining factor for fifth condition | ||
DATE_VALUE5 | DATE | Column for recording the date value to be compared with the determining factor for fifth condition | ||
ALPHANUMERIC_VALUE5 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for fifth condition | |
VALUE_LOW5 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for fifth condition, when operator is BETWEEN | |
VALUE_HIGH5 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for fifth condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE6 | VARCHAR2 | (30) | Determining factor code for sixth condition | |
TAX_PARAMETER_CODE6 | VARCHAR2 | (50) | Tax parameter code for the determining factor of sixth condition | |
DATA_TYPE6_CODE | VARCHAR2 | (30) | Data type of the determining factor for sixth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS6_CODE | VARCHAR2 | (30) | Determining factor class code for sixth condition | |
DETERMINING_FACTOR_CQ6_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for sixth condition. This is a sub classification of the determining factor class. | |
OPERATOR6_CODE | VARCHAR2 | (30) | Operator used for defining sixth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE6 | NUMBER | Column for recording the numeric value to be compared with the determining factor for sixth condition | ||
DATE_VALUE6 | DATE | Column for recording the date value to be compared with the determining factor for sixth condition | ||
ALPHANUMERIC_VALUE6 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for sixth condition | |
VALUE_LOW6 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for sixth condition, when operator is BETWEEN | |
VALUE_HIGH6 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for sixth condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE7 | VARCHAR2 | (30) | Determining factor code for seventh condition | |
TAX_PARAMETER_CODE7 | VARCHAR2 | (50) | Tax parameter code for the determining factor of seventh condition | |
DATA_TYPE7_CODE | VARCHAR2 | (30) | Data type of the determining factor for seventh condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS7_CODE | VARCHAR2 | (30) | Determining factor class code for seventh condition | |
DETERMINING_FACTOR_CQ7_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for seventh condition. This is a sub classification of the determining factor class. | |
OPERATOR7_CODE | VARCHAR2 | (30) | Operator used for defining seventh condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE7 | NUMBER | Column for recording the numeric value to be compared with the determining factor for seventh condition | ||
DATE_VALUE7 | DATE | Column for recording the date value to be compared with the determining factor for seventh condition | ||
ALPHANUMERIC_VALUE7 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for seventh condition | |
VALUE_LOW7 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for seventh condition, when operator is BETWEEN | |
VALUE_HIGH7 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for seventh condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE8 | VARCHAR2 | (30) | Determining factor code for eighth condition | |
TAX_PARAMETER_CODE8 | VARCHAR2 | (50) | Tax parameter code for the determining factor of eighth condition | |
DATA_TYPE8_CODE | VARCHAR2 | (30) | Data type of the determining factor for eighth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS8_CODE | VARCHAR2 | (30) | Determining factor class code for eighth condition | |
DETERMINING_FACTOR_CQ8_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for eighth condition. This is a sub classification of the determining factor class. | |
OPERATOR8_CODE | VARCHAR2 | (30) | Operator used for defining eighth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE8 | NUMBER | Column for recording the numeric value to be compared with the determining factor for eighth condition | ||
DATE_VALUE8 | DATE | Column for recording the date value to be compared with the determining factor for eighth condition | ||
ALPHANUMERIC_VALUE8 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for eighth condition | |
VALUE_LOW8 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for eighth condition, when operator is BETWEEN | |
VALUE_HIGH8 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for eighth condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE9 | VARCHAR2 | (30) | Determining factor code for ninth condition | |
TAX_PARAMETER_CODE9 | VARCHAR2 | (50) | Tax parameter code for the determining factor of ninth condition | |
DATA_TYPE9_CODE | VARCHAR2 | (30) | Data type of the determining factor for ninth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLASS9_CODE | VARCHAR2 | (30) | Determining factor class code for ninth condition | |
DETERMINING_FACTOR_CQ9_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for ninth condition. This is a sub classification of the determining factor class. | |
OPERATOR9_CODE | VARCHAR2 | (30) | Operator used for defining ninth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE9 | NUMBER | Column for recording the numeric value to be compared with the determining factor for ninth condition | ||
DATE_VALUE9 | DATE | Column for recording the date value to be compared with the determining factor for ninth condition | ||
ALPHANUMERIC_VALUE9 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for ninth condition | |
VALUE_LOW9 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for ninth condition, when operator is BETWEEN | |
VALUE_HIGH9 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for ninth condition, when operator is BETWEEN | |
DETERMINING_FACTOR_CODE10 | VARCHAR2 | (30) | Determining factor code for tenth condition | |
TAX_PARAMETER_CODE10 | VARCHAR2 | (50) | Tax parameter code for the determining factor of tenth condition | |
DATA_TYPE10_CODE | VARCHAR2 | (30) | Data type of the determining factor for tenth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | |
DETERMINING_FACTOR_CLAS10_CODE | VARCHAR2 | (30) | Determining factor class code for tenth condition | |
DETERMINING_FACTOR_CQ10_CODE | VARCHAR2 | (30) | Determining factor class qualifier code for tenth condition. This is a sub classification of the determining factor class. | |
OPERATOR10_CODE | VARCHAR2 | (30) | Operator used for defining tenth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | |
NUMERIC_VALUE10 | NUMBER | Column for recording the numeric value to be compared with the determining factor for tenth condition | ||
DATE_VALUE10 | DATE | Column for recording the date value to be compared with the determining factor for tenth condition | ||
ALPHANUMERIC_VALUE10 | VARCHAR2 | (150) | Column for recording the alphanumeric value to be compared with the determining factor for tenth condition | |
VALUE_LOW10 | VARCHAR2 | (1000) | Column for recording the lowest value in the range to be compared with the determining factor for tenth condition, when operator is BETWEEN | |
VALUE_HIGH10 | VARCHAR2 | (1000) | Column for recording the highest value in the range to be compared with the determining factor for tenth condition, when operator is BETWEEN | |
RECORD_TYPE_CODE | VARCHAR2 | (30) | Yes | Lookup code to indicate whether the record is migrated, seeded or defined by the user |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update this record | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update this record | ||
PROGRAM_ID | NUMBER | Program identifier of last concurrent program to update this record | ||
CONSTRAINT_ID | NUMBER | (15) | Constraint identifier | |
PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | ||
CONDITION_GROUP_ID | NUMBER | (15) | Yes | Unique identifier |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
LEDGER_ID | NUMBER | (15) | Ledger defining column | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Accounting key flexfield structure defining column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT CONDITION_GROUP_CODE
, DET_FACTOR_TEMPL_CODE
, COUNTRY_CODE
, MORE_THAN_MAX_COND_FLAG
, ENABLED_FLAG
, 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
, RECORD_TYPE_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, CONSTRAINT_ID
, PROGRAM_LOGIN_ID
, CONDITION_GROUP_ID
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LEDGER_ID
, CHART_OF_ACCOUNTS_ID
, OBJECT_VERSION_NUMBER
FROM ZX.ZX_CONDITION_GROUPS_B;
ZX.ZX_CONDITION_GROUPS_B does not reference any database object
ZX.ZX_CONDITION_GROUPS_B is referenced by following:
|
|
|