FND Design Data [Home] [Help]

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: TableJMF.JMF_SUBCONTRACT_ORDERS
Primary Key: JMF_SUBCONTRACT_ORDERS_PK
  1. ColumnSUBCONTRACT_PO_SHIPMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JMF_SUBCONTRACT_ORDERS FK Joins to TablePO_LINE_LOCATIONS_ALL JMF_SUBCONTRACT_ORDERS.SUBCONTRACT_PO_SHIPMENT_ID
JMF_SUBCONTRACT_ORDERS FK Joins to TablePA_TASKS JMF_SUBCONTRACT_ORDERS.TASK_ID
JMF_SUBCONTRACT_ORDERS FK Joins to TableMTL_PARAMETERS JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS FK Joins to TableMTL_PARAMETERS JMF_SUBCONTRACT_ORDERS.TP_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS FK Joins to TableWIP_DISCRETE_JOBS JMF_SUBCONTRACT_ORDERS.WIP_ENTITY_ID
JMF_SUBCONTRACT_ORDERS FK Joins to TableMTL_SYSTEM_ITEMS_B JMF_SUBCONTRACT_ORDERS.OSA_ITEM_ID
JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS FK Joins to TableFND_CURRENCIES JMF_SUBCONTRACT_ORDERS.CURRENCY
JMF_SUBCONTRACT_ORDERS FK Joins to TablePA_PROJECTS_ALL JMF_SUBCONTRACT_ORDERS.PROJECT_ID
TableJMF_SHIKYU_COMPONENTS FK Joins to JMF_SUBCONTRACT_ORDERS JMF_SHIKYU_COMPONENTS.SUBCONTRACT_PO_SHIPMENT_ID