[Home] [Help] [Dependency Information]
Object Name: | ZX_SIM_CONDITIONS |
---|---|
Object Type: | TABLE |
Owner: | ZX |
FND Design Data: | ZX.ZX_SIM_CONDITIONS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_SIM_CONDITIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRX_ID
TRX_LINE_ID TAX_LINE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SIM_CONDITION_ID | NUMBER | (15) | Yes | Not currently used |
TRX_ID | NUMBER | (15) | Yes | Not currently used |
TRX_LINE_ID | NUMBER | (15) | Yes | Not currently used |
TAX_LINE_NUMBER | NUMBER | (15) | Yes | Not currently used |
DETERMINING_FACTOR_CLASS_CODE | VARCHAR2 | (30) | Yes | Not currently used |
DETERMINING_FACTOR_CODE | VARCHAR2 | (30) | Yes | Not currently used |
DATA_TYPE_CODE | VARCHAR2 | (30) | Yes | Not currently used |
OPERATOR_CODE | VARCHAR2 | (30) | Yes | Not currently used |
TAX_PARAMETER_CODE | VARCHAR2 | (30) | Not currently used | |
DETERMINING_FACTOR_CQ_CODE | VARCHAR2 | (30) | Not currently used | |
NUMERIC_VALUE | NUMBER | Not currently used | ||
DATE_VALUE | DATE | Not currently used | ||
ALPHANUMERIC_VALUE | VARCHAR2 | (1000) | Not currently used | |
VALUE_LOW | VARCHAR2 | (1000) | Not currently used | |
VALUE_HIGH | VARCHAR2 | (1000) | Not currently used | |
APPLICABILITY_FLAG | VARCHAR2 | (1) | Not currently used | |
STATUS_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
DEFAULT_STATUS_CODE | VARCHAR2 | (30) | Not currently used | |
RATE_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
DIRECT_RATE_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
TAXABLE_BASIS_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
CALCULATE_TAX_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
PLACE_OF_SUPPLY_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
REGISTRATION_DETERMINE_FLAG | VARCHAR2 | (1) | Not currently used | |
CREATED_BY | NUMBER | (15) | Yes | Not currently used |
CREATION_DATE | DATE | Yes | Not currently used | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Not currently used |
LAST_UPDATE_DATE | DATE | Yes | Not currently used | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Not currently used |
Cut, paste (and edit) the following text to query this object:
SELECT SIM_CONDITION_ID
, TRX_ID
, TRX_LINE_ID
, TAX_LINE_NUMBER
, DETERMINING_FACTOR_CLASS_CODE
, DETERMINING_FACTOR_CODE
, DATA_TYPE_CODE
, OPERATOR_CODE
, TAX_PARAMETER_CODE
, DETERMINING_FACTOR_CQ_CODE
, NUMERIC_VALUE
, DATE_VALUE
, ALPHANUMERIC_VALUE
, VALUE_LOW
, VALUE_HIGH
, APPLICABILITY_FLAG
, STATUS_DETERMINE_FLAG
, DEFAULT_STATUS_CODE
, RATE_DETERMINE_FLAG
, DIRECT_RATE_DETERMINE_FLAG
, TAXABLE_BASIS_DETERMINE_FLAG
, CALCULATE_TAX_DETERMINE_FLAG
, PLACE_OF_SUPPLY_DETERMINE_FLAG
, REGISTRATION_DETERMINE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM ZX.ZX_SIM_CONDITIONS;
ZX.ZX_SIM_CONDITIONS does not reference any database object
ZX.ZX_SIM_CONDITIONS is referenced by following:
|
|
|