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_HDR

Object Details

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

Order Profile Headers and Blanket Sales Order Headers are maintained in this table. The PRESALES_ORD_TYPE designates whether this record is an order profile or blanket sales order. A value of '2' for PRESALES_ORD_TYP indicates that the record is an order profile and a value of 0 indicates that the record is an order profile.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PRSL_HDRI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE PRESALES_ORD_NO PRESALES_ORD_TYPE
OP_PRSL_HDR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRESALES_ORD_ID
OP_PRSL_HDRI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_NO

Columns

Name	Datatype	Length	Mandatory	Comments
HOLD_EXPIRATION	DATE			Hold expiration
PRESALES_ORD_ID	NUMBER	(10)	Yes	Surrogate key; alternate key is presales_ord_type + orgn_code + presales_ord_no
SOLDTOCUST_ID	NUMBER	(15)		Third party customer to sales transaction. May be a buying cooperative or distributor. Fk to op_cust_mst. Defaults from op_cust_asc, if sold-to association is established.
ORGN_CODE	VARCHAR2	(4)	Yes	Fk to sy_orgn_mst. Makes presales orders organization specific.
PRESALES_ORD_NO	VARCHAR2	(32)	Yes	Name of presales order.
PRESALES_ORD_DESC	VARCHAR2	(70)	Yes	Description of presales order - can be used for lookups.
SHIPCUST_ID	NUMBER	(15)		Default shipping (destination) customer; fk to op_cust_mst.
ULTIMATE_SHIPCUST_ID	NUMBER	(15)		Ultimate shipping (destination) customer when shipcust is a freight forwarder or distribution center; fk to op_cust_mst.
PRESALES_ORD_TYPE	NUMBER	(5)	Yes	Number which indicates type of presales order, i.e., profile or blanket order. A value of 0 means that this record is an Order Profile; a value of 2 indicates that this is a Blanket Sales Order.
CONSIGNEE_ID	NUMBER	(10)		Ultimate customer when consignment inventory is shipped to a gemms-managed warehouse.
CUSTTRADE_CLASS	VARCHAR2	(8)		Customer industry class for this order; use_class may vary by line item. Fk to op_ctrd_cls.
EFFECTIVE_DATE	DATE		Yes	Start date that this presales order may be used.
EXPIRATION_DATE	DATE		Yes	Date this presales order may no longer be used.
BILLCUST_ID	NUMBER	(15)		Default third party to be invoiced; fk to op_cust_mst.
REMIT_TO_LOCKBOX	VARCHAR2	(8)		Lockbox code which indicates where billcust sends payment; fk to op_lkbx_mst.
SHIPADDR_ID	NUMBER	(10)		Shipping destination; defaults from op_cust_mst.addr_id for shipcust_id of this record; fk to sy_addr_mst.
CONTACT_ID	NUMBER	(10)		Surrogate id which references customer contact. Fk to op_cust_con.
PROFORMA_INVOICE_REQD	NUMBER	(5)		Flag; 1 means a proforma or commercial invoice is required. Defaults to 0. For future use.
SHIP_MTHD	VARCHAR2	(4)		Shipping method; fk to op_ship_mth.
SHIPPER_CODE	VARCHAR2	(4)		Shipper code; fk to op_ship_mst.
SLSREP_CODE	VARCHAR2	(8)		Sales rep; defaults from op_cust_mst for shipcust. Fk to op_slsr_mst.
COMMISSION_CODE	VARCHAR2	(8)		Commission code defaults from op_cust_mst for shipcust. Fk to op_comm_cds.
BILLING_CURRENCY	VARCHAR2	(4)		Currency customer is billed in; defaults from op_cust_mst for billcust_id; fk to gl_curr_mst. This is the currency in which the entire order is valued.
TO_WHSE	VARCHAR2	(4)		Destination warehouse for intra-enterprise shipments and consignments; defaults from op_cust_mst for shipcust of cust_type = 1 or 2 (consignment or transfer) fk to ic_whse_mst.
FROM_WHSE	VARCHAR2	(4)		Shipping warehouse; defaults from op_cust_mst for shipcust; fk to ic_whse_mst.
EMBARKATION_PORT	VARCHAR2	(8)		Port of loading/port of discharge; fk to op_port_mst
DEBARKATION_PORT	VARCHAR2	(8)		Port shipment is unloaded/port of entry; fk to op_port_mst
FOB_CODE	VARCHAR2	(4)		Defaults from op_cust_mst for shipcust; fk to op_fobc_mst.
TERMS_CODE	VARCHAR2	(4)		Payment terms, i.e., 2-10 net 30 days, net 60 days defaults from op_cust_mst for billcust; fk to op_term_mst.
FRTBILL_MTHD	VARCHAR2	(4)		Freight bill method, i.e., prepaid, collect defaults from op_cust_mst for billcust; fk to op_frgt_mth
ORDER_TYPE	NUMBER	(5)		Order type that specifies the type of sales order to create. FK to op_ordr_typ.
CUSTPO_NO	VARCHAR2	(40)		Customer PO number; optional
CONTRACT_NO	VARCHAR2	(32)		Reference to a contract for a blanket order.
ORDER_EXCHANGE_RATE	NUMBER			Exchange to be used for all lines and the entire contract. Sets defaults for the lines. For use in blanket orders and quotes.
MUL_DIV_SIGN	NUMBER	(5)		Multiply/divide sign for exchange rate. Value of 0 means multiply exchange rate by value in billing currency to arrive at value in base currency; value of 1 means divide value by exchange rate. For use with quotes and blanket orders.
ORDER_COMMENT	VARCHAR2	(70)		Freeform text/comments.
COA_REQUIRED	NUMBER	(5)		Flag; value of 1 means certificate of analysis is required; defaults to 0; set defaults for lines. For future use.
BACKORDER_IND	NUMBER	(5)		Flag; value of 1 means backorders are allowed; defaults from op_cust_mst; sets defaults for lines. For future use.
MINSHIP_PCT	NUMBER			Percentage (value of 1 means 100%) below order line item (release) qty that must be shipped to consider the line item completed. Sets defaults for lines.
MAXSHIP_PCT	NUMBER			Maximum percentage (value of 1 means 100%) above order line item (release) qty that may be accepted by the customer; set defaults for lines.
MIN_CLOSE_PERCENT	NUMBER			Percentage (value of 1 means 100%) below maximum release quantity that the system will consider the blanket order to be fulfilled and close it. Defaults from op_prsl_hdr.Can be modified by the user.
ORDER_MAX_VALUE	NUMBER			Contains the maximum monetary value that can be released against the entire BSO. Maintained by the user.
ORDER_OPEN_VALUE	NUMBER			Contains the value of all open releases (sales orders that have not been shipped). System updated only.
ORDER_SHIPPED_VALUE	NUMBER			Contains the value of all shipments made against sales orders released from this BSO. System updated only.
ORDER_AVAIL_VALUE	NUMBER			Contains the total value remaining to be released (computed by max_value - open_value - shipped_value). System computed only. BSO cannot be released if available is <=0.
ORDER_SCHEDULE_VALUE	NUMBER			Contains the total value of all schedules which have been setup for the BSO. System updated. Cannot exceed BSO available value.
NUM_RELEASES	NUMBER	(5)		Number of releases against this blanket order. Incremented by 1 each time a sales order is created from this blanket order
ENABLE_AUTO_RELEASE	NUMBER	(5)		Auto release flag; 0 = Auto release is enabled, 1 = Auto release is disabled.
HOLDREAS_CODE	VARCHAR2	(4)		Default hold reason code for order; set defaults for lines; fk to op_hold_cds.
STATUS_IND	NUMBER	(5)	Yes	Indicates status of presales order. Status values are: 0 = open presales order (default), 1 = closed presales order, -1 = cancelled presales order
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
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	Indicates if record has been logically deleted. Value of 0 means active record; value of 1 means "deleted".
IN_USE	NUMBER	(10)		Not currently used
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_ORD_ID
,      SOLDTOCUST_ID
,      ORGN_CODE
,      PRESALES_ORD_NO
,      PRESALES_ORD_DESC
,      SHIPCUST_ID
,      ULTIMATE_SHIPCUST_ID
,      PRESALES_ORD_TYPE
,      CONSIGNEE_ID
,      CUSTTRADE_CLASS
,      EFFECTIVE_DATE
,      EXPIRATION_DATE
,      BILLCUST_ID
,      REMIT_TO_LOCKBOX
,      SHIPADDR_ID
,      CONTACT_ID
,      PROFORMA_INVOICE_REQD
,      SHIP_MTHD
,      SHIPPER_CODE
,      SLSREP_CODE
,      COMMISSION_CODE
,      BILLING_CURRENCY
,      TO_WHSE
,      FROM_WHSE
,      EMBARKATION_PORT
,      DEBARKATION_PORT
,      FOB_CODE
,      TERMS_CODE
,      FRTBILL_MTHD
,      ORDER_TYPE
,      CUSTPO_NO
,      CONTRACT_NO
,      ORDER_EXCHANGE_RATE
,      MUL_DIV_SIGN
,      ORDER_COMMENT
,      COA_REQUIRED
,      BACKORDER_IND
,      MINSHIP_PCT
,      MAXSHIP_PCT
,      MIN_CLOSE_PERCENT
,      ORDER_MAX_VALUE
,      ORDER_OPEN_VALUE
,      ORDER_SHIPPED_VALUE
,      ORDER_AVAIL_VALUE
,      ORDER_SCHEDULE_VALUE
,      NUM_RELEASES
,      ENABLE_AUTO_RELEASE
,      HOLDREAS_CODE
,      STATUS_IND
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TEXT_CODE
,      DELETE_MARK
,      IN_USE
,      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_HDR;

Dependencies

[top of page]

GML.OP_PRSL_HDR does not reference any database object

GML.OP_PRSL_HDR is referenced by following:

APPS: OP_PRSL_HDR