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_ORDR_DTX_INTERFACE

Object Details

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

OP_ORDR_DTX_INTERFACE (OPM Order Entry Open Interface Detail Text table) is one of the open interface tables used by the EDI transaction GPOI (Purchase Order Inbound). This particular table contains text data related to individual detail lines being imported (contained in the OP_ORDR_DTL_INTERFACE table). It contains foreign key oi_line_id which references the OP_ORDR_DTL_INTERFACE table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_DTX_INTERFACE_I0	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OI_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OI_LINE_ID	NUMBER		Yes	Reference to line from interface table that contains this text. fk to op_ordr_dtl_interface table.
ERROR_CODE	NUMBER			If a transaction error occurs, the Order Entry Open Interface will populate this field with an internal error code. See the error description and the transaction log file for a detailed explanation of the error.
ERROR_DESC	VARCHAR2	(240)		If a transaction error occurs, the Order Entry Open Interface will populate this field with an description of the error. See the transaction log file for more details of the error.
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
LANG_CODE	VARCHAR2	(4)		Language code indicates the language in which the text is written. fk to sy_lang_mst.
PARAGRAPH_CODE	VARCHAR2	(4)		Paragraph code distinguishes different text for one record. A user may enter several different types of text for a record, for example, an order may have shipping instructions, invoicing instructions and general notes. The paragraph code and subparagraph codes seperate these different types of text associated with one order (or one order line).
SUB_PARACODE	NUMBER			Allows sub grouping withen paragraph code.
LINE_NO	NUMBER			Line number which allows multiple lines of descrptive text for underlying record.
TEXT	VARCHAR2	(80)		Descriptive Text

Query Text

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


SELECT OI_LINE_ID
,      ERROR_CODE
,      ERROR_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LANG_CODE
,      PARAGRAPH_CODE
,      SUB_PARACODE
,      LINE_NO
,      TEXT
FROM GML.OP_ORDR_DTX_INTERFACE;

Dependencies

[top of page]

GML.OP_ORDR_DTX_INTERFACE does not reference any database object

GML.OP_ORDR_DTX_INTERFACE is referenced by following:

APPS: OP_ORDR_DTX_INTERFACE