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

TABLE: PA.PA_PM_PRODUCT_CONTROL_RULES

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


PA_PM_PRODUCT_CONTROL_RULES holds information about the various
actions to be controlled for a specific external product. An
entry in this table indicates that an action is not allowed by
the product that created the original project, task, or budget record.
The related Oracle Projects forms do not allow any modification to
such imported records.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_PM_PRODUCT_CONTROL_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCONTROL_RULE_ID
ColumnPM_PRODUCT_CODE
Columns
Name Datatype Length Mandatory Comments
CONTROL_RULE_ID NUMBER
Yes The identifier for the control action
PM_PRODUCT_CODE VARCHAR2 (30) Yes The identifier of the external system
FIELD_VALUE_CODE VARCHAR2 (30)
Holds the field value code for certain field names (like AC for Cost Budget)
START_DATE_ACTIVE DATE
Yes The effective start date
END_DATE_ACTIVE DATE

The effective end date
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT CONTROL_RULE_ID
,      PM_PRODUCT_CODE
,      FIELD_VALUE_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM PA.PA_PM_PRODUCT_CONTROL_RULES;

Dependencies

[top of page]

PA.PA_PM_PRODUCT_CONTROL_RULES does not reference any database object

PA.PA_PM_PRODUCT_CONTROL_RULES is referenced by following:

SchemaAPPS
SynonymPA_PM_PRODUCT_CONTROL_RULES