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_DTL_INTERFACE

Object Details

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

OP_ORDR_DTL_INTERFACE (OPM Order Entry Open Interface Detail table) is one of the open interface tables used by the EDI transaction GPOI (Purchase Order Inbound). This particular table contains details of individual lines being imported into the OPM sales order system. Each line may or may not have entries in the OP_ORDR_DTX_INTERFACE and OP_ORDR_DAC_INTERFACE tables. The lines must be associated with an order in the OP_ORDR_HDR_INTERFACE table (Sales order header). When the EDI process is completed, ie. a sales order is generated, this line will be deleted from the table. If the sales order associated with this line is not completed the entry will remain in the table until it is. This contains foreign key oi_order_id which references the OP_ORDR_HDR_INTERFACE table, as well as foreign keys to OPM Sales Order tables. It also contains the surrogate key for detail lines oi_line_id which is generated from OP_ORDR_DTL_INTERFACE_S.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_DTL_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	OI_LINE_ID
OP_ORDR_DTL_INTERFACE_I0	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OI_ORDER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OI_LINE_ID	NUMBER		Yes	Surrogate key for detaill ines in open interface table. Generated from OP_ORDR_DTL_INTERFACE_S sequence;
OI_ORDER_ID	NUMBER		Yes	Reference to order from interface table that contains this detail. fk to op_ordr_hdr_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
ORDER_SOURCE_ID	NUMBER			ID of source of order. Valid Values are: 6- EDI.
LINE_NO	NUMBER			Line Number for the detail. Must start at 1 and increment by 1.
LINE_COMMENT	VARCHAR2	(80)		Freeform text/comments
LINE_ACTION	VARCHAR2	(1)		Code for type of action. Only supported action is 'N' for new sales line.
FROM_WHSE	VARCHAR2	(4)		Shipping warehouse; fk to ic_whse_mst.
CUST_LINE_NO	NUMBER			Line Number on customers PO.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Segment
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
SHIPTO_CUST_ADDR_ID	NUMBER			Default address id of shipping destination. fk to ra_addresses_all
SHIPTO_CUST_ID	NUMBER			Default id of shipping destination customer. fk to ra_customers
SHIPTO_CUST_NAME	VARCHAR2	(240)		Customer Name for Ship To Customer
SHIPTO_ADDR1	VARCHAR2	(240)		Address Line 1 for Ship To Customer Address.
SHIPTO_ADDR2	VARCHAR2	(240)		Address Line 2 for Ship To Customer Address.
SHIPTO_ADDR3	VARCHAR2	(240)		Address Line 3 for Ship To Customer Address.
SHIPTO_ADDR4	VARCHAR2	(240)		Address Line 4 for Ship To Customer Address.
SHIPTO_CITY	VARCHAR2	(30)		City for Ship To Customer Address.
SHIPTO_POSTAL_CODE	VARCHAR2	(16)		Postal Code for Ship To Customer Address.
SHIPTO_COUNTY	VARCHAR2	(30)		County for Ship To Customer Address
SHIPTO_COUNTRY	VARCHAR2	(20)		Country for Ship To Customer Address
SHIPTO_STATE	VARCHAR2	(20)		State for Ship To Customer Address.
SHIPTO_PROVINCE	VARCHAR2	(20)		Province for Ship To Customer Address
SHIPTO_LAST_NAME	VARCHAR2	(50)		Last Name of Contact for Ship To Customer.
SHIPTO_FIRST_NAME	VARCHAR2	(40)		First Name of Contact for Ship To Customer
SHIPTO_JOB_TITLE	VARCHAR2	(50)		Job Title of Contact for Ship To Customer.
SHIPTO_AREA_CODE	VARCHAR2	(10)		Area Code of Contact for Ship To Customer.
SHIPTO_PHONE_NUMBER	VARCHAR2	(60)		Phone Number of Contact for Ship To Customer.
BILLING_CURRENCY	VARCHAR2	(4)		Currency that customer will be billed in. Defaults from bill to customer. fk to gl_curr_mst.
BASE_CURRENCY	VARCHAR2	(4)		Currency of organization identified with order. Must be specified if an exchange rate is specified and must match organizations base currency
CONVERSION_TYPE	VARCHAR2	(4)		Required if an exchange rate is specified. fk to gl_rate_typ
EXCHANGE_RATE	NUMBER			Exchange rate between billing and base currency.
EXCHANGE_RATE_DATE	DATE			Required if exchange rate specified. fk to gl_xchg_rte.
FRTBILL_MTHD	VARCHAR2	(4)		Freight bill method default. fk to op_frgt_mth.
EMBARKATION_PORT	VARCHAR2	(8)		Port of loading/port of discharge. fk to op_port_mst.
DEBARKATION_PORT	VARCHAR2	(8)		Port of entry/port shipment is unloaded. fk to op_port_mst
TERMS_CODE	VARCHAR2	(4)		Payment terms code. fk to op_term_mst.
FOB_CODE	VARCHAR2	(4)		Free-on-board code default. fk to op_fobc_mst.
SHIPPER_CODE	VARCHAR2	(4)		fk to op_ship_mst. Sets defaults for lines.
SHIP_MTHD	VARCHAR2	(4)		fk to op_ship_mth. Sets defaults for lines.
SCHED_SHIPDATE	DATE			Scheduled ship date. default for all order lines. Date used as transaction date for pending inventory transactions for the order.
REQUIRED_DLVDATE	DATE			Required Delivery Date. Date required by customer. Default for all order lines. Date used to calculate scheduled ship date.
REQUESTED_DLVDATE	DATE			Date requested for shipment. Default for the order lines.
COA_REQUIRED	VARCHAR2	(2)		Indicates if certificate of analysis is required for order
LINE_DESC	VARCHAR2	(70)		description of item ordered.
GENERIC_ITEM	VARCHAR2	(40)		The generic or customer item number. This is the number that the customer generally uses or is generally used throughout the industry. fk to op_gnrc_itm.
ITEM_NO	VARCHAR2	(40)		Required of generic item not used. Name of the item. fk to ic_item_mst.
QC_GRADE_WANTED	VARCHAR2	(4)		QC grade requested by customer for this item. Used to assign lots to this order during automatic lot allocation, otherwise, a guide for manual allocation. Only applicable for grade controlled items.
NET_PRICE	NUMBER			This is the price that the customer will be charged for this order line. In price_um and billing_currency.
PRICEREAS_CODE	VARCHAR2	(4)		Required if a net_price is entered. Reason Code for the price change. fk to op_prce_cds.
PRICE_UM	VARCHAR2	(4)		If specified must match the uom corresponding to the base_price and system_price.
ORDER_QTY1	NUMBER			Quantity ordered in unit of measure 1.
ORDER_UM1	VARCHAR2	(4)		Order unit of measure 1. fk to sy_uoms_mst.
ORDER_QTY2	NUMBER			Quantity ordered in unit of measure 2. This uom is always equivalent to item_um2.
ORDER_UM2	VARCHAR2	(4)		Order unit of measure 2. fk to sy_uoms_mst. If specified this uom must equal item_um2 and cannot be changed.

Query Text

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


SELECT OI_LINE_ID
,      OI_ORDER_ID
,      ERROR_CODE
,      ERROR_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORDER_SOURCE_ID
,      LINE_NO
,      LINE_COMMENT
,      LINE_ACTION
,      FROM_WHSE
,      CUST_LINE_NO
,      ATTRIBUTE_CATEGORY
,      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
,      SHIPTO_CUST_ADDR_ID
,      SHIPTO_CUST_ID
,      SHIPTO_CUST_NAME
,      SHIPTO_ADDR1
,      SHIPTO_ADDR2
,      SHIPTO_ADDR3
,      SHIPTO_ADDR4
,      SHIPTO_CITY
,      SHIPTO_POSTAL_CODE
,      SHIPTO_COUNTY
,      SHIPTO_COUNTRY
,      SHIPTO_STATE
,      SHIPTO_PROVINCE
,      SHIPTO_LAST_NAME
,      SHIPTO_FIRST_NAME
,      SHIPTO_JOB_TITLE
,      SHIPTO_AREA_CODE
,      SHIPTO_PHONE_NUMBER
,      BILLING_CURRENCY
,      BASE_CURRENCY
,      CONVERSION_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      FRTBILL_MTHD
,      EMBARKATION_PORT
,      DEBARKATION_PORT
,      TERMS_CODE
,      FOB_CODE
,      SHIPPER_CODE
,      SHIP_MTHD
,      SCHED_SHIPDATE
,      REQUIRED_DLVDATE
,      REQUESTED_DLVDATE
,      COA_REQUIRED
,      LINE_DESC
,      GENERIC_ITEM
,      ITEM_NO
,      QC_GRADE_WANTED
,      NET_PRICE
,      PRICEREAS_CODE
,      PRICE_UM
,      ORDER_QTY1
,      ORDER_UM1
,      ORDER_QTY2
,      ORDER_UM2
FROM GML.OP_ORDR_DTL_INTERFACE;

Dependencies

[top of page]

GML.OP_ORDR_DTL_INTERFACE does not reference any database object

GML.OP_ORDR_DTL_INTERFACE is referenced by following:

APPS: OP_ORDR_DTL_INTERFACE