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]

TABLE: PSB.PSB_BUDGET_REVISIONS

Object Details

Object Name:	PSB_BUDGET_REVISIONS
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_BUDGET_REVISIONS
Subobject Name:
Status:	VALID

PSB_BUDGET_REVISIONS stores the budget revision headers. A budget revision groups multiple budget revision transactions that are simultaneously applied.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_BUDGET_REVISIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_REVISION_ID
PSB_BUDGET_REVISIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_GROUP_ID

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 for which budget revision is created
GL_BUDGET_SET_ID	NUMBER	(20)		Unique Identifier for the General Ledger budget set associated with the budget revision
FROM_GL_PERIOD_NAME	VARCHAR2	(15)		Start General Ledger period in the range of periods for which the budget revision has to be done
TO_GL_PERIOD_NAME	VARCHAR2	(15)		End General Ledger period in the range of periods for which the budget revision has to be done
CURRENCY_CODE	VARCHAR2	(15)		Functional currency of the General Ledger Set of Books or STAT. This indicates the currency of the budget revision amounts.
EFFECTIVE_START_DATE	DATE			Effective start date for position mass budget revisions
EFFECTIVE_END_DATE	DATE			Effective end date for mass position budget revisions
BUDGET_REVISION_TYPE	VARCHAR2	(1)	Yes	Indicates whether the budget to be revised is a commitment budget or regular budget. Valid values are C (Commitment Budget), O (Others).
TRANSACTION_TYPE	VARCHAR2	(30)		Indicates the type of budget revision transaction such as Budget Transfer or 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)		Indicates if this is a revision for accounts only or for positions and accounts. Valid values are Y or N.
BALANCE_TYPE	VARCHAR2	(4)	Yes	Balance type for the current budget balance in the budget revision. Valid values are PTD (Period to Date), QTD (Quarter to Date), YTD (Year to Date), PJTD (Project to Date).
REQUESTOR	NUMBER	(20)	Yes	Identifier of the user who requests for the budget revision
PARAMETER_SET_ID	NUMBER	(15)		Parameter set unique identifier associated with the budget revision and used for mass budget revisions
CONSTRAINT_SET_ID	NUMBER	(20)		Constraint set unique identifier associated with the budget revision and used for mass budget revisions
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_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 or N.
REQUEST_ID	NUMBER			Concurrent request identifier for the last freeze process
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
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 segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield segment column
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield context
APPROVAL_ORIG_SYSTEM	VARCHAR2	(30)		Originating system of the Workflow role chosento override regular approval hierarchy.
HR_BUDGET_ID	NUMBER	(20)		Unique identifier for the HR Position Control Budget associated with the Budget Revision.

Query Text

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


SELECT BUDGET_REVISION_ID
,      JUSTIFICATION
,      BUDGET_GROUP_ID
,      GL_BUDGET_SET_ID
,      FROM_GL_PERIOD_NAME
,      TO_GL_PERIOD_NAME
,      CURRENCY_CODE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUDGET_REVISION_TYPE
,      TRANSACTION_TYPE
,      PERMANENT_REVISION
,      REVISE_BY_POSITION
,      BALANCE_TYPE
,      REQUESTOR
,      PARAMETER_SET_ID
,      CONSTRAINT_SET_ID
,      SUBMISSION_DATE
,      SUBMISSION_STATUS
,      APPROVAL_OVERRIDE_BY
,      FREEZE_FLAG
,      REQUEST_ID
,      BASE_LINE_REVISION
,      GLOBAL_BUDGET_REVISION
,      GLOBAL_BUDGET_REVISION_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
,      APPROVAL_ORIG_SYSTEM
,      HR_BUDGET_ID
FROM PSB.PSB_BUDGET_REVISIONS;

Dependencies

[top of page]

PSB.PSB_BUDGET_REVISIONS does not reference any database object

PSB.PSB_BUDGET_REVISIONS is referenced by following:

APPS: PSB_BUDGET_REVISIONS