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_ACTION_HISTORY

Object Details

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

PO_ACTION_HISTORY contains information about the approval and
control history of your purchasing documents. There is one record
in this table for each approval or control action an employee takes
on a purchase order, purchase agreement, release, or requisition.
Each row includes references to the document itself, the employee
who acted on the document, the date of the action, the type of
action taken on the document, and a note each employee can leave
when taking an action on the document.
.
Oracle Purchasing uses this information to display history information
about documents and to forward documents in the approval process
to the appropriate employee.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_ACTION_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID
PO_ACTION_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_ID
PO_ACTION_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE_CODE EMPLOYEE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Document header unique identifier
OBJECT_TYPE_CODE	VARCHAR2	(25)	Yes	Document type
OBJECT_SUB_TYPE_CODE	VARCHAR2	(25)	Yes	Document subtype
SEQUENCE_NUM	NUMBER		Yes	Sequence of the approval or control action for a document
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ACTION_CODE	VARCHAR2	(25)		Approval or control action type
ACTION_DATE	DATE			Approval or control action date
EMPLOYEE_ID	NUMBER	(9)		Unique identifier of the employee taking the action
APPROVAL_PATH_ID	NUMBER			Approval hierarchy unique identifier
NOTE	VARCHAR2	(4000)		Note for next approver or reason for control action
OBJECT_REVISION_NUM	NUMBER			Document revision number
OFFLINE_CODE	VARCHAR2	(25)		Indicates whether or not the document was sent to an offline approver
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_DATE	DATE			No longer used
APPROVAL_GROUP_ID	NUMBER			This column stores the approval group unique identifier of the employee/contactor in Oracle Approval Management.

Query Text

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


SELECT OBJECT_ID
,      OBJECT_TYPE_CODE
,      OBJECT_SUB_TYPE_CODE
,      SEQUENCE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ACTION_CODE
,      ACTION_DATE
,      EMPLOYEE_ID
,      APPROVAL_PATH_ID
,      NOTE
,      OBJECT_REVISION_NUM
,      OFFLINE_CODE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_DATE
,      APPROVAL_GROUP_ID
FROM PO.PO_ACTION_HISTORY;

Dependencies

[top of page]

PO.PO_ACTION_HISTORY does not reference any database object

PO.PO_ACTION_HISTORY is referenced by following:

PO: PO_ACTION_HISTORY#