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

Object Details

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

This table contains the lines for Orders and Shipments. This is the main detail table in OPM Order Fulfillment.
When an order is entered (or copied from either a profile, existing sales order or blanket order), order line information is obtained from the source (either user, profile, etc.) and shipping and invoicing information is left blank. New order lines contain the ORDER_QTY (and unit of measure and secondary quantity, if applicable). The SHIP_QTY's default to the ORDER_QTY's. When the order line is placed on a shipment, then the corresponding shipping information is completed, such as BOL_ID, BOLLINE_NO, et, and the SHIP_QTY's are updated for the quantity shipped.
If the SHIP_QTY's are less than the ORDER_QTY's, then a backorder is created. A backorder line is inserted as another open order line, with the same ORDER_ID and LINE_NO, but a different LINE_ID. In addition, the BACKORDER_IND is set to 1. The ORDER_QTY's and SHIP_QTY's equal the quantity which was not shipped (still "open"). Also, the BOL_ID, BOLLINE_NO do not exist until the backorder is placed on another shipment. At any point in time, only ONE open (LINE_STATUS = 0) order line will exist for any combination of ORDER_ID and LINE_NO. Once an order line is placed on a shipment, the LINE_STATUS becomes 10 (picked) and after shipment, it becomes 20 (shipped).
Information on the order header (in table OP_ORDR_HDR) is used initially as a default for the order lines. Once an order is saved, each order line becomes, in effect, its own order, with all information used from the line.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
OP_ORDR_DTL_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_ID LINE_ID
OP_ORDR_DTLI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOL_ID
OP_ORDR_DTLI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPCUST_ID
OP_ORDR_DTLI4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_ID	NUMBER	(10)		The specific item price that was used to arrive at the net_price. fk to op_prce_itm or op_cntr_dtl.
PRICE_SELECTED_IND	NUMBER	(5)		Indicates if user selected price from list of offerred pricelists/contracts. 0 means no user selection done; 1 means user selected pricelist.
ORDER_ID	NUMBER	(10)	Yes	Reference to order which contains this line; fk to op_ordr_hdr.
LINE_ID	NUMBER	(10)	Yes	Surrogate id for table; uniquely identifies each row.
LINE_NO	NUMBER	(5)	Yes	Line number assigned by system for this order line.
INVOICE_ID	NUMBER	(10)		Reference to invoice which contains this line. This functionality is no longer supported.
INVOICELINE_NO	NUMBER	(5)		Line number assigned by the system for the invoice; this functionality is no longer supported.
BOL_ID	NUMBER	(10)		Reference to shipment which contains this line; fk to op_bill_lad.
BOLLINE_NO	NUMBER	(5)		Line number assigned by the system for the shipment on which this order line is contained.
RETURN_ID	NUMBER	(10)		Reference to the return; not currently supported; for future use
ITEM_ID	NUMBER	(10)	Yes	Ordered item; fk to ic_item_mst.
GENERIC_ID	NUMBER	(10)		Generic or customer item number reference. If o then no generic or customer item entered. Fk to op_gnrc_itm.
LINE_DESC	VARCHAR2	(70)	Yes	Description of item ordered; defaults from op_gnrc_itm, op_pkgd_itm or ic_item_mst; user can modify.
SALESPKG_ID	NUMBER	(10)		Packaged item id; fk to op_pkgd_itm.
LINE_COMMENT	VARCHAR2	(70)		Freeform text/comments.
ORDER_QTY1	NUMBER		Yes	Quantity ordered in unit of measure indicated in column order_um1.
ORDER_QTY2	NUMBER			Quantity ordered in unit of measure indicated in column order_um2. This uom is always equivalent to the item_um2 (from ic_item_mst) of an item. User can edit order_qty2 within tolerances established in ic_item_mst for item.
ORDER_UM1	VARCHAR2	(4)	Yes	Order unit of measure. Defaults to item_um1 of an item, but can be modified by user. Fk to sy_uoms_mst.
ORDER_UM2	VARCHAR2	(4)		Second unit of measure. Defaults to item_um2 of an item and can not be changed by user.
SHIPADDR_ID	NUMBER	(10)		Shipping destination. Defaults to addr_id from op_cust_mst for shipcust and and can be modified by user.
SHIPCUST_ID	NUMBER	(15)	Yes	Default shipping (destination) customer from header. Fk to op_cust_mst. Can be overridden by user.
SHIPPER_CODE	VARCHAR2	(4)		Defaults from header but may be overridden; fk to op_ship_mst.
CONSIGNEE_ID	NUMBER	(10)		Ultimate customer when consignment inventory is shipped to a gemms-managed warehouse; defaults from header; fk to op_cust_mst.
SHIP_MTHD	VARCHAR2	(4)		Defaults from header but can be overridden; fk to op_ship_mth.
TO_WHSE	VARCHAR2	(4)		Destination warehouse for intra-enterprise shipments and consignments; defaults from header and required on interplant or consignment orders; fk to ic_whse_mst.
FROM_WHSE	VARCHAR2	(4)		Shipping warehouse; defaults from header; fk to ic_whse_mst.
FOB_CODE	VARCHAR2	(4)		Defaults from header but may be overridden; fk to op_fobc_mst.
NET_WT	NUMBER		Yes	Weight of item in shipwt_um unit of measure not including shipping container. Calculated by system.
DEBARKATION_PORT	VARCHAR2	(8)		Port of arrival for overseas shipments (where goods are unloaded); fk to op_port_mst.
SOLDTOCUST_ID	NUMBER	(15)		Third-party customer to the sales transaction - may be a buying cooperative, distributor, etc. Defaults from header using customer association, if established
TARE_WT	NUMBER		Yes	Weight of packaging materials for item in shipwt_um unit of measure. Defaults from packaged item, if entered. Can be entered/overridden by user.
PALLET_WT	NUMBER		Yes	Pallet weight for item being shipped in shipwt_um. Defaults from packaged item, if entered, otherwise entered/overridden by user.
FRTBILL_WT	NUMBER		Yes	Freight bill weight equals the net_wt + tare_wt + pallet_wt. In shipwt_um and can be modified by user in shipping. Weight for freight billing purposes.
SHIP_STATUS	NUMBER	(5)	Yes	Indicates status of order line re: shipping. Valid values are: 0 - line has not been shipped, 10 - shipment has been picked (shipment created for line), 20 - shipment has been released (shipped).
SHIPWT_UM	VARCHAR2	(4)	Yes	Defaults from system variable for ship weight uom. Can not be changed by user. Unit of measure for shipping weights. Fk to sy_uoms_mst.
BASE_PRICE	NUMBER		Yes	Base price retrieved from the pricing tables (from the column base_price) for the item/customer/whse, etc. on this order line. Price is converted to price_um and billing_currency for this line.
NET_PRICE	NUMBER		Yes	Defaults from system_price, but can be overridden by user. This is the price that the user will be charged for this order line. In price_um and billing_currency.
EXTENDED_PRICE	NUMBER		Yes	Total price for line which equals: order_qty1 multiplied by net_price.
PRICE_UM	VARCHAR2	(4)	Yes	Unit of measure retrieved from pricing tables. This is the uom in which the price was established in the pricelist and which may have necessitated a conversion of the price to the order_um1. Fk to sy_uoms_mst. This uom corresponds to bo
BILLING_CURRENCY	VARCHAR2	(4)	Yes	Currency that customer will be billed and currency that order is denominated. Defaults from header. Fk to gl_curr_mst.
BASE_CURRENCY	VARCHAR2	(4)	Yes	Currency of organization identified with order. Defaults from gl_plcy_mst and can not be modified by user.
EXCHANGE_RATE	NUMBER		Yes	Exchange rate between billing_currency and base_currency. Defaults to 1 if the two currencies are the same, otherwise retrieved from gl_xchg_rte.
TERMS_CODE	VARCHAR2	(4)	Yes	Code to uniquely identify payment terms
BILL_QTY	NUMBER			Invoice qty used in previous versions; column is not supported or used.
REQUESTED_SHIPDATE	DATE		Yes	Requested shipping date, defaults from header.
PROMISED_SHIPDATE	DATE		Yes	Promised ship date, defaults from header.
LIST_PRICE	NUMBER		Yes	Price obtained from pricing tables designated as "list prices". Price is converted to order_um1 and billing_currency on this order line.
SCHED_SHIPDATE	DATE		Yes	Scheduled ship date, defaults from header. This date becomes the transaction date for pending inventory transactions for this order line.
ACTUAL_SHIPDATE	DATE			Actual ship date. Date is required in shipping before a shipment is released.
REQUIRED_DLVDATE	DATE		Yes	Required delivery date, defaults from header. This date can be used to calculate the sched_shipdate.
ACTUAL_DLVDATE	DATE			Actual delivery date to customer. For future use.
BASE_COST	NUMBER			Not used.
QC_GRADE_WANTED	VARCHAR2	(4)		Qc grade requested by user for this item. Used to assign lots to this order line during automatic lot allocation, otherwise, a guide to the user for manual allocation. Only applicable for grade-controlled items.
COMPLETED_IND	NUMBER	(5)	Yes	Indicates "completed" status of order line. Valid values are: 0 - line has not been shipped; 1 = line has been shipped (released), -1=line has been cancelled.
REPRICE_SHIPMENT	NUMBER	(5)		Indicator to reprice the order line based on the shipped qty ( during shipping). A value of 0 means that the line will not be repriced during shipping, a value of 1 means that the line will be repriced during shipping. For future use.
SLSREP_CODE	VARCHAR2	(8)		Defaults from header but may be overridden; fk to op_slsr_mst.
COMMISSION_CODE	VARCHAR2	(8)		Commission code defaulted from header; fk to op_commission. Overrides code in op_ordr_hdr.
NET_COMMISSION	NUMBER			Net commission. Defaults to 0. For future use. Intended to contain commission calculated for this line.
MUL_DIV_SIGN	NUMBER	(5)	Yes	Defaults to 0. Retrieved from gl_xchg_rte table if exchange_rate needs to be retrieved. Indicates if exchange rate is multiplied or divided into billing currency to arrive at base currency. Value of 0 means multiply; value of 1 means di
NET_TAX	NUMBER		Yes	Net tax. Defaults to 0. If automatic tax calculation in use, then field contains tax amount calculated for this line.
BACKORDREAS_CODE	VARCHAR2	(4)		Reason code to indicate why a line was backordered. Fk to sy_reas_cds.
BATCH_ID	NUMBER	(10)		Reference to production batch that will fulfill this order line - for future use.
LOCKBOX_CODE	VARCHAR2	(8)		Remit-to lockbox code. Defaults from header.
HOLDREAS_CODE	VARCHAR2	(4)	Yes	Defaults from header but may be overridden; hold reason code; fk to op_hold_cds.
HOLD_EXPIRATION	DATE		Yes	Hold expiration date. Date when hold indicated by hold reason code will expire. Defaults to system "max date".
ALLOC_IND	NUMBER	(5)	Yes	Indicates if inventory has been allocated for the line. Valid values are: 0 - inventory has either been partially or not allocated to the line; 1 means that the line has been fully allocated.
GL_POSTED_IND	NUMBER	(10)	Yes	Indicates if this shipment line has been posted to the mfg controller subsidiary ledger. 0 means that the shipment line has been posted; 1 means that the shipment line has not been posted.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
CUSTPO_NO	VARCHAR2	(40)		Customer purchase order number; defaults from header.
EXPORTED_DATE	DATE		Yes	Date when the shipment line was exported to oracle financials a/r system for invoicing.
COA_REQUIRED	NUMBER	(5)		Flag to indicate if certificate of analysis is required for this line item. Defaults from header. Value of 0 means that no coa is required; value of 1 means that a coa must be created and sent to customer. For future use.
SYSTEM_PRICE	NUMBER		Yes	The price obtained for this line item from the pricing tables, taking into account, the item, customer, whse, qc grade, price classes and order quantity. Converted to order_um1 and billing_currency on the line.
PRESALES_ORDLINE_ID	NUMBER	(10)		References origin of line, if created from a presales order, i.e., an order profile or blanket order.
PRICEREAS_CODE	VARCHAR2	(4)		Reason code for price change (changing of price to one that is different from the system-generated price). Fk to op_prce_cds.
LINE_STATUS	NUMBER	(5)	Yes	Indicates status of line. Fk to op_ordr_status.
PRICEFF_ID	NUMBER	(10)		Reference to price effectivity used to compute system- generated price. Fk to op_prce_eff.
LINE_TYPE	NUMBER	(5)	Yes	Not used.
ALLOC_QTY	NUMBER		Yes	Quantity that has been allocated for this line in order_um1.
INVENTORY_QTY	NUMBER		Yes	Order_qty1 converted to item_um1 (the first inventory unit of measure).
BACKORDER_FLAG	NUMBER	(5)	Yes	Indicates if this line is a backorder line. Value of 0 means that this is not a backorder line; value of 1 means that this is a backorder line.
IN_USE	NUMBER	(10)		Not currently used
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
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
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
SHIP_QTY1	NUMBER		Yes	Quantity shipped on this order line in order_um1 unit of measure. Defaults in order entry to order_qty1 and is updated in shipping to the actual ship quantity.
EMBARKATION_PORT	VARCHAR2	(8)		Port of leave for overseas shipments (port where goods are loaded). Defaults from header; fk to op_port_mst.
SHIP_QTY2	NUMBER			Quantity shipped in order_um2 unit of measure. Defaults in order entry to order_qty2 and is updated in shipping to the actual ship quantity.
SHIP_VOLUME	NUMBER		Yes	Volume computed by system using order_qty1 and converting it to shipvolume_um unit of measure or by using defaults established for the packaged item. This value can not be updated by the user in shipping or oe.
ULTIMATE_SHIPCUST_ID	NUMBER	(15)		Ultimate shipping (destination) customer when shipcust is a freight forwarder or distribution center; defaults from header; fk to op_cust_mst.
CONTACT_ID	NUMBER	(10)		Surrogate from customer contact table. Contact for order line, defaults from header and can be changed for a line.
MINSHIP_PCT	NUMBER		Yes	Minimum percentage below the order qty that is required to ship to the customer and close the order line. This number defaults from either the order profile, blanket order or customer-item table and can not be modified by the user. Store
SHIPVOLUME_UM	VARCHAR2	(4)	Yes	Defaults from system variable for shipvolume_um. Unit of measure for shipping volume; can not be changed by user. Fk to sy_uoms_mst.
FRTBILL_MTHD	VARCHAR2	(4)		Defaults from header but may be overridden; fk to op_frgt_mth.
MAXSHIP_PCT	NUMBER		Yes	Maximum percentage over the order qty that can be shipped to the customer. This number defaults from either the order profile, blanket order or customer-item tables and can not be changed by the user. Stored as decimal.
NET_FREIGHT	NUMBER			Net freight amount; not currently used. Intended to contain the amount of freight billed/allocated for this line.
FRT_COST	NUMBER			For future use
CHANGEREAS_CODE	VARCHAR2	(4)		Reason code for line changes; fk to sy_reas_cds
REFERENCE_LINE_ID	NUMBER	(10)		Return LINE ID references the original LINE ID
HOLD_CHANGE_IND	NUMBER	(5)		Indicate that Hold Reason Code has been changed by the user
UPGRADE_FLAG	VARCHAR2	(2)		Not currently used
UPGRADE_DATE	DATE			Not currently used
OPM_SHIPCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes
OPM_SOLDTOCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes
OPM_ULTIMATE_SHIPCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes
RETNREAS_CODE	VARCHAR2	(4)		Explanation of why shipped items are being sent back
RMA	VARCHAR2	(30)		Return Material Authorization

Query Text

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


SELECT PRICE_ID
,      PRICE_SELECTED_IND
,      ORDER_ID
,      LINE_ID
,      LINE_NO
,      INVOICE_ID
,      INVOICELINE_NO
,      BOL_ID
,      BOLLINE_NO
,      RETURN_ID
,      ITEM_ID
,      GENERIC_ID
,      LINE_DESC
,      SALESPKG_ID
,      LINE_COMMENT
,      ORDER_QTY1
,      ORDER_QTY2
,      ORDER_UM1
,      ORDER_UM2
,      SHIPADDR_ID
,      SHIPCUST_ID
,      SHIPPER_CODE
,      CONSIGNEE_ID
,      SHIP_MTHD
,      TO_WHSE
,      FROM_WHSE
,      FOB_CODE
,      NET_WT
,      DEBARKATION_PORT
,      SOLDTOCUST_ID
,      TARE_WT
,      PALLET_WT
,      FRTBILL_WT
,      SHIP_STATUS
,      SHIPWT_UM
,      BASE_PRICE
,      NET_PRICE
,      EXTENDED_PRICE
,      PRICE_UM
,      BILLING_CURRENCY
,      BASE_CURRENCY
,      EXCHANGE_RATE
,      TERMS_CODE
,      BILL_QTY
,      REQUESTED_SHIPDATE
,      PROMISED_SHIPDATE
,      LIST_PRICE
,      SCHED_SHIPDATE
,      ACTUAL_SHIPDATE
,      REQUIRED_DLVDATE
,      ACTUAL_DLVDATE
,      BASE_COST
,      QC_GRADE_WANTED
,      COMPLETED_IND
,      REPRICE_SHIPMENT
,      SLSREP_CODE
,      COMMISSION_CODE
,      NET_COMMISSION
,      MUL_DIV_SIGN
,      NET_TAX
,      BACKORDREAS_CODE
,      BATCH_ID
,      LOCKBOX_CODE
,      HOLDREAS_CODE
,      HOLD_EXPIRATION
,      ALLOC_IND
,      GL_POSTED_IND
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      CUSTPO_NO
,      EXPORTED_DATE
,      COA_REQUIRED
,      SYSTEM_PRICE
,      PRESALES_ORDLINE_ID
,      PRICEREAS_CODE
,      LINE_STATUS
,      PRICEFF_ID
,      LINE_TYPE
,      ALLOC_QTY
,      INVENTORY_QTY
,      BACKORDER_FLAG
,      IN_USE
,      LAST_UPDATE_LOGIN
,      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
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      SHIP_QTY1
,      EMBARKATION_PORT
,      SHIP_QTY2
,      SHIP_VOLUME
,      ULTIMATE_SHIPCUST_ID
,      CONTACT_ID
,      MINSHIP_PCT
,      SHIPVOLUME_UM
,      FRTBILL_MTHD
,      MAXSHIP_PCT
,      NET_FREIGHT
,      FRT_COST
,      CHANGEREAS_CODE
,      REFERENCE_LINE_ID
,      HOLD_CHANGE_IND
,      UPGRADE_FLAG
,      UPGRADE_DATE
,      OPM_SHIPCUST_ID
,      OPM_SOLDTOCUST_ID
,      OPM_ULTIMATE_SHIPCUST_ID
,      RETNREAS_CODE
,      RMA
FROM GML.OP_ORDR_DTL;

Dependencies

[top of page]

GML.OP_ORDR_DTL does not reference any database object

GML.OP_ORDR_DTL is referenced by following:

APPS: OP_ORDR_DTL