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_INVOKER_TASKS

Object Details

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

This table is used by the AD feature that automatically converts packages that don't have explicit AUTHID clauses to use the PL/SQL Invoker Rights feature (AUTHID_CURRENT USER).

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_INVOKER_TASKS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PHASE OWNER NAME TYPE OTHER_SCHEMA

Columns

Name	Datatype	Length	Mandatory	Comments
PHASE	NUMBER		Yes	The logical phase in which this row will be processed
OWNER	VARCHAR2	(30)	Yes	The schema that owns the package, procedure, or function to process
NAME	VARCHAR2	(128)	Yes	The name of the package, procedure, or function to process
TYPE	VARCHAR2	(30)	Yes	The type of this object
OTHER_SCHEMA	VARCHAR2	(30)	Yes	The name of a schema that needs a (physical or logical) copy of this object
WORKER	NUMBER		Yes	The logical worker ID of the worker that will process this row
DONE_FLAG	VARCHAR2	(1)		Has this row been processed already?
AUTHID_FLAG	VARCHAR2	(1)		Does the object have an explicit AUTHID clause already?
INVOKER_FLAG	VARCHAR2	(1)		Is this already an Invoker Rights object?
BOUNDARY_FLAG	VARCHAR2	(1)		Used to implement phase boundaries between logical phases

Query Text

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


SELECT PHASE
,      OWNER
,      NAME
,      TYPE
,      OTHER_SCHEMA
,      WORKER
,      DONE_FLAG
,      AUTHID_FLAG
,      INVOKER_FLAG
,      BOUNDARY_FLAG
FROM APPLSYS.AD_INVOKER_TASKS;

Dependencies

[top of page]

APPLSYS.AD_INVOKER_TASKS does not reference any database object

APPLSYS.AD_INVOKER_TASKS is referenced by following:

APPLSYS: AD_INVOKER_TASKS#
SYSTEM: AD_INVOKER_TASKS