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_PRSL_DTL

Object Details

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

Order profile lines and blanket sales order lines are contained in this table. Most of the columns are entered by the user; only the blanket sales order statistics columns are updated by the system when a blanket sales order is released or shipped (LINE_OPEN_%, LINE_SCHED_%, LINE_SHIP_%, LINE_AVAIL_% columns).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PRSL_DTLI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRESALES_ORDLINE_NO PRESALES_ORD_ID
OP_PRSL_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRESALES_ORDLINE_ID
OP_PRSL_DTLI2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRESALES_ORD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HOLD_EXPIRATION	DATE			Date when the hold expires
PRESALES_ORDLINE_ID	NUMBER	(10)	Yes	Surrogate key; alternate primary key is presales_ord_id + presales_ord_line_no
PRESALES_ORDLINE_NO	NUMBER	(5)	Yes	Positional line number assigned by the system.
SALESPKG_ID	NUMBER	(10)		Surrogate id to uniquely identify packaged item in op. May be zero, but will be greater than zero if user enters packaged item no in place of item no.
ITEM_ID	NUMBER	(10)	Yes	Item on order; fk to ic_item_mst.
GENERIC_ID	NUMBER	(10)		Generic or customer item number; if greater than zero then generic or customer item number was entered in place of item no from ic_item_mst. If equal to zero then no generic/customer item number entered. Fk to op_gnrc_itm.
DEBARKATION_PORT	VARCHAR2	(8)		Port shipment is unloaded/port of entry; fk to op_port_mst.
EMBARKATION_PORT	VARCHAR2	(8)		Port of loading/port of discharge; fk to op_port_mst
REMIT_TO_LOCKBOX	VARCHAR2	(8)		Lockbox where billcust sends payment; defaults from header op_prsl_hdr; fk to op_lkbx_mst.
PRESALES_ORD_ID	NUMBER	(10)	Yes	Surrogate id (fk) from op_prsl_hdr to identify presales order to which this line belongs.
BILLCUST_ID	NUMBER	(15)		Default third party to be invoiced; defaults from op_prsl_hdr; fk to op_cust_mst where bill_ind = 1.
SHIPCUST_ID	NUMBER	(15)		Default shipped (destination) customer from op_prsl_hdr; fk to op_cust_mst.
CONSIGNEE_ID	NUMBER	(10)		Ultimate customer when consignment inventory is shipped to a gemms-managed warehouse; defaults from op_prsl_hdr; fk to op_cust_mst where cust_type = 1.
ULTIMATE_SHIPCUST_ID	NUMBER	(15)		Ultimate shipping (destination) customer when shipcust is a freight forwarder or distribution center; defaults from op_prsl_hdr; fk to op_cust_mst.
SOLDTOCUST_ID	NUMBER	(15)		Third party customer to the sales transaction - may be a buying cooperative or distributor. Defaults from op_prsl_hdr; fk to op_cust_mst.
CUSTTRADE_CLASS	VARCHAR2	(8)		Customer industry class for this order; defaults from op_prsl_hdr; fk to op_ctrd_cls.
SHIPADDR_ID	NUMBER	(10)		Shipping destination; defaults from op_prsl_hdr; fk to sy_addr_mst.
CONTACT_ID	NUMBER	(10)		Reference to customer contact for line; defaults from op_prsl_hdr; fk to op_cust_con.
PROFORMA_INVOICE_REQD	NUMBER	(5)		Flag; 1 means a proforma or commercial invoice is required; defaults to 0; defaults from op_prsl_hdr. For future use.
SHIP_MTHD	VARCHAR2	(4)		Fk to op_ship_mth; defaults from op_prsl_hdr.
SHIPPER_CODE	VARCHAR2	(4)		Fk to op_ship_mst; defaults from op_prsl_hdr.
SLSREP_CODE	VARCHAR2	(8)		Salesrep code for the line; fk to op_slsr_mst, defaults from op_prsl_hdr
COMMISSION_CODE	VARCHAR2	(8)		Commission code for the line defaults from op_prsl_hdr; fk to op_comm_cds
BILLING_CURRENCY	VARCHAR2	(4)		Currency customer is billed in; defaults from op_prsl_hdr; fk to gl_curr_mst.
TO_WHSE	VARCHAR2	(4)		Destination warehouse for intra-enterprise shipments and consignments; defaults from op_prsl_hdr; fk to ic_whse_mst.
FROM_WHSE	VARCHAR2	(4)		Shipping warehouse; defaults from op_prsl_hdr; fk to ic_whse_mst
FOB_CODE	VARCHAR2	(4)		Defaults from op_prsl_hdr; fk to op_fobc_mst
TERMS_CODE	VARCHAR2	(4)		Defaults from op_prsl_hdr; fk to op_term_mst
FRTBILL_MTHD	VARCHAR2	(4)		Defaults from op_prsl_hdr; fk to op_frgt_mth
COA_REQUIRED	NUMBER	(5)		Value of 1 means certificate of analysis required; defaults from op_prsl_hdr. For future use.
BACKORDER_IND	NUMBER	(5)		Value of 1 means backorders are allowed; defaults from op_prsl_hdr. For future use.
MINSHIP_PCT	NUMBER			Percentage (value of 1 means 100%) below order line item (release) qty that must be shipped to consider line item completed; defaults from op_prsl_hdr for blanket orders; else defaults from customer-item table. Can only be modified in bla
MAXSHIP_PCT	NUMBER			Maximum percentage (value of 1 means 100%) above order line item (release) qty that may be accepted by customer; defaults from op_prsl_hdr. Can only be modified in blanket orders.
HOLDREAS_CODE	VARCHAR2	(4)		Defaults from op_prsl_hdr; fk to op_hold_cds.
LINE_DESC	VARCHAR2	(70)	Yes	Freeform line description; defaults to customer/generic item description if "in use", else defaults to ic_item_mst. Item_desc1. User can override either description.
LINE_COMMENT	VARCHAR2	(70)		Freeform line comment.
ORDER_QTY1	NUMBER		Yes	Standard quantity of this item that customer buys or is being quoted; standard release quantity for blanket order. Quantity is in uom specified in the column order_um1.
ORDER_QTY2	NUMBER			Order qty1 field converted to the second inventory uom of an item (ic_item_mst.item_um2); fk to sy_uoms_mst.
ORDER_UM1	VARCHAR2	(4)	Yes	Unit of measure for order qty1; defaults to ic_item_mst. Item_um and user can change; fk to sy_uoms_mst.
ORDER_UM2	VARCHAR2	(4)		Defaults to ic_item_mst.item_um2 and can not be changed by user; fk to sy_uoms_mst.
INVENTORY_QTY	NUMBER		Yes	Order quantity 1 in items first inventory unit of measure.
QC_GRADE_WANTED	VARCHAR2	(4)		Qc grade requested by customer; defaults from op_alot_prm if allocation class assigned to item and customer has allocation parameters established; fk to qc_grad_mst. Used for selection of relevant pricelist and lots.
SPECMATCH_REQD	NUMBER	(5)		Defaults to 0 to indicate that no match required. Value of 1 means that item (lot) qc results must conform to qc specs of ship customer for allocation and shipment. For future use with qc spec matching.
STATUS_IND	NUMBER	(5)	Yes	Indicates status of presales order line: 0 = line is "open", 1 = line is "closed", -1 = line is "cancelled".
TRANS_CNT	NUMBER	(10)		Not currently used
CUSTPO_NO	VARCHAR2	(40)		Customer PO number, optional; defaults from op_prsl_hdr.
CUST_CONTRACT_NO	VARCHAR2	(40)		Customer contract no, defaults from op_prsl_hdr
EXCHANGE_RATE	NUMBER		Yes	Defaults from op_prsl_hdr and may be overridden. For use in blanket orders and quotes only.
MUL_DIV_SIGN	NUMBER	(5)	Yes	Defaults from op_prsl_hdr. Column accompanies exchange rate and for use in blanket orders and quotes only.
MIN_CLOSE_PERCENT	NUMBER			Percentage (value of 1 means 100%) below maximum release and above minimum release quantity that the system will consider the blanket order to be fulfilled and close it. Defaults from op_prsl_hdr. Cannot be modified by the user.
LINE_MAX_VALUE	NUMBER			Maximum monetary value that can be released for all lines, user entered, optional
LINE_MAX_QTY	NUMBER			Maximum quantity (in order_um1) that can be released for all lines, user entered, optional
LINE_MIN_VALUE	NUMBER			Minimum value that should be released against the line during the life of the BSO. Optional - used for reporting purposes only.
LINE_MIN_QTY	NUMBER			Minimum quantity (in order_um1) that should be released against the line during the life of the BSO.
LINE_RELEASE_VALUE	NUMBER			Expected or default value for a single release against the line.
LINE_RELEASE_QTY	NUMBER			Expected or default quantity (in order_um1) for a single release against the line. Mandatory field.
LINE_OPEN_VALUE	NUMBER			Total value of all open releases against the line (value of order lines which are not shipped). System updated.
LINE_OPEN_QTY	NUMBER			Total quantity (in order_um1) of all open releases against the line (order_qty1 of order lines which are not shipped). System updated.
LINE_SHIP_VALUE	NUMBER			Total value of release shipments made against blanket sales order lines. System updated.
LINE_SHIP_QTY	NUMBER			Total quantity (in order_um1) of release shipments made against blanket sales order lines. System updated.
LINE_AVAIL_VALUE	NUMBER			Total available value to be released for the line. Computed by system as line_max_value minus line_open_value minus line_ship_value
LINE_AVAIL_QTY	NUMBER			Total available quantity (in order_um1) to be released for the line. Computed by system as line_max_qty minus line_open_qty1 minus line_ship_qty1
LINE_SCHED_VALUE	NUMBER			Contains the total line value of any scheduled releases which have been established for the BSO line. System updated, cannot exceed line available value.
LINE_SCHED_QTY	NUMBER			Total quantity (in order_um1) of schedule quantity on all schedule lines
RELEASE_MAX_VALUE	NUMBER			Maximum value that can be released in a single release
RELEASE_MAX_QTY	NUMBER			Maximum quantity (in order_um1) that can be released in a single release
RELEASE_MIN_VALUE	NUMBER			Minimum value that can be released in a single release
RELEASE_MIN_QTY	NUMBER			Minimum quantity (in order_um1) that can be released in a single release.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Flag to indicate logical deletion; 0 means active; 1 means "deleted"
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
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
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_BILLCUST_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

Query Text

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


SELECT HOLD_EXPIRATION
,      PRESALES_ORDLINE_ID
,      PRESALES_ORDLINE_NO
,      SALESPKG_ID
,      ITEM_ID
,      GENERIC_ID
,      DEBARKATION_PORT
,      EMBARKATION_PORT
,      REMIT_TO_LOCKBOX
,      PRESALES_ORD_ID
,      BILLCUST_ID
,      SHIPCUST_ID
,      CONSIGNEE_ID
,      ULTIMATE_SHIPCUST_ID
,      SOLDTOCUST_ID
,      CUSTTRADE_CLASS
,      SHIPADDR_ID
,      CONTACT_ID
,      PROFORMA_INVOICE_REQD
,      SHIP_MTHD
,      SHIPPER_CODE
,      SLSREP_CODE
,      COMMISSION_CODE
,      BILLING_CURRENCY
,      TO_WHSE
,      FROM_WHSE
,      FOB_CODE
,      TERMS_CODE
,      FRTBILL_MTHD
,      COA_REQUIRED
,      BACKORDER_IND
,      MINSHIP_PCT
,      MAXSHIP_PCT
,      HOLDREAS_CODE
,      LINE_DESC
,      LINE_COMMENT
,      ORDER_QTY1
,      ORDER_QTY2
,      ORDER_UM1
,      ORDER_UM2
,      INVENTORY_QTY
,      QC_GRADE_WANTED
,      SPECMATCH_REQD
,      STATUS_IND
,      TRANS_CNT
,      CUSTPO_NO
,      CUST_CONTRACT_NO
,      EXCHANGE_RATE
,      MUL_DIV_SIGN
,      MIN_CLOSE_PERCENT
,      LINE_MAX_VALUE
,      LINE_MAX_QTY
,      LINE_MIN_VALUE
,      LINE_MIN_QTY
,      LINE_RELEASE_VALUE
,      LINE_RELEASE_QTY
,      LINE_OPEN_VALUE
,      LINE_OPEN_QTY
,      LINE_SHIP_VALUE
,      LINE_SHIP_QTY
,      LINE_AVAIL_VALUE
,      LINE_AVAIL_QTY
,      LINE_SCHED_VALUE
,      LINE_SCHED_QTY
,      RELEASE_MAX_VALUE
,      RELEASE_MAX_QTY
,      RELEASE_MIN_VALUE
,      RELEASE_MIN_QTY
,      TEXT_CODE
,      DELETE_MARK
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      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
,      UPGRADE_FLAG
,      UPGRADE_DATE
,      OPM_SHIPCUST_ID
,      OPM_BILLCUST_ID
,      OPM_SOLDTOCUST_ID
,      OPM_ULTIMATE_SHIPCUST_ID
FROM GML.OP_PRSL_DTL;

Dependencies

[top of page]

GML.OP_PRSL_DTL does not reference any database object

GML.OP_PRSL_DTL is referenced by following:

APPS: OP_PRSL_DTL