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_PLANNED_RES_LOCKS

Object Details

Object Name:	AD_PLANNED_RES_LOCKS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_PLANNED_RES_LOCKS
Subobject Name:
Status:	VALID

This table is used for storing the Resource Locks meant for different concurrently running AD Utilities. The Resource lock information are loaded into this table initially by the Ad Utility and the rows from this table are used for acquiring and releasing the Resource locks at different stages of the utilty. .

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PLANNED_RES_LOCKS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	SESSION_ID STAGE_CODE RESOURCE_CODE CONTEXT APPL_TOP_ID LANGUAGE EXTRA_CONTEXT1 EXTRA_CONTEXT2 EXTRA_CONTEXT3 ACTION_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.SESSION_ID
STAGE_CODE	VARCHAR2	(30)	Yes	Identifies the stage the lock is required for
RESOURCE_CODE	VARCHAR2	(30)	Yes	Application System Resource
CONTEXT	VARCHAR2	(30)	Yes	Resource subset
LOCK_MODE	VARCHAR2	(1)	Yes	Shared or Exclusive Lock
LANGUAGE	VARCHAR2	(8)	Yes	Language subset for the Resource Lock
ACTION_FLAG	VARCHAR2	(1)	Yes	Specifies what is to be done with the resource lock and when
EXTRA_CONTEXT1	VARCHAR2	(30)	Yes	Not currently used
EXTRA_CONTEXT2	VARCHAR2	(30)	Yes	Not currently used
EXTRA_CONTEXT3	VARCHAR2	(30)	Yes	Not currently used
DONE_FLAG	VARCHAR2	(1)		For Restart Purposes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPL_TOP_ID
,      SESSION_ID
,      STAGE_CODE
,      RESOURCE_CODE
,      CONTEXT
,      LOCK_MODE
,      LANGUAGE
,      ACTION_FLAG
,      EXTRA_CONTEXT1
,      EXTRA_CONTEXT2
,      EXTRA_CONTEXT3
,      DONE_FLAG
FROM APPLSYS.AD_PLANNED_RES_LOCKS;

Dependencies

[top of page]

APPLSYS.AD_PLANNED_RES_LOCKS does not reference any database object

APPLSYS.AD_PLANNED_RES_LOCKS is referenced by following:

APPLSYS: AD_PLANNED_RES_LOCKS#