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: PA.PA_BC_BALANCES

Object Details

Object Name:	PA_BC_BALANCES
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BC_BALANCES
Subobject Name:
Status:	VALID

PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are created by maintain project balances program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BC_BALANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID PROJECT_ID BALANCE_TYPE START_DATE END_DATE TASK_ID TOP_TASK_ID PARENT_MEMBER_ID RESOURCE_LIST_MEMBER_ID SET_OF_BOOKS_ID
PA_BC_BALANCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
PA_BC_BALANCES_N4	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("PARENT_MEMBER_ID",(-99))
PA_BC_BALANCES_N5	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("PARENT_MEMBER_ID",(-99))
PA_BC_BALANCES_N6	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("PARENT_MEMBER_ID",(-99))

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Project identifier
TASK_ID	NUMBER	(15)	Yes	Task identifier
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes	Resource list member identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger identifier
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget version identifier of the budget for which the balance is created
BALANCE_TYPE	VARCHAR2	(10)	Yes	Balance indicates the balance for any of these calegories
START_DATE	DATE		Yes	The start date of the balance record calculated based on the amount type set in the budgetary controls
END_DATE	DATE		Yes	The end date of the balance record calculated based on the boundary code set in the budgetary controls
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
TOP_TASK_ID	NUMBER	(15)		Top task identifier
PARENT_MEMBER_ID	NUMBER	(15)		Resource list member of the resource group
REQUEST_ID	NUMBER	(15)		Request id of a concurrent program
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
PERIOD_NAME	VARCHAR2	(15)		The name of the accounting period in which the balance is created
ACTUAL_PERIOD_TO_DATE	NUMBER			The period-to-date actual amount
BUDGET_PERIOD_TO_DATE	NUMBER			The period-to-date budget amount
ENCUMB_PERIOD_TO_DATE	NUMBER			The period-to-date encumberance amount.

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      SET_OF_BOOKS_ID
,      BUDGET_VERSION_ID
,      BALANCE_TYPE
,      START_DATE
,      END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TOP_TASK_ID
,      PARENT_MEMBER_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PERIOD_NAME
,      ACTUAL_PERIOD_TO_DATE
,      BUDGET_PERIOD_TO_DATE
,      ENCUMB_PERIOD_TO_DATE
FROM PA.PA_BC_BALANCES;

Dependencies

[top of page]

PA.PA_BC_BALANCES does not reference any database object

PA.PA_BC_BALANCES is referenced by following:

APPS: PA_BC_BALANCES