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_CAPITAL_EVENTS

Object Details

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

Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_CAPITAL_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAPITAL_EVENT_ID
PA_CAPITAL_EVENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID CAPITAL_EVENT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CAPITAL_EVENT_ID	NUMBER	(15)	Yes	Capital event identifier.
PROJECT_ID	NUMBER	(15)	Yes	The system generated number that uniquely identifies the project.
CAPITAL_EVENT_NUMBER	NUMBER	(15)	Yes	Number that identifies the event within the Project.
EVENT_TYPE	VARCHAR2	(30)	Yes	Event Classification. Available values are "C" = "Capital" and "R" = "Retirement".
EVENT_NAME	VARCHAR2	(240)	Yes	User defined event name.
ASSET_ALLOCATION_METHOD	VARCHAR2	(30)	Yes	Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level.
EVENT_PERIOD	VARCHAR2	(15)		General Ledger Period associated with the event.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
REQUEST_ID	NUMBER	(15)		Standard Program Update column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Program Update column.
PROGRAM_ID	NUMBER	(15)		Standard Program Update column.
PROGRAM_UPDATE_DATE	DATE			Standard Program Update column.

Query Text

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


SELECT CAPITAL_EVENT_ID
,      PROJECT_ID
,      CAPITAL_EVENT_NUMBER
,      EVENT_TYPE
,      EVENT_NAME
,      ASSET_ALLOCATION_METHOD
,      EVENT_PERIOD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM PA.PA_CAPITAL_EVENTS;

Dependencies

[top of page]

PA.PA_CAPITAL_EVENTS does not reference any database object

PA.PA_CAPITAL_EVENTS is referenced by following:

APPS: PA_CAPITAL_EVENTS