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]

TABLE: PO.PO_CLM_ASSGNMT_ACTION_HISTORY

Object Details

Object Name:	PO_CLM_ASSGNMT_ACTION_HISTORY
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_CLM_ASSGNMT_ACTION_HISTORY
Subobject Name:
Status:	VALID

This table stores the history of buyer workload assignment status changes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER		Yes	Unique Identifier of the Workload Assignment undergoing the status change
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
OLD_STATUS	NUMBER		Yes	Old status of the Workload Assignment from which it has been changed to the new status
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NEW_STATUS	NUMBER		Yes	The new status of the Workload Assignment
OLD_BUYER_ID	NUMBER		Yes	The BUYER_ID of the Buyer who was working on the Workload Assignment before this status change
NEW_BUYER_ID	NUMBER		Yes	New Buyer ID
REASON	VARCHAR2	(500)		The reason why the status of this Workload Assignment was changed
ACTION_START_DATE	DATE		Yes	Date on which the Workload Assignment has been changed to the NEW_STATUS
ACTION_END_DATE	DATE			Date till which the status of the Workload Assignment is the NEW_STATUS
ACTION_TAKEN_BY	NUMBER		Yes	User Id of the person who performed this status change on the Workload Assignment

Query Text

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


SELECT ASSIGNMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OLD_STATUS
,      LAST_UPDATE_LOGIN
,      NEW_STATUS
,      OLD_BUYER_ID
,      NEW_BUYER_ID
,      REASON
,      ACTION_START_DATE
,      ACTION_END_DATE
,      ACTION_TAKEN_BY
FROM PO.PO_CLM_ASSGNMT_ACTION_HISTORY;

Dependencies

[top of page]

PO.PO_CLM_ASSGNMT_ACTION_HISTORY does not reference any database object

PO.PO_CLM_ASSGNMT_ACTION_HISTORY is referenced by following:

PO: PO_CLM_ASSGNMT_ACTION_HISTORY#