[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 5 |
PCT Used: |
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 ZD_EDITION_NAME |
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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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
, ZD_EDITION_NAME
FROM APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS;
APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS does not reference any database object
APPLSYS.FND_REQUEST_SET_PROGRAM_ARGS is referenced by following:
|
|
|