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_SUMM_BALANCES

Object Details

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

PA_SUMM_BALANCES stores summarized balance informations for reporting objects.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_SUMM_BALANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERIOD_TYPE OBJECT_TYPE_CODE OBJECT_ID VERSION_ID PERIOD_SET_NAME PERIOD_NAME GLOBAL_EXP_PERIOD_END_DATE AMOUNT_TYPE_ID
PA_SUMM_BALANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_TYPE OBJECT_TYPE_CODE OBJECT_ID VERSION_ID PERIOD_YEAR PERIOD_SET_NAME QUARTER_OR_MONTH_NUMBER
PA_SUMM_BALANCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_TYPE OBJECT_TYPE_CODE OBJECT_ID VERSION_ID PERIOD_SET_NAME PERIOD_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(15)	Yes	The identifier of the object for which the balance is created
VERSION_ID	NUMBER		Yes	The identifier of the balance version
OBJECT_TYPE_CODE	VARCHAR2	(30)	Yes	The object type
PERIOD_TYPE	VARCHAR2	(2)	Yes	The internal identifier of the period type for the period included in the balance. Values can be: PA ( balances are accrued based on PA Periods), GL ( balances are accrued based on GL Periods), GE ( balances are accrued based on Global Expenditure Weeks as defined at the site level)
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	The accounting calendar associated with the ledger. This column stores a dummy value ("SUMM-DUMMY") for non-accounting periods (global expenditure week).
PERIOD_NAME	VARCHAR2	(15)	Yes	The name of the period for which the balance is created. This column stores a dummy value ("SUMM-DUMMY") for non-accounting periods ( global expenditure week )
GLOBAL_EXP_PERIOD_END_DATE	DATE		Yes	The global expenditure period for which the balance is created. This column stores a dummy value ("09-OCT-1492") for accounting periods ( PA and GL )
PERIOD_YEAR	NUMBER		Yes	The accounting period year for the accouting periods. For non-accounting periods ( global expenditure week ), this column stores the year in which the global expenditure period falls
QUARTER_OR_MONTH_NUMBER	NUMBER		Yes	For balances based on PA or GL periods, the number of the quarter that contains the Period. For balances based on the global expenditure week, the month number.
AMOUNT_TYPE_ID	NUMBER		Yes	The identifier of the amount type associated with the balance.
PERIOD_NUM	NUMBER			The accounting period number for which the balance is created
UNIT_OF_MEASURE	VARCHAR2	(30)		The unit of measure
PERIOD_BALANCE	NUMBER			The period to date balance in the project currency
GLOBAL_CURRENCY_CODE	VARCHAR2	(15)		The global currency code
GLOBAL_PERIOD_BALANCE	NUMBER			The period to date balance in the global currency
DENOM_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code
DENOM_PERIOD_BALANCE	NUMBER			The period to date balance in the transaction currency
PVDR_CURRENCY_CODE	VARCHAR2	(15)		The expenditure functional currency Code
PVDR_PERIOD_BALANCE	NUMBER			The period to date balance in the expenditure functional currency
RCVR_CURRENCY_CODE	VARCHAR2	(15)		The project functional currency code
RCVR_PERIOD_BALANCE	NUMBER			The period to date balance in the project functional currency
PROJ_CURRENCY_CODE	VARCHAR2	(15)		The project currency code
PROJ_PERIOD_BALANCE	NUMBER			The period to date balance in the project currency

Query Text

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


SELECT OBJECT_ID
,      VERSION_ID
,      OBJECT_TYPE_CODE
,      PERIOD_TYPE
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      GLOBAL_EXP_PERIOD_END_DATE
,      PERIOD_YEAR
,      QUARTER_OR_MONTH_NUMBER
,      AMOUNT_TYPE_ID
,      PERIOD_NUM
,      UNIT_OF_MEASURE
,      PERIOD_BALANCE
,      GLOBAL_CURRENCY_CODE
,      GLOBAL_PERIOD_BALANCE
,      DENOM_CURRENCY_CODE
,      DENOM_PERIOD_BALANCE
,      PVDR_CURRENCY_CODE
,      PVDR_PERIOD_BALANCE
,      RCVR_CURRENCY_CODE
,      RCVR_PERIOD_BALANCE
,      PROJ_CURRENCY_CODE
,      PROJ_PERIOD_BALANCE
FROM PA.PA_SUMM_BALANCES;

Dependencies

[top of page]

PA.PA_SUMM_BALANCES does not reference any database object

PA.PA_SUMM_BALANCES is referenced by following:

APPS: PA_SUMM_BALANCES