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_ALLOCRULE_PERCENTS

Object Details

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

PSB_ALLOCRULE_PERCENTS stores 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. If it is a percentage distribution, then the
allocation percents are stored in this table. The distributions can be
defined for twelve monthly breakdowns, four quarterly breakdowns,
or two semi-annual period breakdowns. The NUMBER_OF_PERIODS will
have 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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_ALLOCRULE_PERCENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ALLOCATION_RULE_PERCENT_ID
PSB_ALLOCRULE_PERCENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ALLOCATION_RULE_ID NUMBER_OF_PERIODS PERIOD_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
ALLOCATION_RULE_PERCENT_ID	NUMBER	(20)	Yes	Allocation percent unique identifier
ALLOCATION_RULE_ID	NUMBER	(20)	Yes	Allocation rule unique identifier
NUMBER_OF_PERIODS	NUMBER		Yes	Total number of periods in this allocation spread is 12 for Year, 4 for Quarter, and 2 for Semi-Annual.
PERIOD_NUM	NUMBER		Yes	Number for the period the allocation is defined
PERCENT	NUMBER			Percent of the yearly budget estimate allocated to this period
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
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield context

Query Text

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


SELECT ALLOCATION_RULE_PERCENT_ID
,      ALLOCATION_RULE_ID
,      NUMBER_OF_PERIODS
,      PERIOD_NUM
,      PERCENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
FROM PSB.PSB_ALLOCRULE_PERCENTS;

Dependencies

[top of page]

PSB.PSB_ALLOCRULE_PERCENTS does not reference any database object

PSB.PSB_ALLOCRULE_PERCENTS is referenced by following:

APPS: PSB_ALLOCRULE_PERCENTS