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_BUDGET_REVISIONS

Object Details

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

View Type

A Business Intelligence System view

PSBFV_BUDGET_REVISIONS displays Budget Revision information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_REVISION_ID	NUMBER	(20)	Yes	Budget revision unique identifier
JUSTIFICATION	VARCHAR2	(240)		Textual justification for the budget revision
BUDGET_GROUP_ID	NUMBER	(20)	Yes
BUDGET_GROUP_SHORT_NAME	VARCHAR2	(20)	Yes	Short Name of Budget Group associated to the revision.
BALANCE_TYPE	VARCHAR2	(4)	Yes
GL_BUDGET_SET_ID	NUMBER	(20)
GL_BUDGET_SET_NAME	VARCHAR2	(80)		General Ledger Budget Set assigned to the revision
FROM_GL_PERIOD_NAME	VARCHAR2	(15)		Start GL period in the range of periods for which the mass budget revision has to be done
TO_GL_PERIOD_NAME	VARCHAR2	(15)		End GL period in the range of periods for which the mass budget revision has to be done
EFFECTIVE_START_DATE	DATE			Effective start date for position mass budget revisions
EFFECTIVE_END_DATE	DATE			Effective end date for position mass budget revisions
_LA:BUDGET_REVISION_TYPE	CHAR	(69)		Indicates whether the budget to be revised is a commitment budget or regular budget.'C' - indicates commitment budget,'O' - indicates others
_LA:TRANSACTION_TYPE	CHAR	(71)		Indicates the type of budget revision transaction, e.g Budget Transfer / Budget Adjustments
PERMANENT_REVISION	VARCHAR2	(1)	Yes	Indicates if the budget revisions are permanent or temporary. If the budget revision is temporary it should not be considered for projecting budgets for the future years
REVISE_BY_POSITION	VARCHAR2	(1)
REQUESTOR	NUMBER	(20)	Yes	Employee identifier of the user who requests for the budget revision
PARAMETER_SET_ID	NUMBER	(15)
PARAMETER_SET_NAME	VARCHAR2	(80)		Name of parameter set used for creating revision
CONSTRAINT_SET_ID	NUMBER	(20)
CONSTRAINT_SET_NAME	VARCHAR2	(80)		Name of constraint set used for validating budget revision
SUBMISSION_DATE	DATE			Date on which the budget revision is submitted for approval
SUBMISSION_STATUS	VARCHAR2	(1)		Indicates status of budget revision submission. Valid values are 'C' - complete, 'I' - incomplete , 'E' - error
APPROVAL_ORIG_SYSTEM	VARCHAR2	(30)		Originating system of the Workflow role chosento override regular approval hierarchy.
APPROVAL_OVERRIDE_BY	NUMBER			Indicates the overriding approver for the budget revision which bypasses the normal approval hierarchy
FREEZE_FLAG	VARCHAR2	(1)		Indicates if the budget revision is frozen and cannot accept further revisions until unfrozen. Valid values are 'Y' and 'N'
BASE_LINE_REVISION	VARCHAR2	(1)		Indicates if the budget revision is a version of the original budget that was posted from the budget preparation phase
GLOBAL_BUDGET_REVISION	VARCHAR2	(1)		Indicates if this is a global budget revision. A global budget revision can be distributed to lower-level budget groups using distribution rules
GLOBAL_BUDGET_REVISION_ID	NUMBER	(20)		Unique identifier for the global budget revision from which this distributed budget revision was created
_DF	CHAR	(31)		Descriptive Flexfield Column

Query Text

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


SELECT BUDGET_REVISION_ID
,      JUSTIFICATION
,      BUDGET_GROUP_ID
,      BUDGET_GROUP_SHORT_NAME
,      BALANCE_TYPE
,      GL_BUDGET_SET_ID
,      GL_BUDGET_SET_NAME
,      FROM_GL_PERIOD_NAME
,      TO_GL_PERIOD_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      _LA:BUDGET_REVISION_TYPE
,      _LA:TRANSACTION_TYPE
,      PERMANENT_REVISION
,      REVISE_BY_POSITION
,      REQUESTOR
,      PARAMETER_SET_ID
,      PARAMETER_SET_NAME
,      CONSTRAINT_SET_ID
,      CONSTRAINT_SET_NAME
,      SUBMISSION_DATE
,      SUBMISSION_STATUS
,      APPROVAL_ORIG_SYSTEM
,      APPROVAL_OVERRIDE_BY
,      FREEZE_FLAG
,      BASE_LINE_REVISION
,      GLOBAL_BUDGET_REVISION
,      GLOBAL_BUDGET_REVISION_ID
,      _DF
FROM APPS.PSBFV_BUDGET_REVISIONS;

Dependencies

[top of page]

APPS.PSBFV_BUDGET_REVISIONS references the following:

APPS: FND_GLOBAL - show dependent code; PSB_BUDGET_GROUPS; PSB_BUDGET_GROUP_RESP; PSB_BUDGET_REVISIONS; PSB_ENTITY_SET; PSB_GL_BUDGET_SETS

APPS.PSBFV_BUDGET_REVISIONS is not referenced by any database object