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

TABLE: PA.PA_PERF_OBJECT_RULES

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


This table stores the association between Exception Rule and the actual object


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_PERF_OBJECT_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_RULE_ID
PA_PERF_OBJECT_RULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_ID
ColumnRULE_ID
PA_PERF_OBJECT_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_RULE_ID NUMBER (15) Yes Performance rule and object association identifier
OBJECT_TYPE VARCHAR2 (30) Yes Object type
OBJECT_ID NUMBER (15) Yes Object identifier
RULE_ID NUMBER (15) Yes Performance rule identifier
RECORD_VERSION_NUMBER NUMBER (15) Yes Number used for record locking in self service applications
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 OBJECT_RULE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      RULE_ID
,      RECORD_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_PERF_OBJECT_RULES;

Dependencies

[top of page]

PA.PA_PERF_OBJECT_RULES does not reference any database object

PA.PA_PERF_OBJECT_RULES is referenced by following:

SchemaPA
ViewPA_PERF_OBJECT_RULES#