DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PSB_BUDGET_REVISION_ACCOUNTS_V

Object Details
Object Name: PSB_BUDGET_REVISION_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_BUDGET_REVISION_ACCOUNTS_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 Budget Revision line 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 Budget Group Unique Identifier
GL_BUDGET_VERSION_ID NUMBER (20)
GL_PERIOD_NAME VARCHAR2 (15) Yes Name of the GL Period for which the revision is made.
CURRENCY_CODE VARCHAR2 (15)
Functional Currency of the GL set of books or Statistical. This indicates the Budget Amount.
ACCOUNT_TYPE VARCHAR2 (10) Yes 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)
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)
'V' indicates that the revision was successful. 'I' indicates that the revision was unsuccessful.
FREEZE_FLAG VARCHAR2 (1)
'Y' indicates that the revision line cannot undergo further changes. Any other value indicates that the line can undergo changes.
VIEW_LINE_FLAG VARCHAR2 (1)
NOTE_ID NUMBER

Note Unique Identifier associated with the revision of Account/Position Line.
FUNDS_CONTROL_TIMESTAMP DATE

Timestamp when last Funds Check was done.
PERCENT_REVISED NUMBER

Indicates the percentage of revision if the revision_value_type is '%'
AMOUNT_REVISED NUMBER

Indicates the amount revised if the revision_value_type is 'A'
SEGMENT1 VARCHAR2 (25)
Key flexfield segment
SEGMENT2 VARCHAR2 (25)
Key flexfield segment
SEGMENT3 VARCHAR2 (25)
Key flexfield segment
SEGMENT4 VARCHAR2 (25)
Key flexfield segment
SEGMENT5 VARCHAR2 (25)
Key flexfield segment
SEGMENT6 VARCHAR2 (25)
Key flexfield segment
SEGMENT7 VARCHAR2 (25)
SEGMENT8 VARCHAR2 (25)
Key flexfield segment
SEGMENT9 VARCHAR2 (25)
Key flexfield segment
SEGMENT10 VARCHAR2 (25)
Key flexfield segment
SEGMENT11 VARCHAR2 (25)
Key flexfield segment
SEGMENT12 VARCHAR2 (25)
Key flexfield segment
SEGMENT13 VARCHAR2 (25)
Key flexfield segment
SEGMENT14 VARCHAR2 (25)
Key flexfield segment
SEGMENT15 VARCHAR2 (25)
Key flexfield segment
SEGMENT16 VARCHAR2 (25)
Key flexfield segment
SEGMENT17 VARCHAR2 (25)
Key flexfield segment
SEGMENT18 VARCHAR2 (25)
Key flexfield segment
SEGMENT19 VARCHAR2 (25)
Key flexfield segment
SEGMENT20 VARCHAR2 (25)
Key flexfield segment
SEGMENT21 VARCHAR2 (25)
Key flexfield segment
SEGMENT22 VARCHAR2 (25)
Key flexfield segment
SEGMENT23 VARCHAR2 (25)
Key flexfield segment
SEGMENT24 VARCHAR2 (25)
Key flexfield segment
SEGMENT25 VARCHAR2 (25)
Key flexfield segment
SEGMENT26 VARCHAR2 (25)
Key flexfield segment
SEGMENT27 VARCHAR2 (25)
Key flexfield segment
SEGMENT28 VARCHAR2 (25)
Key flexfield segment
SEGMENT29 VARCHAR2 (25)
Key flexfield segment
SEGMENT30 VARCHAR2 (25)
Key flexfield segment
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.
Query Text

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


SELECT ROW_ID
,      BUDGET_REVISION_ID
,      BUDGET_REVISION_ACCT_LINE_ID
,      CODE_COMBINATION_ID
,      BUDGET_GROUP_ID
,      GL_BUDGET_VERSION_ID
,      GL_PERIOD_NAME
,      CURRENCY_CODE
,      ACCOUNT_TYPE
,      BUDGET_BALANCE
,      ACTUAL_BALANCE
,      ENCUMBRANCE_BALANCE
,      REVISION_TYPE
,      REVISION_VALUE_TYPE
,      REVISION_AMOUNT
,      FUNDS_CONTROL_STATUS_CODE
,      FUNDS_CONTROL_RESULTS_CODE
,      FREEZE_FLAG
,      VIEW_LINE_FLAG
,      NOTE_ID
,      FUNDS_CONTROL_TIMESTAMP
,      PERCENT_REVISED
,      AMOUNT_REVISED
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSB_BUDGET_REVISION_ACCOUNTS_V;

Dependencies

[top of page]

APPS.PSB_BUDGET_REVISION_ACCOUNTS_V references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
SynonymPSB_BUDGET_REVISION_ACCOUNTS
SynonymPSB_BUDGET_REVISION_LINES
APPS.PSB_BUDGET_REVISION_ACCOUNTS_V is referenced by following:

SchemaAPPS
Package BodyPSB_BUDGET_REVISIONS_PVT - show dependent code
Package BodyPSB_PSBRPBRS_XMLP_PKG - show dependent code