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

VIEW: ZX.ZX_CONDITIONS#

Object Details
Object Name: ZX_CONDITIONS#
Object Type: VIEW
Owner: ZX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DETERMINING_FACTOR_CODE VARCHAR2 (30) Yes
CONDITION_GROUP_CODE VARCHAR2 (50) Yes
TAX_PARAMETER_CODE VARCHAR2 (30)
DATA_TYPE_CODE VARCHAR2 (30) Yes
DETERMINING_FACTOR_CLASS_CODE VARCHAR2 (30) Yes
DETERMINING_FACTOR_CQ_CODE VARCHAR2 (30)
OPERATOR_CODE VARCHAR2 (30) Yes
RECORD_TYPE_CODE VARCHAR2 (30) Yes
IGNORE_FLAG VARCHAR2 (1) Yes
NUMERIC_VALUE NUMBER

DATE_VALUE DATE

ALPHANUMERIC_VALUE VARCHAR2 (1000)
VALUE_LOW VARCHAR2 (1000)
VALUE_HIGH VARCHAR2 (1000)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

CONDITION_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DETERMINING_FACTOR_CODE
,      CONDITION_GROUP_CODE
,      TAX_PARAMETER_CODE
,      DATA_TYPE_CODE
,      DETERMINING_FACTOR_CLASS_CODE
,      DETERMINING_FACTOR_CQ_CODE
,      OPERATOR_CODE
,      RECORD_TYPE_CODE
,      IGNORE_FLAG
,      NUMERIC_VALUE
,      DATE_VALUE
,      ALPHANUMERIC_VALUE
,      VALUE_LOW
,      VALUE_HIGH
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      CONDITION_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM ZX.ZX_CONDITIONS#;

Dependencies

[top of page]

ZX.ZX_CONDITIONS# references the following:

SchemaZX
TableZX_CONDITIONS
ZX.ZX_CONDITIONS# is referenced by following:

SchemaAPPS
SynonymZX_CONDITIONS