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.FND_CONCURRENT_PROGRAM_SERIAL

Object Details

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

FND_CONCURRENT_PROGRAM_SERIAL stores information about incompatible
concurrent programs (programs that cannot run at the same time).
Each row identifies a concurrent program and another concurrent
program that is incompatible with it (perhaps itself). For
example, if Programs A and B are defined to be incompatible,
Oracle Application Object Library creates two rows in this table:
one indicates that A is incompatible with B, and the other indicates
that B is incompatible with A. You need two rows for each pair of
incompatible programs in your applications, though you need only
one row for a program that is incompatible with itself. Oracle
Application Object Library uses this information to ensure that
incompatible programs do not run at the same time on the same
logical database.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_CONC_PROGRAM_SERIAL_U1	NORMAL	UNIQUE	APPS_TS_SEED	RUNNING_APPLICATION_ID RUNNING_CONCURRENT_PROGRAM_ID TO_RUN_APPLICATION_ID TO_RUN_CONCURRENT_PROGRAM_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RUNNING_APPLICATION_ID	NUMBER	(15)	Yes	Application identifier of the concurrent program
RUNNING_CONCURRENT_PROGRAM_ID	NUMBER	(15)	Yes	Concurrent program identifier
TO_RUN_APPLICATION_ID	NUMBER	(15)	Yes	Application identifier of the incompatible concurrent program
TO_RUN_CONCURRENT_PROGRAM_ID	NUMBER	(15)	Yes	The identifier of the incompatible concurrent program
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
UPDATE_SECURITY_GROUP_ID	NUMBER	(15)		Not currently used
RUNNING_TYPE	VARCHAR2	(1)		Flag to indicate whether the concurrent program is a Program or a Report Set
TO_RUN_TYPE	VARCHAR2	(1)		Flag to indicate whether the incompatible concurrent program is a Program or a Report Set
INCOMPATIBILITY_TYPE	VARCHAR2	(1)		Global or Domain-specific incompatibility
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT RUNNING_APPLICATION_ID
,      RUNNING_CONCURRENT_PROGRAM_ID
,      TO_RUN_APPLICATION_ID
,      TO_RUN_CONCURRENT_PROGRAM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UPDATE_SECURITY_GROUP_ID
,      RUNNING_TYPE
,      TO_RUN_TYPE
,      INCOMPATIBILITY_TYPE
,      ZD_EDITION_NAME
FROM APPLSYS.FND_CONCURRENT_PROGRAM_SERIAL;

Dependencies

[top of page]

APPLSYS.FND_CONCURRENT_PROGRAM_SERIAL does not reference any database object

APPLSYS.FND_CONCURRENT_PROGRAM_SERIAL is referenced by following:

APPLSYS: FND_CONCURRENT_PROGRAM_SERIAL#