Search Results chv_item_orders_u1

Overview

PO.CHV_ITEM_ORDERS is a transactional table in the Oracle E-Business Suite supplier scheduling (CHV) module. It stores the order information for items associated with supplier schedules, capturing three supply document types: unimplemented planned orders, approved requisitions, and approved releases. The table maintains a child relationship to CHV_SCHEDULE_ITEMS, meaning each row represents an individual order line tied to a specific schedule item. This structure allows the supplier scheduling engine to reconcile demand from requisitions, planned orders, and releases against the schedule quantities communicated to suppliers.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free setting of 10, and its indexes are stored in APPS_TS_TX_IDX. In Oracle EBS 12.1.1 and 12.2.2, its FND Design Data reference is CHV.CHV_ITEM_ORDERS, and the object status is VALID. From a Data Vault modeling perspective, the metadata classifies this table heuristically as standalone, meaning it does not participate in a typical hub/link/satellite hierarchy through foreign keys. Where a modeling suggestion is required, CHV_ITEM_ORDERS functions best as a satellite-like structure recording supply-document attributes keyed by the schedule order identifier.

Key Information Stored

The table contains 37 documented columns. The most significant are:

• SCHEDULE_ORDER_ID — The unique order identifier for a schedule item order. This is the surrogate primary key column, enforced by the unique index CHV_ITEM_ORDERS_U1.
• SCHEDULE_ID — The schedule header unique identifier, indexing the parent schedule. Covered by the non-unique index CHV_ITEM_ORDERS_N1.
• SCHEDULE_ITEM_ID — The schedule item unique identifier linking the order to its parent item. Indexed by CHV_ITEM_ORDERS_U2 (non-unique in the documented schema, though it serves as a business-key candidate).
• SUPPLY_DOCUMENT_TYPE — Indicates whether the order originates from a planned order, requisition, or release (VARCHAR2(25)).
• ORDER_QUANTITY — Quantity ordered in the purchasing unit of measure.
• ORDER_QUANTITY_PRIMARY — Quantity ordered converted to the primary unit of measure.
• PURCHASING_UNIT_OF_MEASURE and PRIMARY_UNIT_OF_MEASURE — The two UOM contexts for the ordered quantity.
• DUE_DATE — The order due date, indexed non-uniquely by CHV_ITEM_ORDERS_N3 for date-range reporting.
• DOCUMENT_HEADER_ID, DOCUMENT_LINE_ID, DOCUMENT_SHIPMENT_ID — Identifiers pointing back to the originating supply document (requisition, planned order, or release) at header, line, and shipment granularity.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns identifying the process that last wrote the row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments for extensibility.
• LAST_UPDATE_DATE, CREATED_BY, and the other Standard Who columns — Audit trail fields.

Common Use Cases and Queries

CHV_ITEM_ORDERS is primarily queried to reconcile open supply against supplier schedules. A typical reporting scenario lists all approved requisitions and releases due within a window for a given schedule:

• Joining SCHEDULE_ITEM_ID back to CHV_SCHEDULE_ITEMS to obtain item and supplier context.
• Filtering by SUPPLY_DOCUMENT_TYPE to isolate planned orders versus requisitions versus releases.
• Aggregating ORDER_QUANTITY by SCHEDULE_ID and DUE_DATE to project committed demand.
• Driving the DUE_DATE index (CHV_ITEM_ORDERS_N3) for date-bounded reports.

A representative query pattern selects the schedule header, item, supply type, and quantities where the due date falls within a range, ordering by schedule and due date. Because the table is populated and refreshed by the supplier scheduling concurrent programs, rows carry REQUEST_ID and PROGRAM_ID for lineage. Purging and archival routines reference the table through CHV_PURGE_SCHEDULE_LIST.

Related Objects

• CHV_SCHEDULE_ITEMS — Parent table via SCHEDULE_ITEM_ID; the documented child relationship establishing item-level context.
• CHV_PURGE_SCHEDULE_LIST — Referenced by the foreign key on SCHEDULE_ITEM_ID; supports purge processing.
• PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL — Source documents for requisition-type supply, linked through DOCUMENT_HEADER_ID and DOCUMENT_LINE_ID.
• PO_RELEASES_ALL and PO_LINE_LOCATIONS_ALL — Source documents for release-type supply via DOCUMENT_HEADER_ID and DOCUMENT_SHIPMENT_ID.
• MRP_Planned_Orders — Source of planned-order supply rows.
• CHV_SCHEDULE_HEADERS — Provides the schedule header referenced by SCHEDULE_ID.