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

TABLE: AP.AP_NEGOTIATION_HIST

Object Details
Object Name: AP_NEGOTIATION_HIST
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_NEGOTIATION_HIST
Subobject Name:
Status: VALID


AP_NEGOTIATION_HIST contains the information changed by the approver or supplier when negotiating an invoice line.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_NEGOTIATION_HIST_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNEGOTIATION_HIST_ID
AP_NEGOTIATION_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPROVAL_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
NEGOTIATION_HIST_ID NUMBER (15) Yes Negotiation History Identifier
APPROVAL_HISTORY_ID NUMBER (15) Yes Approval History Id
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ALTERED_FIELD_CODE VARCHAR2 (30)
Altered Column Name
ALTERED_FIELD_DATA_TYPE VARCHAR2 (30)
Altered Column Data Type
ORIGINAL_VALUE VARCHAR2 (240)
Value of the altered column before the Update
NEW_VALUE VARCHAR2 (240)
Value of the altered column after the Update
Query Text

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


SELECT NEGOTIATION_HIST_ID
,      APPROVAL_HISTORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ALTERED_FIELD_CODE
,      ALTERED_FIELD_DATA_TYPE
,      ORIGINAL_VALUE
,      NEW_VALUE
FROM AP.AP_NEGOTIATION_HIST;

Dependencies

[top of page]

AP.AP_NEGOTIATION_HIST does not reference any database object

AP.AP_NEGOTIATION_HIST is referenced by following:

SchemaAP
ViewAP_NEGOTIATION_HIST#