[Home] [Help] [Dependency Information]
Object Name: | ZX_CONDITION_GROUPS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.ZX_CONDITION_GROUPS_VL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
COUNTRY_CODE | VARCHAR2 | (2) | ||
CONDITION_GROUP_ID | NUMBER | (15) | Yes | |
CONDITION_GROUP_CODE | VARCHAR2 | (50) | Yes | |
DET_FACTOR_TEMPL_CODE | VARCHAR2 | (30) | Yes | |
LEDGER_ID | NUMBER | (15) | ||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | ||
MORE_THAN_MAX_COND_FLAG | VARCHAR2 | (1) | Yes | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
CONSTRAINT_ID | NUMBER | (15) | ||
DETERMINING_FACTOR_CODE1 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE1 | VARCHAR2 | (50) | ||
DATA_TYPE1_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS1_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ1_CODE | VARCHAR2 | (30) | ||
OPERATOR1_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE1 | NUMBER | |||
DATE_VALUE1 | DATE | |||
ALPHANUMERIC_VALUE1 | VARCHAR2 | (150) | ||
VALUE_LOW1 | VARCHAR2 | (1000) | ||
VALUE_HIGH1 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE2 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE2 | VARCHAR2 | (50) | ||
DATA_TYPE2_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS2_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ2_CODE | VARCHAR2 | (30) | ||
OPERATOR2_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE2 | NUMBER | |||
DATE_VALUE2 | DATE | |||
ALPHANUMERIC_VALUE2 | VARCHAR2 | (150) | ||
VALUE_LOW2 | VARCHAR2 | (1000) | ||
VALUE_HIGH2 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE3 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE3 | VARCHAR2 | (50) | ||
DATA_TYPE3_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS3_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ3_CODE | VARCHAR2 | (30) | ||
OPERATOR3_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE3 | NUMBER | |||
DATE_VALUE3 | DATE | |||
ALPHANUMERIC_VALUE3 | VARCHAR2 | (150) | ||
VALUE_LOW3 | VARCHAR2 | (1000) | ||
VALUE_HIGH3 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE4 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE4 | VARCHAR2 | (50) | ||
DATA_TYPE4_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS4_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ4_CODE | VARCHAR2 | (30) | ||
OPERATOR4_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE4 | NUMBER | |||
DATE_VALUE4 | DATE | |||
ALPHANUMERIC_VALUE4 | VARCHAR2 | (150) | ||
VALUE_LOW4 | VARCHAR2 | (1000) | ||
VALUE_HIGH4 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE5 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE5 | VARCHAR2 | (50) | ||
DATA_TYPE5_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS5_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ5_CODE | VARCHAR2 | (30) | ||
OPERATOR5_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE5 | NUMBER | |||
DATE_VALUE5 | DATE | |||
ALPHANUMERIC_VALUE5 | VARCHAR2 | (150) | ||
VALUE_LOW5 | VARCHAR2 | (1000) | ||
VALUE_HIGH5 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE6 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE6 | VARCHAR2 | (50) | ||
DATA_TYPE6_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS6_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ6_CODE | VARCHAR2 | (30) | ||
OPERATOR6_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE6 | NUMBER | |||
DATE_VALUE6 | DATE | |||
ALPHANUMERIC_VALUE6 | VARCHAR2 | (150) | ||
VALUE_LOW6 | VARCHAR2 | (1000) | ||
VALUE_HIGH6 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE7 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE7 | VARCHAR2 | (50) | ||
DATA_TYPE7_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS7_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ7_CODE | VARCHAR2 | (30) | ||
OPERATOR7_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE7 | NUMBER | |||
DATE_VALUE7 | DATE | |||
ALPHANUMERIC_VALUE7 | VARCHAR2 | (150) | ||
VALUE_LOW7 | VARCHAR2 | (1000) | ||
VALUE_HIGH7 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE8 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE8 | VARCHAR2 | (50) | ||
DATA_TYPE8_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS8_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ8_CODE | VARCHAR2 | (30) | ||
OPERATOR8_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE8 | NUMBER | |||
DATE_VALUE8 | DATE | |||
ALPHANUMERIC_VALUE8 | VARCHAR2 | (150) | ||
VALUE_LOW8 | VARCHAR2 | (1000) | ||
VALUE_HIGH8 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE9 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE9 | VARCHAR2 | (50) | ||
DATA_TYPE9_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLASS9_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ9_CODE | VARCHAR2 | (30) | ||
OPERATOR9_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE9 | NUMBER | |||
DATE_VALUE9 | DATE | |||
ALPHANUMERIC_VALUE9 | VARCHAR2 | (150) | ||
VALUE_LOW9 | VARCHAR2 | (1000) | ||
VALUE_HIGH9 | VARCHAR2 | (1000) | ||
DETERMINING_FACTOR_CODE10 | VARCHAR2 | (30) | ||
TAX_PARAMETER_CODE10 | VARCHAR2 | (50) | ||
DATA_TYPE10_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CLAS10_CODE | VARCHAR2 | (30) | ||
DETERMINING_FACTOR_CQ10_CODE | VARCHAR2 | (30) | ||
OPERATOR10_CODE | VARCHAR2 | (30) | ||
NUMERIC_VALUE10 | NUMBER | |||
DATE_VALUE10 | DATE | |||
ALPHANUMERIC_VALUE10 | VARCHAR2 | (150) | ||
VALUE_LOW10 | VARCHAR2 | (1000) | ||
VALUE_HIGH10 | VARCHAR2 | (1000) | ||
CREATION_DATE | DATE | Yes | ||
RECORD_TYPE_CODE | VARCHAR2 | (30) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
CONDITION_GROUP_NAME | VARCHAR2 | (80) | Yes | |
CONDITION_GROUP_DESC | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, 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
, CONDITION_GROUP_NAME
, CONDITION_GROUP_DESC
FROM APPS.ZX_CONDITION_GROUPS_VL;
|
|
|