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]

VIEW: APPS.PA_PERF_RULES_V

Object Details

Object Name:	PA_PERF_RULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PERF_RULES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER	(15)	Yes	Unique identifier of the rule.
RULE_NAME	VARCHAR2	(80)	Yes	Rule Name.
RULE_DESCRIPTION	VARCHAR2	(240)		Rule Description.
RULE_TYPE	VARCHAR2	(30)	Yes	Rule Type.
RULE_TYPE_NAME	VARCHAR2	(80)	Yes	Rule Type Name.
KPA_CODE	VARCHAR2	(30)	Yes	Key Performance Area to which this exception rule belongs.
KPA_NAME	VARCHAR2	(80)	Yes	Name of the Key Performance Area.
MEASURE_ID	NUMBER	(15)		Measurement ID.
MEASURE_NAME	VARCHAR2	(240)		Name of the measure.
MEASURE_FORMAT	VARCHAR2	(30)		Measure Format.
CURRENCY_TYPE	VARCHAR2	(30)		Currency Type.
PERIOD_TYPE	VARCHAR2	(30)		Calendar Type, GL or PA.
PRECISION	NUMBER	(10)		Precision.
START_DATE_ACTIVE	DATE		Yes	Start Date Active.
END_DATE_ACTIVE	DATE			End Date Active.
SCORE_METHOD	VARCHAR2	(30)		Scoring Rule. MIN, MAX or SUM.
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Number used for record locking in self service applications.
CREATION_DATE	DATE		Yes
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 RULE_ID
,      RULE_NAME
,      RULE_DESCRIPTION
,      RULE_TYPE
,      RULE_TYPE_NAME
,      KPA_CODE
,      KPA_NAME
,      MEASURE_ID
,      MEASURE_NAME
,      MEASURE_FORMAT
,      CURRENCY_TYPE
,      PERIOD_TYPE
,      PRECISION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SCORE_METHOD
,      RECORD_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.PA_PERF_RULES_V;

Dependencies

[top of page]

APPS.PA_PERF_RULES_V references the following:

APPS: PA_LOOKUPS; PA_PERF_RULES; PJI_MT_MEASURES_V

APPS.PA_PERF_RULES_V is referenced by following:

APPS: PA_PERF_OBJECT_RULES_V