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_CONSTRAINT_FORMULAS

Object Details

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

View Type

A Business Intelligence System view

PSBFV_CONSTRAINT_FORMULAS displays information about the formulas used to define constraints. The formula may be for an Account Constraint, Position Constraint, or Element Constraint. Account Constraints are applied to account sets. Depending on whether the constraint is applied at the summary or detail account level, the sum of estimates of all accounts or each account must satisfy the condition specified in the constraint formula. Balances to be evaluated in the formula are identified using the year type and the balance type such as Current Year Budget Balance. Element constraints are applicable globally. They specify whether an element option or value can be modified. Position constraints are applied to position sets. Constraints specify element assignments that must be satisfied.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONSTRAINT_NAME	VARCHAR2	(30)	Yes	Constraint name
STEP_NUMBER	NUMBER			User-assigned sequence for constraint formula line
_LA:PREFIX_OPERATOR	CHAR	(73)		Formula line prefix operator. Valid prefix operators are +, -, *, /, =, >, <, >=, <=, and !=.
BUDGET_YEAR_TYPE_NAME	VARCHAR2	(30)		Budget year type name
_LA:BALANCE_TYPE	CHAR	(56)		Balance type. B indicates Budget, A indicates Actual, or E indicates Estimate.
GL_ACCOUNT	VARCHAR2	(2000)		Concatenated accounting segment values entered. Used only for display purposes in the form.
PAY_ELEMENT_NAME	VARCHAR2	(30)	Yes	Pay element name
PAY_ELEMENT_OPTION_NAME	VARCHAR2	(80)		Pay element option name
_LA:ELEMENT_VALUE_TYPE	CHAR	(68)		Element value type
ELEMENT_VALUE	NUMBER			Pay element value
CURRENCY_CODE	VARCHAR2	(20)		Formula line currency. Functional currency code for the General Ledger Set of Books or STAT for statistical currency.
_LA:POSTFIX_OPERATOR	CHAR	(64)		Formula line postfix operator. Valid postfix operators are +, -, *, and /.
AMOUNT	NUMBER			Formula line amount. Monetary or statistical based on the currency code.
ALLOW_MODIFY	VARCHAR2	(1)		Indicates if this element can be modified at the worksheet level
_DF	CHAR	(34)		Descriptive Flexfield column
START_EFFECTIVE_DATE	DATE			Effective start date for position and element formulas
END_EFFECTIVE_DATE	DATE			Effective end date for position and element formulas
CONSTRAINT_FORMULA_ID	NUMBER	(15)	Yes	Constraint formula unique identifier
CONSTRAINT_ID	NUMBER	(15)	Yes	Constraint unique identifier
BUDGET_YEAR_TYPE_ID	NUMBER	(15)		Budget year type unique identifier. Formula applies to budget periods in the calendar with this type.
PAY_ELEMENT_ID	NUMBER	(15)		Pay element unique identifier. Element for which this element constraint or position constraint formula applies.
PAY_ELEMENT_OPTION_ID	NUMBER			Pay element option unique identifier
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		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 CONSTRAINT_NAME
,      STEP_NUMBER
,      _LA:PREFIX_OPERATOR
,      BUDGET_YEAR_TYPE_NAME
,      _LA:BALANCE_TYPE
,      GL_ACCOUNT
,      PAY_ELEMENT_NAME
,      PAY_ELEMENT_OPTION_NAME
,      _LA:ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE
,      CURRENCY_CODE
,      _LA:POSTFIX_OPERATOR
,      AMOUNT
,      ALLOW_MODIFY
,      _DF
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      CONSTRAINT_FORMULA_ID
,      CONSTRAINT_ID
,      BUDGET_YEAR_TYPE_ID
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_CONSTRAINT_FORMULAS;

Dependencies

[top of page]

APPS.PSBFV_CONSTRAINT_FORMULAS references the following:

APPS: PSB_BUDGET_YEAR_TYPES; PSB_CONSTRAINT_FORMULAS; PSB_ENTITY; PSB_PAY_ELEMENTS; PSB_PAY_ELEMENT_OPTIONS

APPS.PSBFV_CONSTRAINT_FORMULAS is not referenced by any database object