Search Results chv_item_orders




Overview
Explore in AI Chat

Overview

CHV_ITEM_ORDERS is a transactional table owned by the PO schema within the CHV (Supplier Scheduling) product module of Oracle E-Business Suite. It stores item-level order and schedule demand lines used by Supplier Scheduling to communicate replenishment requirements to suppliers. The table is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and contains 37 columns describing quantities, units of measure, due dates, and the document references that link each scheduled requirement back to its originating purchasing document.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure identifies CHV_ITEM_ORDERS as a standalone object. This suggests it behaves primarily as a hub-and-satellite style record rather than a pure associative link: the SCHEDULE_ORDER_ID unique key anchors each row, while attributable descriptive data (quantities, dates, audit columns, and descriptive flexfield attributes) sits alongside it. Its single documented foreign key to CHV_PURGE_SCHEDULE_LIST indicates a purge-oriented relationship rather than a broad integration footprint.

Key Information Stored

The table's business identity is defined by the unique index CHV_ITEM_ORDERS_U1 on SCHEDULE_ORDER_ID, which serves as the business-key candidate for a single item order line. The surrogate and linking identifiers are:

Common Use Cases and Queries

Typical usages include supplier release reporting, demand-versus-supply reconciliation, and purge/archive processing. A representative join to the purge list table follows:

SELECT i.schedule_order_id, i.due_date, i.order_quantity, i.purchasing_unit_of_measure, p.* FROM po.chv_item_orders i, po.chv_purge_schedule_list p WHERE i.schedule_item_id = p.schedule_item_id;

Reporting queries frequently aggregate ORDER_QUANTITY_PRIMARY by DUE_DATE to produce time-bucketed schedules, or join on DOCUMENT_HEADER_ID / DOCUMENT_LINE_ID to PO_HEADERS_ALL and PO_LINES_ALL to attribute demand to buyers and suppliers. Auditing queries filter on LAST_UPDATE_DATE or PROGRAM_ID to trace which concurrent process last touched a schedule line.

Related Objects

  • CHV_PURGE_SCHEDULE_LIST — referenced via CHV_ITEM_ORDERS.SCHEDULE_ITEM_ID; governs purge eligibility of schedule items.
  • PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL — joined through DOCUMENT_HEADER_ID, DOCUMENT_LINE_ID, and DOCUMENT_SHIPMENT_ID for source purchasing detail.
  • PO_SUPPLIERS / PO_VENDORS — supplier context for release reporting.
  • MTL_UNITS_OF_MEASURE — resolves the purchasing and primary UOM codes.
  • CHV_SCHEDULE_HEADERS / related CHV schedule tables — parent scheduling context via SCHEDULE_ID and SCHEDULE_ITEM_ID.
  • FND_CONCURRENT_PROGRAMS / FND_CONCURRENT_REQUESTS — resolves PROGRAM_ID and REQUEST_ID for traceability.
  • FND_USER — resolves CREATED_BY and LAST_UPDATED_BY.