[Home] [Help] [Dependency Information]
Object Name: | PSB_BUDGET_REVISIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSB_BUDGET_REVISIONS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|