[Home] [Help] [Dependency Information]
Object Name: | ECX_TRAN_STAGE_DATA# |
---|---|
Object Type: | VIEW |
Owner: | ECX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSTAGE_ID | NUMBER | Yes | ||
SOURCE_LEVEL_ID | NUMBER | |||
STAGE | NUMBER | |||
SEQ_NUMBER | NUMBER | |||
ACTION_TYPE | NUMBER | |||
VARIABLE_LEVEL | NUMBER | |||
VARIABLE_NAME | VARCHAR2 | (255) | ||
VARIABLE_VALUE | VARCHAR2 | (2000) | ||
DEFAULT_VALUE | VARCHAR2 | (2000) | ||
SEQUENCE_NAME | VARCHAR2 | (255) | ||
CUSTOM_PROCEDURE_NAME | VARCHAR2 | (255) | ||
DATA_TYPE | NUMBER | (15) | ||
FUNCTION_NAME | VARCHAR2 | (255) | ||
WHERE_CLAUSE | VARCHAR2 | (2000) | ||
VARIABLE_POS | NUMBER | |||
MAP_ID | NUMBER | Yes | ||
OBJECTLEVEL_ID | NUMBER | Yes | ||
OBJECT_DIRECTION | VARCHAR2 | (1) | ||
VARIABLE_DIRECTION | VARCHAR2 | (1) | ||
ACTION_POS | NUMBER | |||
COND_LOGICAL_OPERATOR | VARCHAR2 | (10) | ||
COND_OPERATOR1 | VARCHAR2 | (20) | ||
COND_VAR1_LEVEL | NUMBER | (15) | ||
COND_VAR1_NAME | VARCHAR2 | (240) | ||
COND_VAR1_POS | NUMBER | (15) | ||
COND_VAR1_DIRECTION | VARCHAR2 | (20) | ||
COND_VAR1_CONSTANT | VARCHAR2 | (2000) | ||
COND_OPERATOR2 | VARCHAR2 | (240) | ||
COND_VAR2_LEVEL | NUMBER | (15) | ||
COND_VAR2_NAME | VARCHAR2 | (240) | ||
COND_VAR2_POS | NUMBER | (15) | ||
COND_VAR2_DIRECTION | VARCHAR2 | (20) | ||
COND_VAR2_CONSTANT | VARCHAR2 | (2000) | ||
COND_VAL1_LEVEL | NUMBER | (15) | ||
COND_VAL1_NAME | VARCHAR2 | (240) | ||
COND_VAL1_POS | NUMBER | (15) | ||
COND_VAL1_DIRECTION | VARCHAR2 | (20) | ||
COND_VAL1_CONSTANT | VARCHAR2 | (2000) | ||
COND_VAL2_LEVEL | NUMBER | (15) | ||
COND_VAL2_NAME | VARCHAR2 | (240) | ||
COND_VAL2_POS | NUMBER | (15) | ||
COND_VAL2_DIRECTION | VARCHAR2 | (20) | ||
COND_VAL2_CONSTANT | VARCHAR2 | (2000) | ||
OPERAND1_LEVEL | NUMBER | (15) | ||
OPERAND1_NAME | VARCHAR2 | (240) | ||
OPERAND1_POS | NUMBER | (15) | ||
OPERAND1_DIRECTION | VARCHAR2 | (20) | ||
OPERAND1_CONSTANT | VARCHAR2 | (2000) | ||
OPERAND1_START_POS | NUMBER | (15) | ||
OPERAND1_LEN | NUMBER | (15) | ||
OPERAND2_NAME | VARCHAR2 | (240) | ||
OPERAND2_LEVEL | NUMBER | (15) | ||
OPERAND2_POS | NUMBER | (15) | ||
OPERAND2_DIRECTION | VARCHAR2 | (20) | ||
OPERAND2_CONSTANT | VARCHAR2 | (2000) | ||
OPERAND3_LEVEL | NUMBER | (15) | ||
OPERAND3_NAME | VARCHAR2 | (240) | ||
OPERAND3_POS | NUMBER | (15) | ||
OPERAND3_DIRECTION | VARCHAR2 | (20) | ||
OPERAND3_CONSTANT | VARCHAR2 | (2000) | ||
OPERAND4_LEVEL | NUMBER | (15) | ||
OPERAND4_NAME | VARCHAR2 | (240) | ||
OPERAND4_POS | NUMBER | (15) | ||
OPERAND4_DIRECTION | VARCHAR2 | (20) | ||
OPERAND4_CONSTANT | VARCHAR2 | (2000) | ||
OPERAND5_LEVEL | NUMBER | (15) | ||
OPERAND5_NAME | VARCHAR2 | (240) | ||
OPERAND5_POS | NUMBER | (15) | ||
OPERAND5_DIRECTION | VARCHAR2 | (20) | ||
OPERAND5_CONSTANT | VARCHAR2 | (2000) | ||
OPERAND6_LEVEL | NUMBER | (15) | ||
OPERAND6_NAME | VARCHAR2 | (240) | ||
OPERAND6_POS | NUMBER | (15) | ||
OPERAND6_DIRECTION | VARCHAR2 | (20) | ||
OPERAND6_CONSTANT | VARCHAR2 | (2000) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSTAGE_ID
, SOURCE_LEVEL_ID
, STAGE
, SEQ_NUMBER
, ACTION_TYPE
, VARIABLE_LEVEL
, VARIABLE_NAME
, VARIABLE_VALUE
, DEFAULT_VALUE
, SEQUENCE_NAME
, CUSTOM_PROCEDURE_NAME
, DATA_TYPE
, FUNCTION_NAME
, WHERE_CLAUSE
, VARIABLE_POS
, MAP_ID
, OBJECTLEVEL_ID
, OBJECT_DIRECTION
, VARIABLE_DIRECTION
, ACTION_POS
, COND_LOGICAL_OPERATOR
, COND_OPERATOR1
, COND_VAR1_LEVEL
, COND_VAR1_NAME
, COND_VAR1_POS
, COND_VAR1_DIRECTION
, COND_VAR1_CONSTANT
, COND_OPERATOR2
, COND_VAR2_LEVEL
, COND_VAR2_NAME
, COND_VAR2_POS
, COND_VAR2_DIRECTION
, COND_VAR2_CONSTANT
, COND_VAL1_LEVEL
, COND_VAL1_NAME
, COND_VAL1_POS
, COND_VAL1_DIRECTION
, COND_VAL1_CONSTANT
, COND_VAL2_LEVEL
, COND_VAL2_NAME
, COND_VAL2_POS
, COND_VAL2_DIRECTION
, COND_VAL2_CONSTANT
, OPERAND1_LEVEL
, OPERAND1_NAME
, OPERAND1_POS
, OPERAND1_DIRECTION
, OPERAND1_CONSTANT
, OPERAND1_START_POS
, OPERAND1_LEN
, OPERAND2_NAME
, OPERAND2_LEVEL
, OPERAND2_POS
, OPERAND2_DIRECTION
, OPERAND2_CONSTANT
, OPERAND3_LEVEL
, OPERAND3_NAME
, OPERAND3_POS
, OPERAND3_DIRECTION
, OPERAND3_CONSTANT
, OPERAND4_LEVEL
, OPERAND4_NAME
, OPERAND4_POS
, OPERAND4_DIRECTION
, OPERAND4_CONSTANT
, OPERAND5_LEVEL
, OPERAND5_NAME
, OPERAND5_POS
, OPERAND5_DIRECTION
, OPERAND5_CONSTANT
, OPERAND6_LEVEL
, OPERAND6_NAME
, OPERAND6_POS
, OPERAND6_DIRECTION
, OPERAND6_CONSTANT
, ZD_EDITION_NAME
FROM ECX.ECX_TRAN_STAGE_DATA#;
|
|
|