VIEW: ECX.ECX_TRAN_STAGE_DATA#

Source

View Text - Preformatted

select TRANSTAGE_ID TRANSTAGE_ID, SOURCE_LEVEL_ID SOURCE_LEVEL_ID, STAGE STAGE, SEQ_NUMBER SEQ_NUMBER, ACTION_TYPE ACTION_TYPE, VARIABLE_LEVEL VARIABLE_LEVEL, VARIABLE_NAME VARIABLE_NAME, VARIABLE_VALUE VARIABLE_VALUE, DEFAULT_VALUE DEFAULT_VALUE, SEQUENCE_NAME SEQUENCE_NAME, CUSTOM_PROCEDURE_NAME CUSTOM_PROCEDURE_NAME, DATA_TYPE DATA_TYPE, FUNCTION_NAME FUNCTION_NAME, WHERE_CLAUSE WHERE_CLAUSE, VARIABLE_POS VARIABLE_POS, MAP_ID MAP_ID, OBJECTLEVEL_ID OBJECTLEVEL_ID, OBJECT_DIRECTION OBJECT_DIRECTION, VARIABLE_DIRECTION VARIABLE_DIRECTION, ACTION_POS ACTION_POS, COND_LOGICAL_OPERATOR COND_LOGICAL_OPERATOR, COND_OPERATOR1 COND_OPERATOR1, COND_VAR1_LEVEL COND_VAR1_LEVEL, COND_VAR1_NAME COND_VAR1_NAME, COND_VAR1_POS COND_VAR1_POS, COND_VAR1_DIRECTION COND_VAR1_DIRECTION, COND_VAR1_CONSTANT COND_VAR1_CONSTANT, COND_OPERATOR2 COND_OPERATOR2, COND_VAR2_LEVEL COND_VAR2_LEVEL, COND_VAR2_NAME COND_VAR2_NAME, COND_VAR2_POS COND_VAR2_POS, COND_VAR2_DIRECTION COND_VAR2_DIRECTION, COND_VAR2_CONSTANT COND_VAR2_CONSTANT, COND_VAL1_LEVEL COND_VAL1_LEVEL, COND_VAL1_NAME COND_VAL1_NAME, COND_VAL1_POS COND_VAL1_POS, COND_VAL1_DIRECTION COND_VAL1_DIRECTION, COND_VAL1_CONSTANT COND_VAL1_CONSTANT, COND_VAL2_LEVEL COND_VAL2_LEVEL, COND_VAL2_NAME COND_VAL2_NAME, COND_VAL2_POS COND_VAL2_POS, COND_VAL2_DIRECTION COND_VAL2_DIRECTION, COND_VAL2_CONSTANT COND_VAL2_CONSTANT, OPERAND1_LEVEL OPERAND1_LEVEL, OPERAND1_NAME OPERAND1_NAME, OPERAND1_POS OPERAND1_POS, OPERAND1_DIRECTION OPERAND1_DIRECTION, OPERAND1_CONSTANT OPERAND1_CONSTANT, OPERAND1_START_POS OPERAND1_START_POS, OPERAND1_LEN OPERAND1_LEN, OPERAND2_NAME OPERAND2_NAME, OPERAND2_LEVEL OPERAND2_LEVEL, OPERAND2_POS OPERAND2_POS, OPERAND2_DIRECTION OPERAND2_DIRECTION, OPERAND2_CONSTANT OPERAND2_CONSTANT, OPERAND3_LEVEL OPERAND3_LEVEL, OPERAND3_NAME OPERAND3_NAME, OPERAND3_POS OPERAND3_POS, OPERAND3_DIRECTION OPERAND3_DIRECTION, OPERAND3_CONSTANT OPERAND3_CONSTANT, OPERAND4_LEVEL OPERAND4_LEVEL, OPERAND4_NAME OPERAND4_NAME, OPERAND4_POS OPERAND4_POS, OPERAND4_DIRECTION OPERAND4_DIRECTION, OPERAND4_CONSTANT OPERAND4_CONSTANT, OPERAND5_LEVEL OPERAND5_LEVEL, OPERAND5_NAME OPERAND5_NAME, OPERAND5_POS OPERAND5_POS, OPERAND5_DIRECTION OPERAND5_DIRECTION, OPERAND5_CONSTANT OPERAND5_CONSTANT, OPERAND6_LEVEL OPERAND6_LEVEL, OPERAND6_NAME OPERAND6_NAME, OPERAND6_POS OPERAND6_POS, OPERAND6_DIRECTION OPERAND6_DIRECTION, OPERAND6_CONSTANT OPERAND6_CONSTANT, ZD_EDITION_NAME ZD_EDITION_NAME from "ECX"."ECX_TRAN_STAGE_DATA"

View Text - HTML Formatted

SELECT TRANSTAGE_ID TRANSTAGE_ID
, SOURCE_LEVEL_ID SOURCE_LEVEL_ID
, STAGE STAGE
, SEQ_NUMBER SEQ_NUMBER
, ACTION_TYPE ACTION_TYPE
, VARIABLE_LEVEL VARIABLE_LEVEL
, VARIABLE_NAME VARIABLE_NAME
, VARIABLE_VALUE VARIABLE_VALUE
, DEFAULT_VALUE DEFAULT_VALUE
, SEQUENCE_NAME SEQUENCE_NAME
, CUSTOM_PROCEDURE_NAME CUSTOM_PROCEDURE_NAME
, DATA_TYPE DATA_TYPE
, FUNCTION_NAME FUNCTION_NAME
, WHERE_CLAUSE WHERE_CLAUSE
, VARIABLE_POS VARIABLE_POS
, MAP_ID MAP_ID
, OBJECTLEVEL_ID OBJECTLEVEL_ID
, OBJECT_DIRECTION OBJECT_DIRECTION
, VARIABLE_DIRECTION VARIABLE_DIRECTION
, ACTION_POS ACTION_POS
, COND_LOGICAL_OPERATOR COND_LOGICAL_OPERATOR
, COND_OPERATOR1 COND_OPERATOR1
, COND_VAR1_LEVEL COND_VAR1_LEVEL
, COND_VAR1_NAME COND_VAR1_NAME
, COND_VAR1_POS COND_VAR1_POS
, COND_VAR1_DIRECTION COND_VAR1_DIRECTION
, COND_VAR1_CONSTANT COND_VAR1_CONSTANT
, COND_OPERATOR2 COND_OPERATOR2
, COND_VAR2_LEVEL COND_VAR2_LEVEL
, COND_VAR2_NAME COND_VAR2_NAME
, COND_VAR2_POS COND_VAR2_POS
, COND_VAR2_DIRECTION COND_VAR2_DIRECTION
, COND_VAR2_CONSTANT COND_VAR2_CONSTANT
, COND_VAL1_LEVEL COND_VAL1_LEVEL
, COND_VAL1_NAME COND_VAL1_NAME
, COND_VAL1_POS COND_VAL1_POS
, COND_VAL1_DIRECTION COND_VAL1_DIRECTION
, COND_VAL1_CONSTANT COND_VAL1_CONSTANT
, COND_VAL2_LEVEL COND_VAL2_LEVEL
, COND_VAL2_NAME COND_VAL2_NAME
, COND_VAL2_POS COND_VAL2_POS
, COND_VAL2_DIRECTION COND_VAL2_DIRECTION
, COND_VAL2_CONSTANT COND_VAL2_CONSTANT
, OPERAND1_LEVEL OPERAND1_LEVEL
, OPERAND1_NAME OPERAND1_NAME
, OPERAND1_POS OPERAND1_POS
, OPERAND1_DIRECTION OPERAND1_DIRECTION
, OPERAND1_CONSTANT OPERAND1_CONSTANT
, OPERAND1_START_POS OPERAND1_START_POS
, OPERAND1_LEN OPERAND1_LEN
, OPERAND2_NAME OPERAND2_NAME
, OPERAND2_LEVEL OPERAND2_LEVEL
, OPERAND2_POS OPERAND2_POS
, OPERAND2_DIRECTION OPERAND2_DIRECTION
, OPERAND2_CONSTANT OPERAND2_CONSTANT
, OPERAND3_LEVEL OPERAND3_LEVEL
, OPERAND3_NAME OPERAND3_NAME
, OPERAND3_POS OPERAND3_POS
, OPERAND3_DIRECTION OPERAND3_DIRECTION
, OPERAND3_CONSTANT OPERAND3_CONSTANT
, OPERAND4_LEVEL OPERAND4_LEVEL
, OPERAND4_NAME OPERAND4_NAME
, OPERAND4_POS OPERAND4_POS
, OPERAND4_DIRECTION OPERAND4_DIRECTION
, OPERAND4_CONSTANT OPERAND4_CONSTANT
, OPERAND5_LEVEL OPERAND5_LEVEL
, OPERAND5_NAME OPERAND5_NAME
, OPERAND5_POS OPERAND5_POS
, OPERAND5_DIRECTION OPERAND5_DIRECTION
, OPERAND5_CONSTANT OPERAND5_CONSTANT
, OPERAND6_LEVEL OPERAND6_LEVEL
, OPERAND6_NAME OPERAND6_NAME
, OPERAND6_POS OPERAND6_POS
, OPERAND6_DIRECTION OPERAND6_DIRECTION
, OPERAND6_CONSTANT OPERAND6_CONSTANT
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ECX"."ECX_TRAN_STAGE_DATA"