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_WS_DISTRIBUTION_DETAILS

Object Details

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

PSB_DISTRIBUTION_DETAILS stores information about the worksheets and budget revisions created for each instance of the distribution process. When a worksheet or budget revision is distributed to different budget groups, a child worksheet is created for each budget group. The WORKSHEET_ID and BUDGET_GROUP_ID are stored in this table. When a new line is added to a child worksheet, this information is used to determine all the parent worksheets to which the line must be added. This information is also used during redistribution to determine if a worksheet or budget revision already exists for a given budget group.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_WS_DISTRIBUTION_DETAIL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID
PSB_WS_DISTRIBUTION_DETAIL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKSHEET_ID
PSB_WS_DISTRIBUTION_DETAIL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHILD_BUDGET_GROUP_ID CHILD_WORKSHEET_ID GLOBAL_WORKSHEET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DISTRIBUTION_ID	NUMBER	(15)	Yes	Distribution unique identifier
WORKSHEET_ID	NUMBER	(15)	Yes	Unique identifier for source worksheet or budget revision being distributed
GLOBAL_WORKSHEET_ID	NUMBER	(15)		Unique identifier for global worksheet or budget revision from which the source worksheet or budget revision is created
CHILD_WORKSHEET_ID	NUMBER	(15)	Yes	Unique identifier for worksheet or budget revision created for the budget group from the source worksheet or budget revision.
CHILD_BUDGET_GROUP_ID	NUMBER	(15)	Yes	Unique identifier of budget group to which the worksheet or budget revision is being distributed
BUDGET_GROUP_RESP_ID	NUMBER	(14)	Yes	Budget group responsibility unique identifier

Query Text

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


SELECT DISTRIBUTION_ID
,      WORKSHEET_ID
,      GLOBAL_WORKSHEET_ID
,      CHILD_WORKSHEET_ID
,      CHILD_BUDGET_GROUP_ID
,      BUDGET_GROUP_RESP_ID
FROM PSB.PSB_WS_DISTRIBUTION_DETAILS;

Dependencies

[top of page]

PSB.PSB_WS_DISTRIBUTION_DETAILS does not reference any database object

PSB.PSB_WS_DISTRIBUTION_DETAILS is referenced by following:

APPS: PSB_WS_DISTRIBUTION_DETAILS