eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.AD_WORKING_RES_LOCKS

Object Details

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.AD_WORKING_RES_LOCKS does not reference any database object

APPLSYS.AD_WORKING_RES_LOCKS is referenced by following:

APPLSYS: AD_WORKING_RES_LOCKS#