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_CONC_REL_CONJ_MEMBERS

Object Details

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

Each Concurrent Manager Advanced Schedule consists of a Conjunction
of several Disjunctions. FND_CONC_REL_CONJ_MEMBERS stores
information about which Disjunctions (stored in
FND_CONC_RELEASE_DISJS) belong to which Conjunction (stored in
FND_CONC_RELEASE_CLASSES).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_CONC_REL_CONJ_MEMB_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLASS_APPLICATION_ID RELEASE_CLASS_ID DISJUNCTION_APPLICATION_ID DISJUNCTION_ID
FND_CONC_REL_CONJ_MEMB_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_REQ_ID
FND_CONC_REL_CONJ_MEMB_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_SCH_APP_ID OWNER_SCH_ID

Columns

Name	Datatype	Mandatory	Comments
CLASS_APPLICATION_ID	NUMBER	Yes	Application class identifier
RELEASE_CLASS_ID	NUMBER	Yes	Schedule identifier
DISJUNCTION_APPLICATION_ID	NUMBER	Yes	Disjunction application identifier
DISJUNCTION_ID	NUMBER	Yes	Disjunction identifier
OWNER_REQ_ID	NUMBER		Used for temporary schedules: owning request's ID
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
OWNER_SCH_ID	NUMBER		Automatically generates scheduling
OWNER_SCH_APP_ID	NUMBER		Applications identifier for the owner schedule

Query Text

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


SELECT CLASS_APPLICATION_ID
,      RELEASE_CLASS_ID
,      DISJUNCTION_APPLICATION_ID
,      DISJUNCTION_ID
,      OWNER_REQ_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OWNER_SCH_ID
,      OWNER_SCH_APP_ID
FROM APPLSYS.FND_CONC_REL_CONJ_MEMBERS;

Dependencies

[top of page]

APPLSYS.FND_CONC_REL_CONJ_MEMBERS does not reference any database object

APPLSYS.FND_CONC_REL_CONJ_MEMBERS is referenced by following:

APPS: FND_CONC_REL_CONJ_MEMBERS