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_HTX_INTERFACE

Object Details

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

OP_ORDR_HTX_INTERFACE (OPM Order Entry Open Interface Header Text table) is one of the open interface tables used by the EDI transaction GPOI (Purchase Order Inbound). This particular table contains text related to the sales order being imported. It contains foreign key oi_order_id which references the OP_ORDR_HDR_INTERFACE table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_HTX_INTERFACE_I0	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OI_ORDER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OI_ORDER_ID	NUMBER		Yes	Reference to order from interface table that contains this text. fk to op_ordr_hdr_interface table.
ERROR_CODE	NUMBER			If a transaction error occurs, the Order Entry Open Interface will populate
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_ORDER_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_HTX_INTERFACE;

Dependencies

[top of page]

GML.OP_ORDR_HTX_INTERFACE does not reference any database object

GML.OP_ORDR_HTX_INTERFACE is referenced by following:

APPS: OP_ORDR_HTX_INTERFACE