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: TablePO.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_ACTION_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
PO_ACTION_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMPLOYEE_ID
PO_ACTION_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_TYPE_CODE
ColumnEMPLOYEE_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:

SchemaPO
ViewPO_ACTION_HISTORY#