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_DEFAULT_ACCOUNT_DISTRS

Object Details

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

PSB_DEFAULT_ACCOUNT_DISTRS stores information about the default
account distribution information for a given default rule. The
distribution is for salary cost only.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_DEFAULT_ACCOUNT_DISTRS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNT_DISTRIBUTION_ID
PSB_DEFAULT_ACCOUNT_DISTRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_DISTRIBUTION_ID	NUMBER	(20)	Yes	Default account distribution unique identifier
DEFAULT_RULE_ID	NUMBER	(20)	Yes	Default rule unique identifier. Identifies the rule to which this distribution belongs.
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Chart of Accounts identifier. For a default rule, different distribution sets are defined for each chart of accounts.
CODE_COMBINATION_ID	NUMBER	(20)	Yes	General Ledger code combination identifier. Account to which the distribution is charged.
DISTRIBUTION_PERCENT	NUMBER			Percent of the budget distributed to this account
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 ACCOUNT_DISTRIBUTION_ID
,      DEFAULT_RULE_ID
,      CHART_OF_ACCOUNTS_ID
,      CODE_COMBINATION_ID
,      DISTRIBUTION_PERCENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_DEFAULT_ACCOUNT_DISTRS;

Dependencies

[top of page]

PSB.PSB_DEFAULT_ACCOUNT_DISTRS does not reference any database object

PSB.PSB_DEFAULT_ACCOUNT_DISTRS is referenced by following:

APPS: PSB_DEFAULT_ACCOUNT_DISTRS