Results for “ordered_quantity”

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

Overview

JMF_SHIKYU_REPLENISHMENTS is a transactional table owned by the JMF schema (Supply Chain Localizations) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores replenishment sales order information created to fulfill the requirements of a specific SHIKYU component item exchanged between an Origin Equipment Manufacturer (OEM) and a Trading Partner Organization (TP). SHIKYU is a commonly used Japanese term for "delivery quantity" or "delivery schedule," and the table supports the Supply Chain Localizations process for tracking committed replenishment flows between the two trading parties.

In heuristic Data Vault modeling terms, this object is best classified as a link: it materializes the relationship between an OEM organization, a trading partner organization, a sourcing supplier (and site), a sales order line, a purchase order shipment, and a SHIKYU component item. Its 33 documented columns and seven foreign key relationships reflect an associative structure rather than a strictly descriptive satellite.

Key Information Stored

The table uses REPLENISHMENT_SO_LINE_ID as its surrogate primary key, enforced by unique index JMF_SHIKYU_REPLENISHMENTS_U1; this column is also the sole documented business-key candidate and is a foreign key to OE_ORDER_LINES_ALL. The remaining columns capture the operational identity and quantities of the replenishment:

• REPLENISHMENT_SO_LINE_ID / REPLENISHMENT_SO_HEADER_ID – sales order line and header linking the replenishment back to Order Management.
• REPLENISHMENT_PO_HEADER_ID, REPLENISHMENT_PO_LINE_ID, REPLENISHMENT_PO_SHIPMENT_ID – the purchasing side of the flow, with the shipment ID keyed to PO_LINE_LOCATIONS_ALL.
• OEM_ORGANIZATION_ID and TP_ORGANIZATION_ID – the two trading organizations, both foreign keys to MTL_PARAMETERS.
• TP_SUPPLIER_ID and TP_SUPPLIER_SITE_ID – the trading partner supplier and site, referencing PO_VENDORS and PO_VENDOR_SITES_ALL.
• SHIKYU_COMPONENT_ID – identifies the SHIKYU component item, referencing MTL_SYSTEM_ITEMS_B.
• ORDERED_QUANTITY, ALLOCATED_QUANTITY, ALLOCABLE_QUANTITY and their primary-UOM counterparts (ORDERED_PRIMARY_UOM_QUANTITY, ALLOCATED_PRIMARY_UOM_QUANTITY, ALLOCABLE_PRIMARY_UOM_QUANTITY) – quantity states at each stage of the replenishment lifecycle.
• ADDITIONAL_SUPPLY – supplemental supply recognized against the requirement.
• OSA_ITEM_PRICE and CURRENCY – pricing and currency context for the trading transaction.
• STATUS – lifecycle indicator used by the localization process to track progress; supported by standard audit and concurrency columns (ORG_ID, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, LAST_UPDATE_DATE, CREATED_BY, and related).

Common Use Cases and Queries

Typical reporting scenarios include reconciling OEM-to-TP replenishment orders, verifying that allocated quantity does not exceed ordered quantity, and tracing a PO shipment back to the originating sales order line. A representative pattern joins the ordered and allocated quantities by component and organization:

• SELECT shikyu_component_id, oem_organization_id, tp_organization_id, ordered_quantity, allocated_quantity, allocable_quantity FROM jmf.jmf_shikyu_replenishments WHERE status = :p_status
• Join to OE_ORDER_LINES_ALL on REPLENISHMENT_SO_LINE_ID to obtain operating unit and line status.
• Join to PO_LINE_LOCATIONS_ALL on REPLENISHMENT_PO_SHIPMENT_ID to confirm shipment schedules and arrival dates.
• Aggregate ORDERED_PRIMARY_UOM_QUANTITY by TP_SUPPLIER_ID for supplier scorecards using the primary UOM basis.
• Filter by REQUEST_ID or PROGRAM_ID to audit a specific concurrent program run.

Related Objects

The following objects are directly referenced or reference JMF_SHIKYU_REPLENISHMENTS through the documented relationships:

• OE_ORDER_LINES_ALL – sales order line (FK: REPLENISHMENT_SO_LINE_ID).
• PO_LINE_LOCATIONS_ALL – purchase order shipment (FK: REPLENISHMENT_PO_SHIPMENT_ID).
• MTL_PARAMETERS – organization definition for both OEM_ORGANIZATION_ID and TP_ORGANIZATION_ID.
• MTL_SYSTEM_ITEMS_B – item master for SHIKYU_COMPONENT_ID.
• PO_VENDORS – trading partner supplier (FK: TP_SUPPLIER_ID).
• PO_VENDOR_SITES_ALL – trading partner supplier site (FK: TP_SUPPLIER_SITE_ID).
• OE_ORDER_HEADERS_ALL – logically related through the sales order header identifier carried on the table.
• PO_HEADERS_ALL and PO_LINES_ALL – purchasing header and line context referenced by the PO IDs.