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_SET_RELATIONS

Object Details

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

PSB_SET_RELATIONS stores the assignment of account or position
sets to various entities like budget groups, parameters, constraints,
and allocation rules. Once defined, account sets and position sets
can be shared across multiple entities. The use of an account or
position set by an entity is stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_SET_RELATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_RELATION_ID
PSB_SET_RELATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARAMETER_ID
PSB_SET_RELATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONSTRAINT_ID
PSB_SET_RELATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_GROUP_ID
PSB_SET_RELATIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ALLOCATION_RULE_ID
PSB_SET_RELATIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_WORKFLOW_RULE_ID
PSB_SET_RELATIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_POSITION_SET_ID
PSB_SET_RELATIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_RULE_ID
PSB_SET_RELATIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_SET_GROUP_ID
PSB_SET_RELATIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_BUDGET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_RELATION_ID	NUMBER	(15)	Yes	Unique identifier for a set-to-entity relation
ACCOUNT_POSITION_SET_ID	NUMBER	(15)	Yes	Account position set identifier. Each entity is associated with an account position set identifier.
ALLOCATION_RULE_ID	NUMBER	(15)		Allocation rule identifier
BUDGET_GROUP_ID	NUMBER	(15)		Budget group unique identifier
BUDGET_WORKFLOW_RULE_ID	NUMBER	(15)		Budget workflow rule identifier
CONSTRAINT_ID	NUMBER	(15)		Constraint identifier
DEFAULT_RULE_ID	NUMBER	(15)		Position default rule identifier
PARAMETER_ID	NUMBER	(15)		Parameter identifier
POSITION_SET_GROUP_ID	NUMBER	(15)		Position set group identifier
GL_BUDGET_ID	NUMBER	(15)		General Ledger budget identifier
EFFECTIVE_START_DATE	DATE			Effective start date for budget group relations
EFFECTIVE_END_DATE	DATE			Effective end date for budget group relations
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
RULE_ID	NUMBER	(15)		Not used currently
APPLY_BALANCE_FLAG	VARCHAR2	(1)		Not currently used

Query Text

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


SELECT SET_RELATION_ID
,      ACCOUNT_POSITION_SET_ID
,      ALLOCATION_RULE_ID
,      BUDGET_GROUP_ID
,      BUDGET_WORKFLOW_RULE_ID
,      CONSTRAINT_ID
,      DEFAULT_RULE_ID
,      PARAMETER_ID
,      POSITION_SET_GROUP_ID
,      GL_BUDGET_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      RULE_ID
,      APPLY_BALANCE_FLAG
FROM PSB.PSB_SET_RELATIONS;

Dependencies

[top of page]

PSB.PSB_SET_RELATIONS does not reference any database object

PSB.PSB_SET_RELATIONS is referenced by following:

APPS: PSB_SET_RELATIONS