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

TABLE: GML.OP_AUDT_MST

Object Details
Object Name: OP_AUDT_MST
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_AUDT_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANGEORDER_ID
OP_AUDT_MSTI2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_ID
Columns
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"
Query Text

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;

Dependencies

[top of page]

GML.OP_AUDT_MST does not reference any database object

GML.OP_AUDT_MST is referenced by following:

SchemaGML
ViewOP_AUDT_MST#