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_PARAMETERS

Object Details

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

View Type

A Business Intelligence System view

PSBFV_PARAMETERS displays information about worksheet parameters. Each parameter can be assigned to one or more parameter sets.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_NAME	VARCHAR2	(30)	Yes	Parameter name
SET_OF_BOOKS_NAME	VARCHAR2	(30)		General Ledger Set of Books name
DATA_EXTRACT_NAME	VARCHAR2	(30)		Data extract name
_LA:PARAMETER_TYPE	CHAR	(57)		Parameter type. Values are Account, Position, or Element. The entity types Parameter and Constraint can have the values Account, Position, or Element. The entity type Allocrule can have the values Account or Position.
DESCRIPTION	VARCHAR2	(80)		Parameter description
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 the formula percentages are compounded annually
_DF	CHAR	(21)		Descriptive Flexfield column
PARAMETER_ID	NUMBER	(15)	Yes	Parameter unique identifier
SET_OF_BOOKS_ID	NUMBER	(15)		General Ledger Set of Books identifier
DATA_EXTRACT_ID	NUMBER			Data extract 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_NAME
,      SET_OF_BOOKS_NAME
,      DATA_EXTRACT_NAME
,      _LA:PARAMETER_TYPE
,      DESCRIPTION
,      CURRENCY_CODE
,      PARAMETER_AUTOINC_RULE
,      PARAMETER_COMPOUND_ANNUALLY
,      _DF
,      PARAMETER_ID
,      SET_OF_BOOKS_ID
,      DATA_EXTRACT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_PARAMETERS;

Dependencies

[top of page]

APPS.PSBFV_PARAMETERS references the following:

APPS: GL_SETS_OF_BOOKS; PSB_DATA_EXTRACTS; PSB_ENTITY

APPS.PSBFV_PARAMETERS is not referenced by any database object