[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSBBV_CONSTRAINT_FORMULAS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PSB.PSBBV_CONSTRAINT_FORMULAS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
PSBBV_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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STEP_NUMBER | NUMBER | User-assigned sequence for constraint formula line | ||
| _LA:PREFIX_OPERATOR | CHAR | (73) | Formula line prefix operator. Valid prefix operators are +, -, *, /, =, >, <, >=, <=, and !=. | |
| _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. | |
| _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. | ||
| PAY_ELEMENT_ID | NUMBER | (15) | Pay element unique identifier. Element for which this element constraint or postion constraint formula applies. | |
| PAY_ELEMENT_OPTION_ID | NUMBER | Pay element option unique identifier | ||
| ALLOW_MODIFY | VARCHAR2 | (1) | Indicates if this element can be modified at the worksheet level | |
| 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. | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT STEP_NUMBER
, _LA:PREFIX_OPERATOR
, _LA:BALANCE_TYPE
, GL_ACCOUNT
, _LA:ELEMENT_VALUE_TYPE
, ELEMENT_VALUE
, CURRENCY_CODE
, _LA:POSTFIX_OPERATOR
, AMOUNT
, PAY_ELEMENT_ID
, PAY_ELEMENT_OPTION_ID
, ALLOW_MODIFY
, START_EFFECTIVE_DATE
, END_EFFECTIVE_DATE
, CONSTRAINT_FORMULA_ID
, CONSTRAINT_ID
, BUDGET_YEAR_TYPE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.PSBBV_CONSTRAINT_FORMULAS;
APPS
PSB_BUDGET_YEAR_TYPES
PSB_CONSTRAINT_FORMULAS
PSB_ENTITY
APPS.PSBBV_CONSTRAINT_FORMULAS is not referenced by any database object
|
|
|
|