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

TABLE: PA.PA_PM_CONTROL_ACTIONS

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


PA_PM_CONTROL_ACTIONS table holds all the actions that need to be
controlled in a project/budget that has been imported from an
external system.
The controls ensure that data in both Oracle Projects and the external
systems remain consistent.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_PM_CONTROL_ACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCONTROL_RULE_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CONTROL_RULE_ID NUMBER
Yes The unique identifier for the control action
ACTION VARCHAR2 (30) Yes The Intended Action that needs to be controlled
DESCRIPTION VARCHAR2 (80) Yes The Description of the Action
FIELD_VALUE_ALLOWED_FLAG VARCHAR2 (1) Yes Indicates whether Field Values are allowed (pertinent only to actions involving Budgets)
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CONTROL_RULE_ID
,      ACTION
,      DESCRIPTION
,      FIELD_VALUE_ALLOWED_FLAG
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM PA.PA_PM_CONTROL_ACTIONS;

Dependencies

[top of page]

PA.PA_PM_CONTROL_ACTIONS does not reference any database object

PA.PA_PM_CONTROL_ACTIONS is referenced by following:

SchemaPA
ViewPA_PM_CONTROL_ACTIONS#