[Home] [Help] [Dependency Information]
Object Name: | AME_TEMP_TRANS_LOCKS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.AME_TEMP_TRANS_LOCKS |
Subobject Name: | |
Status: | VALID |
This table is temporary table for internal operation.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AME_TEMP_TRANS_LOCKS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FND_APPLICATION_ID
TRANSACTION_TYPE_ID TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FND_APPLICATION_ID | NUMBER | Yes | FND application identifier for which transaction type belongs | |
TRANSACTION_TYPE_ID | VARCHAR2 | (50) | Transaction type key | |
TRANSACTION_ID | VARCHAR2 | (50) | Yes | Transaction identifier |
ROW_TIMESTAMP | DATE | Yes | Time stamp when transaction has been locked |
Cut, paste (and edit) the following text to query this object:
SELECT FND_APPLICATION_ID
, TRANSACTION_TYPE_ID
, TRANSACTION_ID
, ROW_TIMESTAMP
FROM HR.AME_TEMP_TRANS_LOCKS;
HR.AME_TEMP_TRANS_LOCKS does not reference any database object
HR.AME_TEMP_TRANS_LOCKS is referenced by following:
|
|
|