DBA Data[Home] [Help]

VIEW: EC.ECE_TRAN_STAGE_DATA_UPG#

Source

View Text - Preformatted

select TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_LEVEL TRANSACTION_LEVEL, 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, PREVIOUS_VARIABLE_LEVEL PREVIOUS_VARIABLE_LEVEL, PREVIOUS_VARIABLE_NAME PREVIOUS_VARIABLE_NAME, SEQUENCE_NAME SEQUENCE_NAME, CUSTOM_PROCEDURE_NAME CUSTOM_PROCEDURE_NAME, DATA_TYPE DATA_TYPE, FUNCTION_NAME FUNCTION_NAME, NEXT_VARIABLE_NAME NEXT_VARIABLE_NAME, WHERE_CLAUSE WHERE_CLAUSE, TRANSTAGE_ID TRANSTAGE_ID, MAP_ID MAP_ID from "EC"."ECE_TRAN_STAGE_DATA_UPG"
View Text - HTML Formatted

SELECT TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_LEVEL TRANSACTION_LEVEL
, 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
, PREVIOUS_VARIABLE_LEVEL PREVIOUS_VARIABLE_LEVEL
, PREVIOUS_VARIABLE_NAME PREVIOUS_VARIABLE_NAME
, SEQUENCE_NAME SEQUENCE_NAME
, CUSTOM_PROCEDURE_NAME CUSTOM_PROCEDURE_NAME
, DATA_TYPE DATA_TYPE
, FUNCTION_NAME FUNCTION_NAME
, NEXT_VARIABLE_NAME NEXT_VARIABLE_NAME
, WHERE_CLAUSE WHERE_CLAUSE
, TRANSTAGE_ID TRANSTAGE_ID
, MAP_ID MAP_ID
FROM "EC"."ECE_TRAN_STAGE_DATA_UPG"