[Home] [Help] [Dependency Information]
Object Name: | AME_TEST_TRANS_ATT_VALUES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.AME_TEST_TRANS_ATT_VALUES |
Subobject Name: | |
Status: | VALID |
This table stores the user defined attriute value for a test case. Test case run result are based on this attribute values.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AME_TEST_TRANS_ATT_VALUES_FK1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING |
APPLICATION_ID
TRANSACTION_ID ATTRIBUTE_NAME ATTRIBUTE_TYPE LINE_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | AME internal application identifier which identifies a transaction type | |
TRANSACTION_ID | VARCHAR2 | (50) | Yes | AME generated transaction identifier for test case |
ROW_TIMESTAMP | DATE | Yes | Not used | |
ATTRIBUTE_ID | NUMBER | Yes | Attribute identifier | |
ATTRIBUTE_NAME | VARCHAR2 | (50) | Yes | Attribute name |
ATTRIBUTE_TYPE | VARCHAR2 | (20) | Yes | Attribute data type |
IS_MANDATORY | VARCHAR2 | (1) | Yes | Flag to indicate whether the attribute is mandatory or not |
LINE_ITEM_ID | VARCHAR2 | (50) | Not used | |
ATTRIBUTE_VALUE_1 | VARCHAR2 | (100) | Attribute value one | |
ATTRIBUTE_VALUE_2 | VARCHAR2 | (100) | Attribute value two | |
ATTRIBUTE_VALUE_3 | VARCHAR2 | (100) | Attribute value three | |
SECURITY_GROUP_ID | NUMBER | (15) | Not used | |
ITEM_ID | VARCHAR2 | (100) | Item identifier for which attribute has the value | |
ITEM_CLASS_ID | NUMBER | (15) | Attribute item class identifier |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, TRANSACTION_ID
, ROW_TIMESTAMP
, ATTRIBUTE_ID
, ATTRIBUTE_NAME
, ATTRIBUTE_TYPE
, IS_MANDATORY
, LINE_ITEM_ID
, ATTRIBUTE_VALUE_1
, ATTRIBUTE_VALUE_2
, ATTRIBUTE_VALUE_3
, SECURITY_GROUP_ID
, ITEM_ID
, ITEM_CLASS_ID
FROM HR.AME_TEST_TRANS_ATT_VALUES;
HR.AME_TEST_TRANS_ATT_VALUES does not reference any database object
HR.AME_TEST_TRANS_ATT_VALUES is referenced by following:
|
|
|