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_HDR_INTERFACE

Object Details

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

OP_ORDR_HDR_INTERFACE (Order Header GPOI open interface table) is one of the open interface tables used by the EDI transaction GPOI (Purchase Order Inbound). This particular table contains header information related to the sales order being imported. It contains one sales order per record. Each entry in this table must be associated with at least one entry in the op_ordr_dtl_interface table. In addition it may be associated with text information stored in op_ordr_htx_interface or charge information stored in op_ordr_hac_interface. When the EDI process is completed, ie. a sales order is generated, the associated entry in this table will be deleted. If the sales order associated with this line is not completed the entry will remain in the table until it is. This table contains surrogate key oi_order_id which is generated from op_ordr_hdr_interface_s sequence.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_HDR_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	OI_ORDER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OI_ORDER_ID	NUMBER		Yes	Surrogate key for orders in open interface table. Generated from OP_ORDR_HDR_INTERFACE_S sequence;
PROCESS_FLAG	NUMBER		Yes	This column controls whether rows in the interface table are processed or not. The valid values are: 1 - Yes, 2 - Re Process, 3 -Error
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
ORDER_TYPE_CODE	VARCHAR2	(8)		Order type code for order from op_ordr_typ table
CUSTPO_NO	VARCHAR2	(32)		Customer Purchase Order Number
CUSTPO_DATE	DATE			Date of Customer Purchase Order
ORDER_NO	VARCHAR2	(32)		Sales Order Number for the order. If the Organizaion is using manually generated Sales Order Numbers than this column is required, if not then the field should be blank or null.
ORGN_CODE	VARCHAR2	(4)		Organizaion Code for the order. All sales orders are organization specific; fk to sy_orgn_mst.
ORDER_COMMENT	VARCHAR2	(80)		Freeform text/comments
SO_ACTION	VARCHAR2	(1)		Code for type of action. Only supported action is 'N' for new sales order.
FROM_WHSE	VARCHAR2	(4)		Shipping warehouse; fk to ic_whse_mst.
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
BILLTO_CUST_ADDR_ID	NUMBER			Default address id of third party to be invoiced. fk to ra_addresses_all
BILLTO_CUST_ID	NUMBER			Default id of third party to be invoiced. fk to ra_customers.
BILLTO_CUST_NAME	VARCHAR2	(240)		Customer Name for Bill To Customer
BILLTO_ADDR1	VARCHAR2	(240)		Address Line 1 for Bill To Customer Address
BILLTO_ADDR2	VARCHAR2	(240)		Address Line 2 for Bill To Customer Address
BILLTO_ADDR3	VARCHAR2	(240)		Address Line 3 for Bill To Customer Address.
BILLTO_ADDR4	VARCHAR2	(240)		Address Line 4 for Bill To Customer Address.
BILLTO_CITY	VARCHAR2	(30)		City for Bill To Customer Address.
BILLTO_POSTAL_CODE	VARCHAR2	(16)		Postal Code for Bill To Customer Address
BILLTO_COUNTY	VARCHAR2	(30)		County for Bill To Customer Address
BILLTO_COUNTRY	VARCHAR2	(20)		Country for Bill To Customer Address.
BILLTO_STATE	VARCHAR2	(20)		State for Bill To Customer Address
BILLTO_PROVINCE	VARCHAR2	(20)		Province for Bill To Customer Address.
BILLTO_LAST_NAME	VARCHAR2	(50)		Last Name of Contact for Bill To Customer.
BILLTO_FIRST_NAME	VARCHAR2	(40)		First Name of Contact for Bill To Customer.
BILLTO_JOB_TITLE	VARCHAR2	(50)		Job Title of Contact for Bill To Customer.
BILLTO_AREA_CODE	VARCHAR2	(10)		Area Code of Contact for Bill To Customer.
BILLTO_PHONE_NUMBER	VARCHAR2	(60)		Phone Number of Contact for Bill To Customer
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
SOLDTO_CUST_ADDR_ID	NUMBER			Default address id of sold to customer. fk to ra_addresses_all
SOLDTO_CUST_ID	NUMBER			Default id of sold to customer. fk to ra_customers.
SOLDTO_CUST_NAME	VARCHAR2	(240)		Customer Name for Sold To Customer
SOLDTO_ADDR1	VARCHAR2	(240)		Address Line 1 for Sold To Customer Address
SOLDTO_ADDR2	VARCHAR2	(240)		Address Line 2 for Sold To Customer Address
SOLDTO_ADDR3	VARCHAR2	(240)		Address Line 3 for Sold To Customer Address
SOLDTO_ADDR4	VARCHAR2	(240)		Address Line 4 for Sold To Customer Address
SOLDTO_CITY	VARCHAR2	(30)		City for Sold To Customer Address
SOLDTO_POSTAL_CODE	VARCHAR2	(16)		Postal Code for Sold To Customer Address
SOLDTO_COUNTY	VARCHAR2	(30)		County for Sold To Customer Address
SOLDTO_COUNTRY	VARCHAR2	(20)		Country for Sold To Customer Address
SOLDTO_STATE	VARCHAR2	(20)		State for Sold To Customer Address.
SOLDTO_PROVINCE	VARCHAR2	(20)		Province for Sold To Customer Address
SOLDTO_LAST_NAME	VARCHAR2	(50)		Last Name of Contact for Sold To Customer
SOLDTO_FIRST_NAME	VARCHAR2	(40)		First Name of Contact for Sold To Customer.
SOLDTO_JOB_TITLE	VARCHAR2	(50)		Job Title of Contact for Sold To Customer.
SOLDTO_AREA_CODE	VARCHAR2	(10)		Area Code of Contact for Sold To Customer
SOLDTO_PHONE_NUMBER	VARCHAR2	(60)		Phone Number of Contact for Sold 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

Query Text

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


SELECT OI_ORDER_ID
,      PROCESS_FLAG
,      ERROR_CODE
,      ERROR_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORDER_SOURCE_ID
,      ORDER_TYPE_CODE
,      CUSTPO_NO
,      CUSTPO_DATE
,      ORDER_NO
,      ORGN_CODE
,      ORDER_COMMENT
,      SO_ACTION
,      FROM_WHSE
,      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
,      BILLTO_CUST_ADDR_ID
,      BILLTO_CUST_ID
,      BILLTO_CUST_NAME
,      BILLTO_ADDR1
,      BILLTO_ADDR2
,      BILLTO_ADDR3
,      BILLTO_ADDR4
,      BILLTO_CITY
,      BILLTO_POSTAL_CODE
,      BILLTO_COUNTY
,      BILLTO_COUNTRY
,      BILLTO_STATE
,      BILLTO_PROVINCE
,      BILLTO_LAST_NAME
,      BILLTO_FIRST_NAME
,      BILLTO_JOB_TITLE
,      BILLTO_AREA_CODE
,      BILLTO_PHONE_NUMBER
,      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
,      SOLDTO_CUST_ADDR_ID
,      SOLDTO_CUST_ID
,      SOLDTO_CUST_NAME
,      SOLDTO_ADDR1
,      SOLDTO_ADDR2
,      SOLDTO_ADDR3
,      SOLDTO_ADDR4
,      SOLDTO_CITY
,      SOLDTO_POSTAL_CODE
,      SOLDTO_COUNTY
,      SOLDTO_COUNTRY
,      SOLDTO_STATE
,      SOLDTO_PROVINCE
,      SOLDTO_LAST_NAME
,      SOLDTO_FIRST_NAME
,      SOLDTO_JOB_TITLE
,      SOLDTO_AREA_CODE
,      SOLDTO_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
FROM GML.OP_ORDR_HDR_INTERFACE;

Dependencies

[top of page]

GML.OP_ORDR_HDR_INTERFACE does not reference any database object

GML.OP_ORDR_HDR_INTERFACE is referenced by following:

GML: OP_ORDR_HDR_INTERFACE#