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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
BUDGET_REVISION_ID	NUMBER	(20)	Yes	Unique identifier for Budget Revision
JUSTIFICATION	VARCHAR2	(240)		A brief description about the Budget Revision.
BUDGET_GROUP_ID	NUMBER	(20)	Yes	Budget Group identifier , the accounts are positions
BUDGET_GROUP_NAME	VARCHAR2	(20)	Yes	Budget group name
GL_BUDGET_SET_ID	NUMBER	(20)		Unique Identifier for the Budget Set Associated with the Budget Revision.
HR_BUDGET_ID	NUMBER	(20)		Unique identifier for the HR Position Control Budget associated with the Budget Revision.
CONSTRAINT_SET_ID	NUMBER	(20)		Unique Identifier for the Constraint Set Associated with the Budget Revision.
BUDGET_REVISION_TYPE	VARCHAR2	(1)	Yes	Specifies if the revision is forCommitment Budgets/Others.
FROM_GL_PERIOD_NAME	VARCHAR2	(15)		The GL from period of the range of periodsfor which the budget revision has to be done.
TO_GL_PERIOD_NAME	VARCHAR2	(15)		The GL from period of the range of periodsfor which the budget revision has to be done.
EFFECTIVE_START_DATE	DATE			Effective Start date for position budget revisions.Indicates the start date of the From GL Period in caseof account budget revisions.
EFFECTIVE_END_DATE	DATE			Effective End date for position budget revisions.Indicates the endt date of theTo GL Period in caseof account budget revisions.
TRANSACTION_TYPE	VARCHAR2	(30)		Revision Category to Classify the nature of requests of budget revision.
CURRENCY_CODE	VARCHAR2	(15)		Functional Currency of the General ledger Set of Books or Statistical.This indiactes the currency of the budget amount.
PERMANENT_REVISION	VARCHAR2	(1)	Yes	'Y' indicates if the effects of revision should
REVISE_BY_POSITION	VARCHAR2	(1)		Flag indicating whether it is a Position Revision or not.
BALANCE_TYPE	VARCHAR2	(4)	Yes	Indicates whether to fetch 'PTD' - period to date or 'YTD' - year to date budget transfer balance for accounts that are involved in the budget revision.
PARAMETER_SET_ID	NUMBER	(15)
PARAMETER_SET_NAME	VARCHAR2	(80)		Entity set name
REQUESTOR	NUMBER	(20)	Yes	Name of the person initiating the Budget Revision.
REQUESTOR_NAME	VARCHAR2	(100)	Yes	Application username (what a user types in at the Oracle Applications sign-on screen)
SUBMISSION_DATE	DATE			Date on which the Budget Revision was submitted for Approval.
SUBMISSION_STATUS	VARCHAR2	(1)		Status indicating if the submission process is complete/incomplete/error.'C' - complete, 'I' - incomplete , 'E' - error.
FREEZE_FLAG	VARCHAR2	(1)		Flag = 'Y' indicates that the Budget Revision is frozenand further changes not allowed .
APPROVAL_ORIG_SYSTEM	VARCHAR2	(30)		Originating system of the Workflow role chosento override regular approval hierarchy.
APPROVAL_OVERRIDE_BY	NUMBER			Name of the person who can override the approval
BASE_LINE_REVISION	VARCHAR2	(1)		If 'Y' indicates that the budget revsion is a version of the original budget that was a result of thebudget preparation phase.
GLOBAL_BUDGET_REVISION	VARCHAR2	(1)		'Y' indicates that the budget revsion is a global one.
GLOBAL_BUDGET_REVISION_ID	NUMBER	(20)		Global Budget Revision Identifier.
REQUEST_ID	NUMBER			Concurrent request identifier for the last freeze process.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE22	VARCHAR2	(150)
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield Column.
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield Column.
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield structure

Query Text

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


SELECT ROW_ID
,      BUDGET_REVISION_ID
,      JUSTIFICATION
,      BUDGET_GROUP_ID
,      BUDGET_GROUP_NAME
,      GL_BUDGET_SET_ID
,      HR_BUDGET_ID
,      CONSTRAINT_SET_ID
,      BUDGET_REVISION_TYPE
,      FROM_GL_PERIOD_NAME
,      TO_GL_PERIOD_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      TRANSACTION_TYPE
,      CURRENCY_CODE
,      PERMANENT_REVISION
,      REVISE_BY_POSITION
,      BALANCE_TYPE
,      PARAMETER_SET_ID
,      PARAMETER_SET_NAME
,      REQUESTOR
,      REQUESTOR_NAME
,      SUBMISSION_DATE
,      SUBMISSION_STATUS
,      FREEZE_FLAG
,      APPROVAL_ORIG_SYSTEM
,      APPROVAL_OVERRIDE_BY
,      BASE_LINE_REVISION
,      GLOBAL_BUDGET_REVISION
,      GLOBAL_BUDGET_REVISION_ID
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CONTEXT
FROM APPS.PSB_BUDGET_REVISIONS_V;

Dependencies

[top of page]

APPS.PSB_BUDGET_REVISIONS_V references the following:

APPS: FND_USER; PSB_BUDGET_GROUPS; PSB_BUDGET_REVISIONS; PSB_ENTITY_SET

APPS.PSB_BUDGET_REVISIONS_V is referenced by following:

APPS: PSB_BUDGET_REVISIONS_PVT - show dependent code; PSB_CONCURRENCY_CONTROL_PVT - show dependent code; PSB_SUBMIT_REVISION_PVT - show dependent code