DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_SIM_CONDITIONS

Object Details
Object Name: ZX_SIM_CONDITIONS
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_SIM_CONDITIONS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_SIM_CONDITIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTAX_LINE_NUMBER
Columns
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
Query Text

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;

Dependencies

[top of page]

ZX.ZX_SIM_CONDITIONS does not reference any database object

ZX.ZX_SIM_CONDITIONS is referenced by following:

SchemaAPPS
SynonymZX_SIM_CONDITIONS