Search Results jmf_subcontract_orders_pk

Overview

JMF_SUBCONTRACT_ORDERS is a table owned by the JMF schema (Oracle Supply Chain Localizations) and is a VALID database object in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It stores SHIKYU subcontracting order information. The Interlock SHIKYU concurrent program creates a record in this table for each shipment line in the source outsourced assembly item purchase order, making the table the transactional repository for outsourced assembly (OSA) subcontracting as processed through the Japanese SHIKYU localization flow.

Functionally, the table bridges procurement, manufacturing, and project costing data. Each row represents one subcontracting shipment — that is, one shipment line on an outsourced assembly item purchase order — and carries the reference identifiers (purchase order, project, task, discrete job, organization, and item) required to trace that shipment across the EBS modules. In a heuristic Data Vault classification, the table is satellite-leaning: its primary key is inherited from the source purchase order shipment, and most of its columns are descriptive attributes of that parent business key rather than independent entities.

Key Information Stored

The table contains 25 documented columns. The most significant are listed below.

• SUBCONTRACT_PO_SHIPMENT_ID — The surrogate primary key (JMF_SUBCONTRACT_ORDERS_PK) and the column supporting the unique index JMF_SUBCONTRACT_ORDERS_U1. It is also the business-key candidate, as it derives directly from the PO shipment line.
• SUBCONTRACT_PO_HEADER_ID, SUBCONTRACT_PO_LINE_ID — The purchase order header and line that identify the outsourced assembly item purchase order.
• PROJECT_ID, TASK_ID — Project and task used to charge the subcontracting activity for project costing and billing purposes.
• OEM_ORGANIZATION_ID, TP_ORGANIZATION_ID — The OEM (buyer) organization and the third-party (supplier) organization involved in the subcontracting relationship.
• WIP_ENTITY_ID — The discrete job in WIP that is fed by the outsourced assembly.
• OSA_ITEM_ID, OSA_ITEM_PRICE, UOM, QUANTITY, CURRENCY — The outsourced assembly item, its agreed price, unit of measure, ordered quantity, and transaction currency.
• NEED_BY_DATE — The required delivery date for the shipment.
• INTERLOCK_STATUS, BATCH_ID, REQUEST_ID — Processing metadata that identifies the Interlock SHIKYU concurrent request and its outcome per record.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, PROGRAM_ID, PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID — Standard EBS WHO columns plus concurrent program audit columns.

Common Use Cases and Queries

Typical uses include monitoring SHIKYU subcontracting orders created by the Interlock SHIKYU concurrent program, reconciling outsourced assembly shipments against purchase order shipment lines, and reporting on outstanding or incomplete processing through INTERLOCK_STATUS. The table also supports project costing extracts that join PROJECT_ID and TASK_ID to PA_PROJECTS_ALL and PA_TASKS.

A representative query joining to the purchase order shipment line is:

• SELECT j.subcontract_po_shipment_id, j.subcontract_po_header_id, j.subcontract_po_line_id, j.quantity, j.osa_item_price, j.need_by_date, j.interlock_status FROM jmf.jmf_subcontract_orders j WHERE j.oem_organization_id = :org_id AND j.interlock_status = :status;
• SELECT j.*, p.quantity_received, p.shipment_num FROM jmf.jmf_subcontract_orders j, po_line_locations_all p WHERE j.subcontract_po_shipment_id = p.line_location_id;
• SELECT j.wip_entity_id, w.wip_entity_name, j.osa_item_id FROM jmf.jmf_subcontract_orders j, wip_discrete_jobs w WHERE j.wip_entity_id = w.wip_entity_id;

Related Objects

The following objects are most significant in relation to JMF_SUBCONTRACT_ORDERS, based on the documented foreign key relationships.

• PO_LINE_LOCATIONS_ALL — referenced via SUBCONTRACT_PO_SHIPMENT_ID; the parent purchase order shipment line.
• PA_PROJECTS_ALL and PA_TASKS — referenced via PROJECT_ID and TASK_ID; project and task context for costing.
• MTL_PARAMETERS — referenced twice, via OEM_ORGANIZATION_ID and TP_ORGANIZATION_ID; defines the buyer and supplier organizations.
• WIP_DISCRETE_JOBS — referenced via WIP_ENTITY_ID; links the subcontracting order to the manufacturing job.
• MTL_SYSTEM_ITEMS_B — referenced via OSA_ITEM_ID; the outsourced assembly item definition.
• FND_CURRENCIES — referenced via CURRENCY; validates the transaction currency.
• JMF_SHIKYU_COMPONENTS — references this table via SUBCONTRACT_PO_SHIPMENT_ID; stores the components supplied to the third party.
• JMF_SHIKYU_ADJUSTMENTS and JMF_SHIKYU_SPR_RPT_TEMP — dependent tables keyed on SUBCONTRACT_PO_SHIPMENT_ID for adjustments and reporting staging.
• JMF_SUBCONTRACT_ORDERS_TEMP — a temporary companion table sharing the same key column, typically used during Interlock SHIKYU processing.