Results for “shipment_date”

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

Overview

OKE_DD250_HEADERS_V is a reporting view owned by the APPS schema within the OKE – Project Contracts module of Oracle E-Business Suite. It exposes header-level information captured through the DD250 form (Department of Defense Form 250, Material Inspection and Receiving Report), which is used in government contracting to document shipment, inspection, acceptance, and billing details. The view presents a denormalized, query-friendly projection of stored DD250 header data, allowing reporting tools, concurrent programs, and integrations to retrieve contract, shipment, and party-address information without navigating the underlying transactional structures. In EBS 12.1.1 and 12.2.2 the object is marked VALID, confirming that it compiles successfully against its referenced base object and is available for routine querying.

Underlying Base Objects

According to the documented 12.2.2 view metadata, the sole referenced base object is OKE_K_FORM_HEADERS, accessed through a synonym. The view is defined as a SELECT over that table, applying column aliases and string manipulation. The most significant transformation is the parsing of large text columns: TEXT08, TEXT10, and TEXT12 are segmented into fixed 80-character slices using SUBSTR and RTRIM to yield discrete address lines for the prime contractor, the administering office, and the shipped-from party respectively. This indicates that the base table stores these addresses as concatenated strings, and the view abstracts that encoding into individually named columns.

Key Columns

• FORM_HEADER_ID / FORM_HEADER_NUMBER / FORM_DATE – Primary identifier, human-readable number, and date of the DD250 form header.
• STATUS_CODE – Current processing status of the stored form header.
• K_HEADER_ID / K_LINE_ID / DELIVERABLE_ID – Foreign keys linking the DD250 record to the originating contract header, contract line, and deliverable.
• CONTRACT_NUMBER, ORDER_NUMBER, SHIPMENT_NUMBER – Aliases of TEXT01, TEXT02, TEXT03, carrying the contract and shipment references printed on the form.
• DISCOUNT_TERMS – Alias of TEXT06, holding the payment discount terms associated with the DD250. This column is the direct match for the search term "discount_terms."
• SHIPMENT_DATE, INVOICE_DATE – Aliases of DATE01 and DATE02.
• BILL_OF_LADING_NUMBER, TRANSPORT_CONTROL_NUM, SHIP_METHOD – Logistics identifiers drawn from TEXT04, TEXT05, and TEXT26.
• ACCEPTANCE_POINT, ACCEPTANCE_METHOD, INSPECTION_POINT – Inspection and acceptance attributes from TEXT07, TEXT21, and TEXT22.
• Address groups – PRIME_CONTRACTOR_*, ADMIN_BY_*, and SHIPPED_FROM_* columns (name, address lines, city, state, zip, country) derived from TEXT08, TEXT10, and TEXT12, with corresponding code columns from TEXT09 and TEXT11.

Common Use Cases and Queries

Typical usage centers on extracting DD250 header detail for contract administration reporting, invoice verification, and interface extracts. The DISCOUNT_TERMS column is frequently queried to reconcile payment terms against AP invoice setups or to feed downstream settlement logic.

• Retrieve header detail for a specific form: SELECT form_header_number, contract_number, discount_terms, shipment_date FROM oke_dd250_headers_v WHERE form_header_id = :id;
• List all forms for a contract line: SELECT form_header_number, order_number, invoice_date FROM oke_dd250_headers_v WHERE k_line_id = :line_id ORDER BY form_date;
• Search by discount terms: SELECT form_header_number, contract_number, discount_terms FROM oke_dd250_headers_v WHERE discount_terms LIKE '%2%10%';
• Extract prime contractor mailing information: SELECT form_header_number, prime_contractor_name, prime_contractor_city, prime_contractor_state, prime_contractor_zip FROM oke_dd250_headers_v;

Because the view performs only projection and substring logic with no aggregation or joins, query performance depends primarily on filtering by indexed base-table keys such as FORM_HEADER_ID, K_HEADER_ID, or K_LINE_ID.