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

VIEW: APPS.PSBBV_ALLOCATION_PERCENTAGES

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

View Type

A Business Intelligence System view


PSBBV_ALLOCATION_PERCENTAGES displays the percentage allocation for each period for a given allocation rule. An allocation rule can be based on a prior year profile or a percentage distribution. The distributions can be defined for twelve monthly breakdowns, four quarterly breakdowns, or two semi-annual period breakdowns. The NUMBER_OF PERIODS has a value of 12, 4, or 2 to indicate the type of breakdown. For each type of allocation, a percent is defined for each period.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERIOD_NUMBER NUMBER
Yes Period number for which the allocation is defined
MONTHLY NUMBER

Monthly distribution percent
QUARTERLY NUMBER

Quarterly distribution percent
SEMI_ANNUAL NUMBER

Semi-annual distribution percent
ALLOCATION_PERCENTAGE_ID NUMBER (20) Yes Allocation percent unique identifier
ALLOCATION_RULE_ID NUMBER (20) Yes Allocation rule unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes 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 PERIOD_NUMBER
,      MONTHLY
,      QUARTERLY
,      SEMI_ANNUAL
,      ALLOCATION_PERCENTAGE_ID
,      ALLOCATION_RULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBBV_ALLOCATION_PERCENTAGES;

Dependencies

[top of page]

APPS.PSBBV_ALLOCATION_PERCENTAGES references the following:

SchemaAPPS
SynonymPSB_ALLOCRULE_PERCENTS
SynonymPSB_ENTITY

APPS.PSBBV_ALLOCATION_PERCENTAGES is not referenced by any database object