[Home] [Help] [Dependency Information]
Object Name: | EDR_AMERULE_INPUT_VAR |
---|---|
Object Type: | TABLE |
Owner: | EDR |
FND Design Data: | EDR.EDR_AMERULE_INPUT_VAR |
Subobject Name: | |
Status: | VALID |
AME Rule Input Variable Table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDR_AMERULE_INPUT_VAR_P | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AME_TRANS_NAME
INPUT_NAME RULE_ID |
EDR_AMERULE_INPUT_VAR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AME_TRANS_ID |
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 |
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;
EDR.EDR_AMERULE_INPUT_VAR does not reference any database object
EDR.EDR_AMERULE_INPUT_VAR is referenced by following:
|
|
|