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

TABLE: ECX.ECX_TRAN_STAGE_DATA

Object Details
Object Name: ECX_TRAN_STAGE_DATA
Object Type: TABLE
Owner: ECX
FND Design Data: TableECX.ECX_TRAN_STAGE_DATA
Subobject Name:
Status: VALID


This table contains the action definitions


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECX_TRAN_STAGE_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMAP_ID
ColumnTRANSTAGE_ID
Columns
Name Datatype Length Mandatory Comments
TRANSTAGE_ID NUMBER
Yes Transaction Stage Identifier
SOURCE_LEVEL_ID NUMBER

Source Object Level Identifier
STAGE NUMBER

Processing Stage
SEQ_NUMBER NUMBER

Action Sequence Number
ACTION_TYPE NUMBER

Action Type
VARIABLE_LEVEL NUMBER

Result Variable Level
VARIABLE_NAME VARCHAR2 (255)
Result Variable Name
VARIABLE_VALUE VARCHAR2 (2000)
Result Variable Value
DEFAULT_VALUE VARCHAR2 (2000)
Result Default Value
SEQUENCE_NAME VARCHAR2 (255)
Sequence Name
CUSTOM_PROCEDURE_NAME VARCHAR2 (255)
Database Procedure Name
DATA_TYPE NUMBER (15)
Datatype
FUNCTION_NAME VARCHAR2 (255)
Database Function Name
WHERE_CLAUSE VARCHAR2 (2000)
Where Clause
VARIABLE_POS NUMBER

Result Variable Postion
MAP_ID NUMBER
Yes Map Identifier
OBJECTLEVEL_ID NUMBER
Yes Object Level Identifier
OBJECT_DIRECTION VARCHAR2 (1)
Object Direction
VARIABLE_DIRECTION VARCHAR2 (1)
Result Direction
ACTION_POS NUMBER

Action Postion
COND_LOGICAL_OPERATOR VARCHAR2 (10)
Not Used
COND_OPERATOR1 VARCHAR2 (20)
First Condition Operator
COND_VAR1_LEVEL NUMBER (15)
First Condition Variable Level
COND_VAR1_NAME VARCHAR2 (240)
First Condition Variable Name
COND_VAR1_POS NUMBER (15)
First Condition Variable Position
COND_VAR1_DIRECTION VARCHAR2 (20)
First Condition Variable Direction
COND_VAR1_CONSTANT VARCHAR2 (2000)
First Condition Variable Constant
COND_OPERATOR2 VARCHAR2 (240)
Not Used
COND_VAR2_LEVEL NUMBER (15)
Not Used
COND_VAR2_NAME VARCHAR2 (240)
Not Used
COND_VAR2_POS NUMBER (15)
Not Used
COND_VAR2_DIRECTION VARCHAR2 (20)
Not Used
COND_VAR2_CONSTANT VARCHAR2 (2000)
Not Used
COND_VAL1_LEVEL NUMBER (15)
First Condition Value Level
COND_VAL1_NAME VARCHAR2 (240)
First Condition Value Name
COND_VAL1_POS NUMBER (15)
First Condition Value Position
COND_VAL1_DIRECTION VARCHAR2 (20)
First Condition Value Direction
COND_VAL1_CONSTANT VARCHAR2 (2000)
First Condition Value Constant
COND_VAL2_LEVEL NUMBER (15)
Not Used
COND_VAL2_NAME VARCHAR2 (240)
Not Used
COND_VAL2_POS NUMBER (15)
Not Used
COND_VAL2_DIRECTION VARCHAR2 (20)
Not Used
COND_VAL2_CONSTANT VARCHAR2 (2000)
Not Used
OPERAND1_LEVEL NUMBER (15)
First Operand Level
OPERAND1_NAME VARCHAR2 (240)
First Operand Name
OPERAND1_POS NUMBER (15)
First Operand Position
OPERAND1_DIRECTION VARCHAR2 (20)
First Operand Direction
OPERAND1_CONSTANT VARCHAR2 (2000)
First Operand Constant
OPERAND1_START_POS NUMBER (15)
Not Used
OPERAND1_LEN NUMBER (15)
Not Used
OPERAND2_NAME VARCHAR2 (240)
Second Operand Name
OPERAND2_LEVEL NUMBER (15)
Second Operand Level
OPERAND2_POS NUMBER (15)
Second Operand Position
OPERAND2_DIRECTION VARCHAR2 (20)
Second Operand Direction
OPERAND2_CONSTANT VARCHAR2 (2000)
Second Operand Constant
OPERAND3_LEVEL NUMBER (15)
Third Operand Level
OPERAND3_NAME VARCHAR2 (240)
Third Operand Name
OPERAND3_POS NUMBER (15)
Third Operand Position
OPERAND3_DIRECTION VARCHAR2 (20)
Third Operand Direction
OPERAND3_CONSTANT VARCHAR2 (2000)
Third Operand Constant
OPERAND4_LEVEL NUMBER (15)
Fourth Operand Level
OPERAND4_NAME VARCHAR2 (240)
Fourth Operand Name
OPERAND4_POS NUMBER (15)
Fourth Operand Position
OPERAND4_DIRECTION VARCHAR2 (20)
Fourth Operand Direction
OPERAND4_CONSTANT VARCHAR2 (2000)
Fourth Operand Constant
OPERAND5_LEVEL NUMBER (15)
Fifth Operand Level
OPERAND5_NAME VARCHAR2 (240)
Fifth Operand Name
OPERAND5_POS NUMBER (15)
Fifth Operand Position
OPERAND5_DIRECTION VARCHAR2 (20)
Fifth Operand Direction
OPERAND5_CONSTANT VARCHAR2 (2000)
Fifth Operand Constant
OPERAND6_LEVEL NUMBER (15)
Sixth Operand Level
OPERAND6_NAME VARCHAR2 (240)
Sixth Operand Name
OPERAND6_POS NUMBER (15)
Sixth Operand Position
OPERAND6_DIRECTION VARCHAR2 (20)
Sixth Operand Direction
OPERAND6_CONSTANT VARCHAR2 (2000)
Sixth Operand Constant
Query Text

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
FROM ECX.ECX_TRAN_STAGE_DATA;

Dependencies

[top of page]

ECX.ECX_TRAN_STAGE_DATA does not reference any database object

ECX.ECX_TRAN_STAGE_DATA is referenced by following:

SchemaAPPS
SynonymECX_TRAN_STAGE_DATA