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_PERF_KPA_SUMMARY_DET

Object Details

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

This table Records exception summary details for an object

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PERF_KPA_SUMMARY_DET_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	KPA_SUMMARY_DET_ID
PA_PERF_KPA_SUMMARY_DET_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	KPA_SUMMARY_ID KPA_CODE
PA_PERF_KPA_SUMMARY_DET_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID KPA_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
KPA_SUMMARY_DET_ID	NUMBER	(15)	Yes	Key performance area summary detail identifier.
KPA_SUMMARY_ID	NUMBER	(15)	Yes	Key performance area summary identifier.
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type.
OBJECT_ID	NUMBER	(15)	Yes	Object identifier.
KPA_CODE	VARCHAR2	(30)	Yes	Key performance area lookup code.
INDICATOR_CODE	VARCHAR2	(30)		Indicator lookup code.
COUNT	NUMBER	(15)		Exception Count.
SCORE	NUMBER	(15)		Score.
RULE_ID	NUMBER	(15)		Scoring rule identifier.
IND1_COUNT	NUMBER	(15)		Indicator 1 Exception Count.
IND1_SCORE	NUMBER	(15)		Indicator 1 Total Score.
IND2_COUNT	NUMBER	(15)		Indicator 2 Exception Count.
IND2_SCORE	NUMBER	(15)		Indicator 2 Total Score.
IND3_COUNT	NUMBER	(15)		Indicator 3 Exception Count.
IND3_SCORE	NUMBER	(15)		Indicator 3 Total Score.
IND4_COUNT	NUMBER	(15)		Indicator 4 Exception Count.
IND4_SCORE	NUMBER	(15)		Indicator 4 Total Score.
IND5_COUNT	NUMBER	(15)		Indicator 5 Exception Count.
IND5_SCORE	NUMBER	(15)		Indicator 5 Total Score.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
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

Query Text

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


SELECT KPA_SUMMARY_DET_ID
,      KPA_SUMMARY_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      KPA_CODE
,      INDICATOR_CODE
,      COUNT
,      SCORE
,      RULE_ID
,      IND1_COUNT
,      IND1_SCORE
,      IND2_COUNT
,      IND2_SCORE
,      IND3_COUNT
,      IND3_SCORE
,      IND4_COUNT
,      IND4_SCORE
,      IND5_COUNT
,      IND5_SCORE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_PERF_KPA_SUMMARY_DET;

Dependencies

[top of page]

PA.PA_PERF_KPA_SUMMARY_DET does not reference any database object

PA.PA_PERF_KPA_SUMMARY_DET is referenced by following:

APPS: PA_PERF_KPA_SUMMARY_DET