Search Results line_comments




Overview
Explore in AI Chat

Overview

OKE_DD250_LINES_V is a public view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as OKE.OKE_DD250_LINES_V. It presents line-level information associated with a DD250 form (Department of Defense Form 250, Material Inspection and Receiving Report) generated through the Oracle Contracts and ETRM (Enterprise Trade and Receiving Management) reporting framework. The view is documented as a public view that may be useful for custom reporting or other data requirements, meaning it is not restricted to internal application processing and can be safely referenced by custom SQL, BI Publisher reports, or outbound integration extracts.

The content of the view maps to Blocks 15 through 20 of the DD250 form. These blocks cover the item number (CLIN number), the contractor part number and national stock number, item and line descriptions, quantity, unit of measure, unit price, and monetary amount. In the context of a user search for line_comments, the view exposes the LINE_COMMENTS column, which supplies the contract line additional comments associated with Block 16 (Item Description / Part Number / National Stock Number area). This makes the view a convenient source for retrieving free-text comments attached to a contract line without querying the underlying contract line tables directly.

Underlying Base Objects

Per the documented metadata for ETRM 12.2.2, OKE_DD250_LINES_V is defined over the following referenced base objects:

  • OKE_DD250_HEADERS_V (VIEW) — the header-level companion view providing the DD250 form header context, including form header identifier, form header number (matching the shipment number), and form date.
  • OKE_K_FORM_LINES (SYNONYM) — the form line source that supplies the line-level contract and shipment attributes that populate Blocks 15 through 20.

Because OKE_DD250_LINES_V is defined over a header view and a form-lines synonym, it functions as a denormalized reporting layer that joins form header context to individual contract/shipment lines. The dependency on OKE_DD250_HEADERS_V allows the line rows to carry form header identifiers, form header numbers, and form dates consistently with the corresponding header records, while OKE_K_FORM_LINES provides the granular line details such as part number, national stock number, quantity, UOM, unit price, and amount.

Key Columns

Common Use Cases and Queries

Typical uses include extracting DD250 line data for printed forms, reconciling shipment lines against contract CLINs, and reporting line-level comments. A representative query retrieving line comments for a shipment is:

  • SELECT form_header_number, line_number, part_number, line_comments FROM apps.oke_dd250_lines_v WHERE shipment_number = :shipment_number;
  • SELECT contract_number, line_number, item_description, line_comments, shipment_quantity, unit_price, amount FROM apps.oke_dd250_lines_v WHERE form_header_id = :form_header_id ORDER BY form_line_number;
  • SELECT h.form_header_number, l.line_number, l.line_comments FROM apps.oke_dd250_headers_v h, apps.oke_dd250_lines_v l WHERE h.form_header_id = l.form_header_id AND l.line_comments IS NOT NULL;

These queries support custom reporting, integration extracts, and reconciliation routines that require the DD250 line context together with the line comments text.