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_POSITION_ACCOUNTS

Object Details

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

PSB_POSITION_ACCOUNTS stores position control account distribution information with the baseline values from budget revisions. This is an interface table for Position Control into which position account distributions are populated before posting to any Position Control system.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_POSITION_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	POSITION_ACCOUNT_LINE_ID
PSB_POSITION_ACCOUNTS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	POSITION_ID
PSB_POSITION_ACCOUNTS_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BUDGET_REVISION_ID
PSB_POSITION_ACCOUNTS_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BUDGET_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_ACCOUNT_LINE_ID	NUMBER	(15)	Yes	Unique identifier for Position Control account distributions
POSITION_ID	NUMBER	(20)	Yes	Position unique identifier
START_DATE	DATE		Yes	Start date for which the cost distribution is maintained
END_DATE	DATE		Yes	End date for which the cost distribution is maintained
CODE_COMBINATION_ID	NUMBER	(20)	Yes	General Ledger code combination unique identifier
BUDGET_GROUP_ID	NUMBER		Yes	Budget group unique identifier
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency of the position control distribution amount
AMOUNT	NUMBER		Yes	Position Control distribution amount for the position for the account combination
BUDGET_REVISION_ID	NUMBER	(20)		Budget revision unique identifier
BASE_LINE_VERSION	VARCHAR2	(1)		Base line version is O (Original Values from Budget Preparation) or C (Current Values from Position Control)
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
HR_POSITION_ID	NUMBER	(20)		Unique identifier for position in source Human Resource Management System
HR_BUDGET_ID	NUMBER	(20)		Oracle HRMS Position Control Budget Identifier
TRANSFER_TO_PC_FLAG	VARCHAR2	(1)		Flag indicating whether record has been posted to position control or not

Query Text

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


SELECT POSITION_ACCOUNT_LINE_ID
,      POSITION_ID
,      START_DATE
,      END_DATE
,      CODE_COMBINATION_ID
,      BUDGET_GROUP_ID
,      CURRENCY_CODE
,      AMOUNT
,      BUDGET_REVISION_ID
,      BASE_LINE_VERSION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      HR_POSITION_ID
,      HR_BUDGET_ID
,      TRANSFER_TO_PC_FLAG
FROM PSB.PSB_POSITION_ACCOUNTS;

Dependencies

[top of page]

PSB.PSB_POSITION_ACCOUNTS does not reference any database object

PSB.PSB_POSITION_ACCOUNTS is referenced by following:

APPS: PSB_POSITION_ACCOUNTS