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]

VIEW: APPS.FND_REQUEST_SETS_VL

Object Details

Object Name:	FND_REQUEST_SETS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_REQUEST_SETS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

FND_REQUEST_SETS_VL is a view that joins the translated, language
specific values form FND_REQUEST_SETS_TL with the non-displayed
data from FND_REQUEST_SETS to form complete report set
entities. Oracle Application Object Library uses this view to
display information in languages installed at your site.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
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
USER_REQUEST_SET_NAME	VARCHAR2	(240)	Yes	User name for the request set
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT ROW_ID
,      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
,      USER_REQUEST_SET_NAME
,      DESCRIPTION
FROM APPS.FND_REQUEST_SETS_VL;

Dependencies

[top of page]

APPS.FND_REQUEST_SETS_VL references the following:

APPS: FND_REQUEST_SETS; FND_REQUEST_SETS_TL

APPS.FND_REQUEST_SETS_VL is referenced by following:

APPS: BIS_CREATE_REQUESTSET - show dependent code; FND_REQUEST_SET - show dependent code; FND_SET - show dependent code; FND_SUBMIT - show dependent code; HRI_BPL_CONC_ADMIN - show dependent code