DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_PARAMETERS

Object Details
Object Name: FND_PARAMETERS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_PARAMETERS
Subobject Name:
Status: VALID

Integration Repository method parameters

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FUNCTION_ID NUMBER (15) Yes Owning Method
PARAM_SEQUENCE NUMBER (15) Yes Sequence
INNERTYPE_SEQUENCE NUMBER (15) Yes Innertype Sequence
PARAM_NAME VARCHAR2 (240)
Parameter Name
PARAM_DIRECTION VARCHAR2 (1) Yes Parameter Direction
PARAM_OPTIONAL VARCHAR2 (1) Yes Optional Flag
PARAMETER_TYPE VARCHAR2 (430)
Parameter Type
PARAM_PRECISION NUMBER (15)
Precision
NULL_ALLOWED VARCHAR2 (1) Yes Null Allowed Flag
DESCRIPTION VARCHAR2 (4000)
Description
DEFAULT_VALUE VARCHAR2 (255)
Default Value
DISPLAYED_FLAG VARCHAR2 (1) Yes Is this Parameter Displayed under Standard Report Submission (only relevent for Concurrent Programs)?
FN_OVERLOAD_SEQUENCE NUMBER (15) Yes Function Overload Sequence
PARAM_SCALE NUMBER (15)
Parameter Scale
ATTRIBUTE_SET VARCHAR2 (240)
Attribute Set
Query Text

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


SELECT FUNCTION_ID
,      PARAM_SEQUENCE
,      INNERTYPE_SEQUENCE
,      PARAM_NAME
,      PARAM_DIRECTION
,      PARAM_OPTIONAL
,      PARAMETER_TYPE
,      PARAM_PRECISION
,      NULL_ALLOWED
,      DESCRIPTION
,      DEFAULT_VALUE
,      DISPLAYED_FLAG
,      FN_OVERLOAD_SEQUENCE
,      PARAM_SCALE
,      ATTRIBUTE_SET
FROM APPLSYS.FND_PARAMETERS;

Dependencies

[top of page]

APPLSYS.FND_PARAMETERS does not reference any database object

APPLSYS.FND_PARAMETERS is referenced by following:

SchemaAPPS
SynonymFND_PARAMETERS