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

TABLE: EDR.EDR_AMERULE_INPUT_VAR

Object Details
Object Name: EDR_AMERULE_INPUT_VAR
Object Type: TABLE
Owner: EDR
FND Design Data: TableEDR.EDR_AMERULE_INPUT_VAR
Subobject Name:
Status: VALID


AME Rule Input Variable Table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDR_AMERULE_INPUT_VAR_P NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAME_TRANS_NAME
ColumnINPUT_NAME
ColumnRULE_ID
EDR_AMERULE_INPUT_VAR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAME_TRANS_ID
Columns
Name Datatype Length Mandatory Comments
AME_TRANS_NAME VARCHAR2 (240) Yes Transaction Name
INPUT_NAME VARCHAR2 (80) Yes Input Variable Name
RULE_NAME VARCHAR2 (80)
Rule Name
RULE_ID NUMBER (38) Yes Rule ID
INPUT_VALUE VARCHAR2 (80)
Input Variable Value
CREATED_BY NUMBER (38) Yes Standard Who Column
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER (38) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATE_LOGIN NUMBER (38)
Standard Who Column
RULE_CONFIG_ID NUMBER (38)
Rule Configuration ID
AME_TRANS_ID VARCHAR2 (80)
Approval Management Transaction Type Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AME_TRANS_NAME
,      INPUT_NAME
,      RULE_NAME
,      RULE_ID
,      INPUT_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RULE_CONFIG_ID
,      AME_TRANS_ID
FROM EDR.EDR_AMERULE_INPUT_VAR;

Dependencies

[top of page]

EDR.EDR_AMERULE_INPUT_VAR does not reference any database object

EDR.EDR_AMERULE_INPUT_VAR is referenced by following:

SchemaEDR
ViewEDR_AMERULE_INPUT_VAR#