DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_ACCUM_TXN_TIME

Object Details
Object Name: PA_ACCUM_TXN_TIME
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_ACCUM_TXN_TIME
Subobject Name:
Status: VALID


PA_ACCUM_TXN_TIME stores the timing statistics for the projects processed in the update or refresh projects summary processes. The profile PA: Log Summarization Statistics should be set to capture the timing statistics. The columns Attribute1 to Attribute20 have various values depending upon the context.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER
Yes The identifier of the project for which the time statistics are recorded
PROJECT_NUM VARCHAR2 (25) Yes The project number for which the time statistics are recorded
REQUEST_ID NUMBER
Yes The identifier of the concurrent request for which the time statistics are recorded
ATTRIBUTE1 DATE

Time statistics attribute 1
ATTRIBUTE2 DATE

Time statistics attribute 2
ATTRIBUTE3 DATE

Time statistics attribute 3
ATTRIBUTE4 DATE

Time statistics attribute 4
ATTRIBUTE5 DATE

Time statistics attribute 5
ATTRIBUTE6 DATE

Time statistics attribute 6
ATTRIBUTE7 DATE

Time statistics attribute 7
ATTRIBUTE8 DATE

Time statistics attribute 8
ATTRIBUTE9 DATE

Time statistics attribute 9
ATTRIBUTE10 DATE

Time statistics attribute 10
ATTRIBUTE11 DATE

Time statistics attribute 11
ATTRIBUTE12 DATE

Time statistics attribute 12
ATTRIBUTE13 DATE

Time statistics attribute 13
ATTRIBUTE14 DATE

Time statistics attribute 14
ATTRIBUTE15 DATE

Time statistics attribute 15
ATTRIBUTE16 DATE

Time statistics attribute 16
ATTRIBUTE17 DATE

Time statistics attribute 17
ATTRIBUTE18 DATE

Time statistics attribute 18
ATTRIBUTE19 DATE

Time statistics attribute 19
ATTRIBUTE20 DATE

Time statistics attribute 20
Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUM
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM PA.PA_ACCUM_TXN_TIME;

Dependencies

[top of page]

PA.PA_ACCUM_TXN_TIME does not reference any database object

PA.PA_ACCUM_TXN_TIME is referenced by following:

SchemaPA
ViewPA_ACCUM_TXN_TIME#