[Home] [Help] [Dependency Information]
Object Name: | OP_AUDT_MST |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.OP_AUDT_MST |
Subobject Name: | |
Status: | VALID |
This table contains the header records which link all change records for a sales orderdetail line. Changes made to a sales order generate a row in this table and rows in the OP_AUDT_DTL table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OP_AUDT_MST_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHANGEORDER_ID |
OP_AUDT_MSTI2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORDER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATE_TRACKED | DATE | Date that record was saved. | ||
CHANGEORDER_ID | NUMBER | (10) | Yes | Unique identifier for changes made in a session to one order |
OP_REAS_CODE | VARCHAR2 | (4) | General reason code for change; fk to sy_reas_cds. | |
ORDER_ID | NUMBER | (10) | Yes | Order_id references the order that has been changed. Fk to op_ordr_hdr. |
CHANGE_COMMENT | VARCHAR2 | (70) | Freeform text, comments to explain change | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
DELETE_MARK | NUMBER | (5) | Yes | Flag to indicate logical deletion; 0 means active and 1 means "deleted" |
Cut, paste (and edit) the following text to query this object:
SELECT DATE_TRACKED
, CHANGEORDER_ID
, OP_REAS_CODE
, ORDER_ID
, CHANGE_COMMENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
FROM GML.OP_AUDT_MST;
GML.OP_AUDT_MST does not reference any database object
GML.OP_AUDT_MST is referenced by following:
|
|
|