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_SET_PROGRAM_ARGS

Object Details

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

FND_REQUEST_SET_PROGRAM_ARGS stores information about arguments
in every report set defined with Oracle Application Object Library.
Each row includes values that identify an application that owns the
report set, a report set, a program or report belonging to the
report set, and an application that owns the descriptive flexfield
which is used for popping up the report argument window. Each row
also includes the name of the descriptive flexfield, the argument for
the program or report, the default value for the argument, the type
of the default value, the shared parameter name for the argument
used among the report, and flags to specify whether users can update
or see the argument. Oracle Application Object Library
uses this information to display each argument in the report argument
window.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_REQUEST_SET_PROG_ARGS_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID REQUEST_SET_ID REQUEST_SET_PROGRAM_ID DESCRIPTIVE_FLEX_APPL_ID DESCRIPTIVE_FLEXFIELD_NAME APPLICATION_COLUMN_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_PROGRAM_ID	NUMBER	(15)	Yes	Report set program identifier
DESCRIPTIVE_FLEX_APPL_ID	NUMBER	(15)	Yes	Identifier of the application with which the descriptive flexfield is defined
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	Descriptive flexfield name
APPLICATION_COLUMN_NAME	VARCHAR2	(30)	Yes	Column name
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
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether to display the argument
INSERT_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether a value can be entered for the argument
UPDATE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the argument can be updated
DEFAULT_TYPE	VARCHAR2	(1)		Type of default value
DEFAULT_VALUE	VARCHAR2	(2000)		Default value
SHARED_PARAMETER_NAME	VARCHAR2	(30)		Name of the shared parameter

Query Text

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


SELECT APPLICATION_ID
,      REQUEST_SET_ID
,      REQUEST_SET_PROGRAM_ID
,      DESCRIPTIVE_FLEX_APPL_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      APPLICATION_COLUMN_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISPLAY_FLAG
,      INSERT_FLAG
,      UPDATE_FLAG
,      DEFAULT_TYPE
,      DEFAULT_VALUE
,      SHARED_PARAMETER_NAME
FROM APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS;

Dependencies

[top of page]

APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS does not reference any database object

APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS is referenced by following:

APPS: ETRM_FNDNAV - show dependent code; FND_REQUEST_SET_PROGRAM_ARGS