PO_RECENT_ACTIVITIES
This table is created to capture the activities that happen on Purchasing Documents. This table will store historical information about the activities that are relevant to Recent Activities region.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PO_RECENT_ACTIVITIES_PK |
RECENT_ACTIVITY_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RECENT_ACTIVITY_ID | NUMBER | 18 | Yes | System-generated unique identifier. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
OBJECT_ID | NUMBER | 18 | Yes | Unique identifier of the object specified by the OBJECT_TYPE column. | |
OBJECT_TYPE | VARCHAR2 | 30 | Yes | Type of object on which the activity took place. | |
PO_VERSION_ID | NUMBER | 18 | Version Identifier of the Purchasing Object on which the activity took place. | ||
ACTIVITY_TYPE | VARCHAR2 | 50 | Yes | Type of activity for a particular object. | |
ACTIVITY_DATE | TIMESTAMP | Yes | Date of activity on which activity is performed. | ||
AGENT_ID | NUMBER | 18 | Buyer unique identifier. (References PO_AGENTS.agent_id) | ||
PERFORMED_BY_ID | NUMBER | 18 | Identifier of the person who has taken this action. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PO_RECENT_ACTIVITIES | po_headers_all | OBJECT_ID |
PO_RECENT_ACTIVITIES | po_versions | PO_VERSION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PO_RECENT_ACTIVITIES_N1 | Non Unique | Default | AGENT_ID, OBJECT_TYPE |
PO_RECENT_ACTIVITIES_N2 | Non Unique | Default | OBJECT_TYPE, ACTIVITY_TYPE |
PO_RECENT_ACTIVITIES_U1 | Unique | Default | RECENT_ACTIVITY_ID |