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_BUDGET_REVISION_ACCOUNTS

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_REVISION_ID	NUMBER	(20)	Yes	Budget Revision unique identifier.
BUDGET_REVISION_ACCT_LINE_ID	NUMBER	(20)	Yes	Budget Revision line unique identifier.
CODE_COMBINATION_ID	NUMBER	(20)	Yes	General Ledger Code Combination Unique Identifier
BUDGET_GROUP_ID	NUMBER	(20)	Yes
GL_PERIOD_NAME	VARCHAR2	(15)	Yes	Name of the GL Period for which the revision is made.
GL_BUDGET_VERSION_ID	NUMBER	(20)		General Ledger budget version unique identifier. The budget version from which budget amounts are extracted to be revised. If budgetary control is used in General Ledger then the budget amounts are extracted from the budget for the account
CURRENCY_CODE	VARCHAR2	(15)		Functional Currency of the GL set of books or Statistical. This indicates the Budget Amount.
_LA:ACCOUNT_TYPE	CHAR	(53)		General Ledger account type. A (Asset), L (Liability), O (Equity), R (Revenue), or E (Expense).
BUDGET_BALANCE	NUMBER			Original Budget Amount with the accumulated approved budget revision.
ACTUAL_BALANCE	NUMBER			Actual Amount posted in GL.
ENCUMBRANCE_BALANCE	NUMBER			Expenditure Amount encumbered in GL.
REVISION_TYPE	VARCHAR2	(1)		'I' indicates increased revision, 'D' indicates decreased revision.
REVISION_VALUE_TYPE	VARCHAR2	(1)		Budget revision value type. 'A' - amount, 'P' - percentage
REVISION_AMOUNT	NUMBER			The amount of change effected on the Account/Positiondue to the Budget Revision.
FUNDS_CONTROL_STATUS_CODE	VARCHAR2	(1)		Revision Status Code
FUNDS_CONTROL_RESULTS_CODE	VARCHAR2	(3)		Funds Control Results Code
FUNDS_CONTROL_TIMESTAMP	DATE			Timestamp when last Funds Check was done.
FREEZE_FLAG	VARCHAR2	(1)		'Y' indicates that the revision line cannot undergo further changes. Any other value indicates that the line can undergo changes.
NOTE_ID	NUMBER			Note unique identifier associated with the revision of the transaction line

Query Text

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


SELECT BUDGET_REVISION_ID
,      BUDGET_REVISION_ACCT_LINE_ID
,      CODE_COMBINATION_ID
,      BUDGET_GROUP_ID
,      GL_PERIOD_NAME
,      GL_BUDGET_VERSION_ID
,      CURRENCY_CODE
,      _LA:ACCOUNT_TYPE
,      BUDGET_BALANCE
,      ACTUAL_BALANCE
,      ENCUMBRANCE_BALANCE
,      REVISION_TYPE
,      REVISION_VALUE_TYPE
,      REVISION_AMOUNT
,      FUNDS_CONTROL_STATUS_CODE
,      FUNDS_CONTROL_RESULTS_CODE
,      FUNDS_CONTROL_TIMESTAMP
,      FREEZE_FLAG
,      NOTE_ID
FROM APPS.PSBBV_BUDGET_REVISION_ACCOUNTS;

Dependencies

[top of page]

APPS.PSBBV_BUDGET_REVISION_ACCOUNTS references the following:

APPS: PSB_BUDGET_REVISION_ACCOUNTS; PSB_BUDGET_REVISION_LINES

APPS.PSBBV_BUDGET_REVISION_ACCOUNTS is not referenced by any database object