Table: JMF_SUBCONTRACT_ORDERS

Product:	JMF - Supply Chain Localizations
Description:	JMF_SUBCONTRACT_ORDERS stores the SHIKYU subcontracting order information. The Interlock SHIKYU concurrent program will create a record in this table for each shipment line in the source outsourced assembly item purchase order.
Implementation/DBA Data:	JMF.JMF_SUBCONTRACT_ORDERS

Primary Key: JMF_SUBCONTRACT_ORDERS_PK

1. SUBCONTRACT_PO_SHIPMENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
JMF_SUBCONTRACT_ORDERS		PO_LINE_LOCATIONS_ALL	JMF_SUBCONTRACT_ORDERS.SUBCONTRACT_PO_SHIPMENT_ID
JMF_SUBCONTRACT_ORDERS		PA_TASKS	JMF_SUBCONTRACT_ORDERS.TASK_ID
JMF_SUBCONTRACT_ORDERS		MTL_PARAMETERS	JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS		MTL_PARAMETERS	JMF_SUBCONTRACT_ORDERS.TP_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS		WIP_DISCRETE_JOBS	JMF_SUBCONTRACT_ORDERS.WIP_ENTITY_ID
JMF_SUBCONTRACT_ORDERS		MTL_SYSTEM_ITEMS_B	JMF_SUBCONTRACT_ORDERS.OSA_ITEM_ID JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS		FND_CURRENCIES	JMF_SUBCONTRACT_ORDERS.CURRENCY
JMF_SUBCONTRACT_ORDERS		PA_PROJECTS_ALL	JMF_SUBCONTRACT_ORDERS.PROJECT_ID
JMF_SHIKYU_COMPONENTS		JMF_SUBCONTRACT_ORDERS	JMF_SHIKYU_COMPONENTS.SUBCONTRACT_PO_SHIPMENT_ID