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

TABLE: PA.PA_FUNCTION_PARAMETERS

Object Details
Object Name: PA_FUNCTION_PARAMETERS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_FUNCTION_PARAMETERS
Subobject Name:
Status: VALID


PA_FUNCTION_PARAMETERS stores the parameters that can be referenced and used as input values by an AutoAccounting function. Oracle Projects provides all function parameters upon installation.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 2
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_FUNCTION_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFUNCTION_CODE
ColumnPARAMETER_ID
ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes The identifier of the Oracle application that uses the function
FUNCTION_CODE VARCHAR2 (15) Yes The identifier of the function to which the parameter is assigned
PARAMETER_ID NUMBER (15) Yes The identifier of the parameter that is assigned to the function
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
PARAMETER_SEQ NUMBER (15) Yes The number used to order the parameters of a function
Query Text

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


SELECT APPLICATION_ID
,      FUNCTION_CODE
,      PARAMETER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PARAMETER_SEQ
FROM PA.PA_FUNCTION_PARAMETERS;

Dependencies

[top of page]

PA.PA_FUNCTION_PARAMETERS does not reference any database object

PA.PA_FUNCTION_PARAMETERS is referenced by following:

SchemaAPPS
SynonymPA_FUNCTION_PARAMETERS