eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GML.OP_AUDT_DTL

Object Details

Object Name:	OP_AUDT_DTL
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_AUDT_DTL
Subobject Name:
Status:	VALID

This table contains the previous version of a sales order detail line if changes are made to a sales order line. The table is populated during sales order entry if Sales Order Audit Trail is turned on for the order type of the sales order. The current version of the sales order line is maintained in the table OP_ORDR_DTL and the previous version of the line is saved in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_AUDT_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGEORDER_LINE_ID
OP_AUDT_DTL_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANGEORDER_ID LINE_ID
OP_AUDT_DTLI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_TRACKED	DATE			Date that change was saved.
CHANGEORDER_ID	NUMBER	(10)	Yes	Fk to op_audt_mst.
LINE_ID	NUMBER	(10)	Yes	Line_id of order line; fk to op_ordr_dtl.
CHANGEORDER_LINE_ID	NUMBER	(10)	Yes	Unique identifier of audit trail line.
PRICEREAS_CODE	VARCHAR2	(4)		Reason for price change. In op_prce_cds.
CHANGE_COMMENT	VARCHAR2	(70)		Freeform text, comment line for changed line
ORDER_QTY1	NUMBER		Yes	Previous order qty1 from order line; contains old value of order qty1 before change
ORDER_UM1	VARCHAR2	(4)	Yes	Value of order_um1 from op_ordr_dtl for changed line before modification
QC_GRADE_WANTED	VARCHAR2	(4)		Value of qc grade wanted field from op_ordr_dtl before modification
SHIPPER_CODE	VARCHAR2	(4)	Yes	Value of shipper code from op_ordr_dtl before modification
SHIPCUST_ID	NUMBER	(10)	Yes	Value of shipcust id from op_ordr_dtl line before modification
SHIPADDR_ID	NUMBER	(10)	Yes	Value of shipaddr id from op_ordr_dtl for line before modification
TO_WHSE	VARCHAR2	(4)		Value of to_whse from op_ordr_dtl for line before modification
FROM_WHSE	VARCHAR2	(4)	Yes	Value of from_whse from op_ordr_dtl for line before modification
SCHED_SHIPDATE	DATE		Yes	Previous value of sched_shipdate before modification of line
NET_PRICE	NUMBER		Yes	Previous value of net_price field before modification of line
HOLDREAS_CODE	VARCHAR2	(4)	Yes	Previous value of holdreas_code before modification of line.
COMPLETED_IND	NUMBER	(5)	Yes	Previous value of completed_ind before modification of line
LINE_STATUS	NUMBER	(5)	Yes	Previous value of line_status before modification of line
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	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment

Query Text

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


SELECT DATE_TRACKED
,      CHANGEORDER_ID
,      LINE_ID
,      CHANGEORDER_LINE_ID
,      PRICEREAS_CODE
,      CHANGE_COMMENT
,      ORDER_QTY1
,      ORDER_UM1
,      QC_GRADE_WANTED
,      SHIPPER_CODE
,      SHIPCUST_ID
,      SHIPADDR_ID
,      TO_WHSE
,      FROM_WHSE
,      SCHED_SHIPDATE
,      NET_PRICE
,      HOLDREAS_CODE
,      COMPLETED_IND
,      LINE_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
FROM GML.OP_AUDT_DTL;

Dependencies

[top of page]

GML.OP_AUDT_DTL does not reference any database object

GML.OP_AUDT_DTL is referenced by following:

APPS: OP_AUDT_DTL