[Home] [Help] [Dependency Information]
Object Name: | AD_WORKING_RES_LOCKS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | AD.AD_WORKING_RES_LOCKS |
Subobject Name: | |
Status: | VALID |
Holds Active Locks held by AD Utilites
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_WORKING_RES_LOCKS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
SESSION_ID
RESOURCE_CODE CONTEXT APPL_TOP_ID LANGUAGE EXTRA_CONTEXT1 EXTRA_CONTEXT2 EXTRA_CONTEXT3 IN_PROCESS_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPL_TOP_ID | NUMBER | Yes | Foreign Key to AD_APPL_TOPS | |
SESSION_ID | NUMBER | Yes | Foreign Key to AD Sessions | |
RESOURCE_CODE | VARCHAR2 | (30) | Yes | Application System Resource |
CONTEXT | VARCHAR2 | (30) | Yes | Resource subset |
LOCK_MODE | VARCHAR2 | (1) | Yes | Shared or Exclusive |
LANGUAGE | VARCHAR2 | (8) | Yes | Language for the resource. US, or F, or D, etc. |
IN_PROCESS_FLAG | VARCHAR2 | (1) | Yes | Processing requiring this lock in progress |
SESSION_STATUS | VARCHAR2 | (30) | Yes | Foreign Key to AD_SESSIONS.STATUS |
SESSION_PRIORITY | NUMBER | Yes | Foreign Key to AD_SESSIONS.PRIORITY | |
DATE_REQUESTED | DATE | Yes | Date the Lock was Requested | |
EXTRA_CONTEXT1 | VARCHAR2 | (30) | Yes | Currently not used. Holds a value ALL |
EXTRA_CONTEXT2 | VARCHAR2 | (30) | Yes | Currently not used. Holds a value ALL |
EXTRA_CONTEXT3 | VARCHAR2 | (30) | Yes | Currently not used. Holds a value ALL |
DATE_ACQUIRED | DATE | Date and Time when the lock is acquired |
Cut, paste (and edit) the following text to query this object:
SELECT APPL_TOP_ID
, SESSION_ID
, RESOURCE_CODE
, CONTEXT
, LOCK_MODE
, LANGUAGE
, IN_PROCESS_FLAG
, SESSION_STATUS
, SESSION_PRIORITY
, DATE_REQUESTED
, EXTRA_CONTEXT1
, EXTRA_CONTEXT2
, EXTRA_CONTEXT3
, DATE_ACQUIRED
FROM APPLSYS.AD_WORKING_RES_LOCKS;
APPLSYS.AD_WORKING_RES_LOCKS does not reference any database object
APPLSYS.AD_WORKING_RES_LOCKS is referenced by following:
|
|
|