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

VIEW: APPS.PSBBV_POSITION_ACCOUNTS

Object Details
Object Name: PSBBV_POSITION_ACCOUNTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSBBV_POSITION_ACCOUNTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
POSITION_ACCOUNT_LINE_ID NUMBER (15) Yes Unique identifier for Position Control account distributions
POSITION_ID NUMBER (20) Yes Position unique identifier
BUDGET_REVISION_ID NUMBER (20)
Budget revision unique identifier
BUDGET_GROUP_ID NUMBER
Yes Budget group unique identifier
BASE_LINE_VERSION VARCHAR2 (1)
Indicates if the values were originally posted in budget preparation phase or the current values from budget revisions. Valid values are 'O' - original and 'C' - current
START_DATE DATE
Yes Start date of the year for which the cost distribution is maintained
END_DATE DATE
Yes End date of the year for which the cost distribution is maintained
CODE_COMBINATION_ID NUMBER (20) Yes General Ledger code combination unique identifier
CURRENCY_CODE VARCHAR2 (15) Yes Currency of the position control distribution amount
AMOUNT NUMBER
Yes Position Control annual distribution amount for the position for the account combination
Query Text

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


SELECT POSITION_ACCOUNT_LINE_ID
,      POSITION_ID
,      BUDGET_REVISION_ID
,      BUDGET_GROUP_ID
,      BASE_LINE_VERSION
,      START_DATE
,      END_DATE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      AMOUNT
FROM APPS.PSBBV_POSITION_ACCOUNTS;

Dependencies

[top of page]

APPS.PSBBV_POSITION_ACCOUNTS references the following:

SchemaAPPS
SynonymPSB_POSITION_ACCOUNTS

APPS.PSBBV_POSITION_ACCOUNTS is not referenced by any database object