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_ACCOUNT_POSITION_SETS

Object Details

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

PSB_ACCOUNT_POSITION_SETS stores the definition of an account set or position set. Account sets are defined using range of accounts and position sets are defined using position attributes. The
ACCOUNT_OR_POSITION_TYPE field indicates if the current row is an account set or a position set.
The sets defined can be global or local sets. Global sets can be shared across multiple entities whereas local sets can be used only by the entity that created the set. Global sets are created using the Set Account Position set module. Any range of accounts set that is created to define
a budget group is also designated as global.
When a new set is created, a concurrent process builds a listing of all accounts that fall in the range or all positions that satisfy the conditions. This concurrent process can be set up to refresh the list on a periodic basis. The LAST_MAINTAINED_DATE stores the date and time when the concurrent process last ran for this set. For account sets, the MAX_CODE_COMBINATION_ID stores the highest code combination identifier that existed in the GL_CODE_COMBINATIONS table. This information is used so that the next time the process runs, only the incremental General Ledger code combinations that were created since the last run are processed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_ACCOUNT_POSITION_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNT_POSITION_SET_ID
PSB_ACCOUNT_POSITION_SETS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME ACCOUNT_OR_POSITION_TYPE DATA_EXTRACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_POSITION_SET_ID	NUMBER	(15)	Yes	Account position set unique identifier
NAME	VARCHAR2	(100)	Yes	Set name
SET_OF_BOOKS_ID	NUMBER	(15)		General Ledger Set of Books identifier used to identify Chart of Accounts for account sets
DATA_EXTRACT_ID	NUMBER	(15)		Data extract identifier used to identify data extract for position sets
GLOBAL_OR_LOCAL_TYPE	VARCHAR2	(1)		Identifies if it is a global or local set
ACCOUNT_OR_POSITION_TYPE	VARCHAR2	(1)	Yes	Identifies if it is an account set or a position set
ATTRIBUTE_SELECTION_TYPE	VARCHAR2	(1)		Identifies if the position set needs to match all or at least one criteria
BUSINESS_GROUP_ID	NUMBER	(15)		Business group identifier for position sets
BUDGET_GROUP_ID	NUMBER	(20)		Budget Group to which account or position set belongs. Gets populated only for those account or position sets created for budget revision.
MAINTAIN_STATUS	VARCHAR2	(1)		Maintains status of the account set for making account assignments
LAST_MAINTAINED_DATE	DATE			Last maintained date. When the ACCOUNT_SET was exploded into PSB_BUDGET_ACCOUNTS.
MAX_CODE_COMBINATION_ID	NUMBER	(15)		Maximum GL_CODE_COMBINATION_ID when the account set was exploded into PSB_BUDGET_ACCOUNTS
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
USE_IN_BUDGET_GROUP_FLAG	VARCHAR2	(1)		Specifies whether the account set can be used in Budget Group module or not.

Query Text

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


SELECT ACCOUNT_POSITION_SET_ID
,      NAME
,      SET_OF_BOOKS_ID
,      DATA_EXTRACT_ID
,      GLOBAL_OR_LOCAL_TYPE
,      ACCOUNT_OR_POSITION_TYPE
,      ATTRIBUTE_SELECTION_TYPE
,      BUSINESS_GROUP_ID
,      BUDGET_GROUP_ID
,      MAINTAIN_STATUS
,      LAST_MAINTAINED_DATE
,      MAX_CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      USE_IN_BUDGET_GROUP_FLAG
FROM PSB.PSB_ACCOUNT_POSITION_SETS;

Dependencies

[top of page]

PSB.PSB_ACCOUNT_POSITION_SETS does not reference any database object

PSB.PSB_ACCOUNT_POSITION_SETS is referenced by following:

APPS: PSB_ACCOUNT_POSITION_SETS; PSB_ACCOUNT_POSITION_SETS_T1