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

Object Details

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

View Type

A Business Intelligence System view

PSBBV_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
_LA:PARAMETER_TYPE	CHAR	(57)		Parameter type. Values are Account, Position, or Element. Entity types Parameter and Constraint can have values Account, Position, or Element. Entity type Allocrule can have 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 formula percentages are compounded annually
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
,      _LA:PARAMETER_TYPE
,      DESCRIPTION
,      CURRENCY_CODE
,      PARAMETER_AUTOINC_RULE
,      PARAMETER_COMPOUND_ANNUALLY
,      PARAMETER_ID
,      SET_OF_BOOKS_ID
,      DATA_EXTRACT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBBV_PARAMETERS;

Dependencies

[top of page]

APPS.PSBBV_PARAMETERS references the following:

APPS: PSB_ENTITY

APPS.PSBBV_PARAMETERS is not referenced by any database object