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.PSBFV_PARAMETER_SET_LISTS

Object Details

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

View Type

A Business Intelligence System view

PSBFV_PARAMETER_SET_LISTS displays the assignment of parameters to parameter sets. A priority is assigned for the parameters in a specific parameter set.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_SET_NAME	VARCHAR2	(80)	Yes	Parameter set name
PARAMETER_NAME	VARCHAR2	(30)	Yes	Parameter name
_LA:PARAMETER_TYPE	CHAR	(57)		Parameter type. Values are Account, Position, or Element.
PRIORITY	NUMBER	(15)		Processing priority for the parameter in the entity parameter set
CURRENCY_CODE	VARCHAR2	(20)		Functional currency code for the General Ledger Set of Books or STAT for statistical currency
PARAMETER_AUTOINC_RULE	VARCHAR2	(1)		Indicates if this is an auto increment salary parameter
PARAMETER_COMPOUND_ANNUALLY	VARCHAR2	(1)		Indicates if formula percents are compounded annually
START_EFFECTIVE_DATE	DATE		Yes	Effective assignment start date
END_EFFECTIVE_DATE	DATE			Effective assignment end date
DESCRIPTION	VARCHAR2	(80)		Parameter description
PARAMETER_SET_ID	NUMBER	(15)	Yes	Parameter set unique identifier
PARAMETER_ID	NUMBER	(15)	Yes	Parameter unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT PARAMETER_SET_NAME
,      PARAMETER_NAME
,      _LA:PARAMETER_TYPE
,      PRIORITY
,      CURRENCY_CODE
,      PARAMETER_AUTOINC_RULE
,      PARAMETER_COMPOUND_ANNUALLY
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      DESCRIPTION
,      PARAMETER_SET_ID
,      PARAMETER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_PARAMETER_SET_LISTS;

Dependencies

[top of page]

APPS.PSBFV_PARAMETER_SET_LISTS references the following:

APPS: PSB_ENTITY; PSB_ENTITY_ASSIGNMENT; PSB_ENTITY_SET

APPS.PSBFV_PARAMETER_SET_LISTS is not referenced by any database object