[Home] [Help] [Dependency Information]
Object Name: | PON_ACTION_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_ACTION_HISTORY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OBJECT_ID |
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 |
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
FROM PON.PON_ACTION_HISTORY;
PON.PON_ACTION_HISTORY does not reference any database object
PON.PON_ACTION_HISTORY is referenced by following:
|
|
|