[Home] [Help] [Dependency Information]
Object Name: | ECX_TRAN_STAGE_DATA |
---|---|
Object Type: | TABLE |
Owner: | ECX |
FND Design Data: | ECX.ECX_TRAN_STAGE_DATA |
Subobject Name: | |
Status: | VALID |
This table contains the action definitions
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ECX_TRAN_STAGE_DATA_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
MAP_ID
TRANSTAGE_ID |
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 |
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;
ECX.ECX_TRAN_STAGE_DATA does not reference any database object
ECX.ECX_TRAN_STAGE_DATA is referenced by following:
|
|
|