[Home] [Help] [Dependency Information]
Object Name: | EDR_AMETRAN_INPUT_VAR |
---|---|
Object Type: | TABLE |
Owner: | EDR |
FND Design Data: | EDR.EDR_AMETRAN_INPUT_VAR |
Subobject Name: | |
Status: | VALID |
AME Transaction Input Variable Table
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDR_AMETRAN_INPUT_VAR_P | NORMAL | UNIQUE | APPS_TS_SEED |
AME_TRANS_NAME
INPUT_NAME |
EDR_AMETRAN_INPUT_VAR_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | AME_TRANS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AME_TRANS_NAME | VARCHAR2 | (240) | Yes | Transaction Name |
AME_TRANS_ID | VARCHAR2 | (80) | Transaction ID | |
INPUT_NAME | VARCHAR2 | (80) | Yes | Input Variable Name |
INPUT_DESC | VARCHAR2 | (240) | Input Variable Description | |
INPUT_TYPE | VARCHAR2 | (20) | Input Variable DataType | |
DEFAULT_VALUE | VARCHAR2 | (80) | Input Variable Default Value | |
CREATED_BY | NUMBER | (38) | Yes | Who Column for Create |
CREATION_DATE | DATE | Yes | Creation Date | |
LAST_UPDATED_BY | NUMBER | (38) | Yes | Who Column for Last Update |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Login ID for Last Update | |
TRAN_CONFIG_ID | NUMBER | (38) | Transaction Configuration ID |
Cut, paste (and edit) the following text to query this object:
SELECT AME_TRANS_NAME
, AME_TRANS_ID
, INPUT_NAME
, INPUT_DESC
, INPUT_TYPE
, DEFAULT_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TRAN_CONFIG_ID
FROM EDR.EDR_AMETRAN_INPUT_VAR;
EDR.EDR_AMETRAN_INPUT_VAR does not reference any database object
EDR.EDR_AMETRAN_INPUT_VAR is referenced by following:
|
|
|