Results for “op_prsl_dtl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_PRSL_DTL is a GML (Process Manufacturing Logistics) base table that stores order profile lines and blanket sales order lines within Oracle E-Business Suite 12.1.1 and 12.2.2. In OPM/Process Manufacturing terminology, a "presales order" is the profile or blanket agreement header, and OP_PRSL_DTL carries its individual line items. Each row represents one prospect or blanket order line that defines the requested item, quantities, pricing constraints, ship-to information, and release rules that downstream sales order and release scheduling processes consume.

Under a heuristic Data Vault classification, this table leans toward a satellite, since it describes attributes and descriptive context attached to a parent business entity (the profile/blanket header) rather than acting as an independent hub or a pure associative link. This is a modeling suggestion only; the table is physically a conventional EBS detail table with a composite unique key.

Key Information Stored

The documented physical schema contains 112 columns. Among the most operationally significant:

• PRESALES_ORDLINE_ID — surrogate primary key (index OP_PRSL_DTL_PK).
• PRESALES_ORD_ID and PRESALES_ORDLINE_NO — the business-key candidate (index OP_PRSL_DTLI1) and the foreign key to the OP_PRSL_HDR header.
• ITEM_ID / GENERIC_ID — the ordered item and its generic item grouping.
• SALESPKG_ID — the sales package associated with the line.
• ORDER_QTY1, ORDER_QTY2, ORDER_UM1, ORDER_UM2 — dual-unit order quantities and units of measure.
• BILLCUST_ID, SHIPCUST_ID, CONSIGNEE_ID, ULTIMATE_SHIPCUST_ID, SOLDTOCUST_ID — the customer role assignments for the line.
• SHIPADDR_ID, FROM_WHSE, TO_WHSE — ship-to address and warehouse routing.
• BILLING_CURRENCY, EXCHANGE_RATE, TERMS_CODE — financial and payment context.
• SLSREP_CODE, COMMISSION_CODE — sales representative and commission attribution.
• STATUS_IND, DELETE_MARK, HOLDREAS_CODE, HOLD_EXPIRATION — line lifecycle and hold state.
• LINE_MAX_VALUE, LINE_MIN_VALUE, LINE_RELEASE_VALUE, LINE_OPEN_VALUE — blanket/profile release constraint and accumulation values.
• TEXT_CODE — reference to stored text/notes.

The ATTRIBUTE1 through ATTRIBUTE30 and ATTRIBUTE_CATEGORY columns provide the standard EBS DFF extension mechanism, while CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY supply audit lineage.

Common Use Cases and Queries

• Listing all lines for a given profile or blanket order:

  SELECT d.presales_ordline_no, d.item_id, d.order_qty1, d.status_ind
  FROM   gml.op_prsl_dtl d
  WHERE  d.presales_ord_id = :ord_id
  AND    d.delete_mark = 0
  ORDER BY d.presales_ordline_no;

• Reporting open release capacity by comparing LINE_MAX_VALUE and LINE_RELEASE_VALUE against actual releases scheduled in OP_RELS_SCH.
• Customer/consignee analysis by joining BILLCUST_ID, SHIPCUST_ID, and CONSIGNEE_ID to OP_CUST_MST.
• UoM conversion validation by joining ORDER_UM1 and ORDER_UM2 to SY_UOMS_MST.
• Identifying lines on hold through HOLDREAS_CODE and HOLD_EXPIRATION to drive exception reporting.

Queries should always filter DELETE_MARK = 0, and it is prudent to qualify the GML schema explicitly.

Related Objects

• OP_PRSL_HDR — parent header table (OP_PRSL_DTL.PRESALES_ORD_ID).
• OP_PRSL_CHG — line-level charges (OP_PRSL_CHG.PRESALES_ORDLINE_ID).
• OP_RELS_SCH — blanket release schedule lines (OP_RELS_SCH.PRESALES_ORDLINE_ID).
• OP_ORDR_DTL — originating sales order line reference (OP_ORDR_DTL.PRESALES_ORDLINE_ID).
• OP_CUST_MST and OP_CUST_CON — customer and contact definitions.
• IC_ITEM_MST / IC_ITEM_MST_B and OP_GNRC_ITM — item and generic item masters.
• IC_WHSE_MST, OP_SHIP_MST, SY_ADDR_MST — warehouse, shipper, and address masters.
• GL_CURR_MST, OP_TERM_MST, OP_SLSR_MST, OP_COMMISSION — currency, terms, sales representative, and commission masters.