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_REQUEST_SETS

Object Details

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

FND_REQUEST_SETS stores information about report sets. Each row
includes the name of the report set (REQUEST_SET_NAME), whether the
reports within the set can be run simultaneously
(REQUEST_SET_TYPE_FLAG where P means parallel and S means
sequential), whether the sequential report set should abort if one
report fails (ABORT_FLAG), and the start and end dates for which
the report set is valid. Each row also includes the concurrent
program identifier for the report set, the owner of the report set,
the printer name and print style for the report set to print reports,
and flags that specify whether incompatibility rules can be defined
for this report set and whether to send all the reports in this
report set to the printer together when the report set finishes.
You need one row for each report set that
you define using the Define Report Set form.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_REQUEST_SETS_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID REQUEST_SET_ID ZD_EDITION_NAME
FND_REQUEST_SETS_U2	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID REQUEST_SET_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
REQUEST_SET_ID	NUMBER	(15)	Yes	Request Set identifier
REQUEST_SET_NAME	VARCHAR2	(30)	Yes	Developer name for the Request Set
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
ALLOW_CONSTRAINTS_FLAG	VARCHAR2	(1)	Yes	Determines if incompatibilities are allowed
PRINT_TOGETHER_FLAG	VARCHAR2	(1)	Yes	Save printing until set completes
START_DATE_ACTIVE	DATE		Yes	Set available from this date
START_STAGE	NUMBER	(15)		ID of the first stage to be executed
END_DATE_ACTIVE	DATE			Set unavailable after this date
CONCURRENT_PROGRAM_ID	NUMBER	(15)		ID of program for incompatibilities
OWNER	NUMBER	(15)		User who owns the set
PRINTER	VARCHAR2	(30)		Printer assinged to the set
PRINT_STYLE	VARCHAR2	(30)		Print style assinged to the set
ICON_NAME	VARCHAR2	(30)		Reserved for future use
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT APPLICATION_ID
,      REQUEST_SET_ID
,      REQUEST_SET_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ALLOW_CONSTRAINTS_FLAG
,      PRINT_TOGETHER_FLAG
,      START_DATE_ACTIVE
,      START_STAGE
,      END_DATE_ACTIVE
,      CONCURRENT_PROGRAM_ID
,      OWNER
,      PRINTER
,      PRINT_STYLE
,      ICON_NAME
,      ZD_EDITION_NAME
FROM APPLSYS.FND_REQUEST_SETS;

Dependencies

[top of page]

APPLSYS.FND_REQUEST_SETS does not reference any database object

APPLSYS.FND_REQUEST_SETS is referenced by following:

APPLSYS: FND_REQUEST_SETS#