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

TABLE: EDR.EDR_AMETRAN_INPUT_VAR

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


AME Transaction Input Variable Table


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDR_AMETRAN_INPUT_VAR_P NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAME_TRANS_NAME
ColumnINPUT_NAME
EDR_AMETRAN_INPUT_VAR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnAME_TRANS_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

EDR.EDR_AMETRAN_INPUT_VAR does not reference any database object

EDR.EDR_AMETRAN_INPUT_VAR is referenced by following:

SchemaAPPS
SynonymEDR_AMETRAN_INPUT_VAR