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

TABLE: PON.PON_ACTION_HISTORY

Object Details
Object Name: PON_ACTION_HISTORY
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_ACTION_HISTORY
Subobject Name:
Status: VALID


PON_ACTION_HISTORY stores the information regarding to the action taken by the buyers on a specific negotiation, such as cancel, approve and reject.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_ACTION_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER
Yes Object id of this action. Could be auction number or bid number.
OBJECT_ID2 NUMBER
Yes Object id of the action. Could be auction number, bid number or transaction id.
OBJECT_TYPE_CODE VARCHAR2 (25) Yes Object Type Code
SEQUENCE_NUM NUMBER
Yes Not currently used.
ACTION_TYPE VARCHAR2 (25) Yes Action Type
ACTION_DATE DATE
Yes Date of Action
ACTION_USER_ID NUMBER
Yes Identifier of user who created this row (performed the action)
ACTION_NOTE VARCHAR2 (2000)
Note for this action
ACTION_REASON_CODE VARCHAR2 (25)
Code for reason for performing action
USER_NAME VARCHAR2 (100)
User Name of the action performer
FILE_ID NUMBER

Fnd lob file id.
REQUESTED_FOR_TPC_ID NUMBER

Used in surrogate bidding. This is supplier's trading partner contact id
SIGNED_DATE DATE

Amendment signed date
Query Text

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


SELECT OBJECT_ID
,      OBJECT_ID2
,      OBJECT_TYPE_CODE
,      SEQUENCE_NUM
,      ACTION_TYPE
,      ACTION_DATE
,      ACTION_USER_ID
,      ACTION_NOTE
,      ACTION_REASON_CODE
,      USER_NAME
,      FILE_ID
,      REQUESTED_FOR_TPC_ID
,      SIGNED_DATE
FROM PON.PON_ACTION_HISTORY;

Dependencies

[top of page]

PON.PON_ACTION_HISTORY does not reference any database object

PON.PON_ACTION_HISTORY is referenced by following:

SchemaPON
ViewPON_ACTION_HISTORY#