eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: WIP_DISCRETE_JOBS

Product:	WIP - Work in Process
Description:	Discrete jobs
Implementation/DBA Data:	WIP.WIP_DISCRETE_JOBS

Primary Key: WIP_DISCRETE_JOBS_PK

WIP_ENTITY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_DISCRETE_JOBS	MTL_ITEM_REVISIONS_B	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.BOM_REVISION
WIP_DISCRETE_JOBS	MTL_SECONDARY_LOCATORS	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.COMPLETION_LOCATOR_ID
WIP_DISCRETE_JOBS	BOM_STRUCTURES_B	WIP_DISCRETE_JOBS.COMMON_BOM_SEQUENCE_ID
WIP_DISCRETE_JOBS	BOM_OPERATIONAL_ROUTINGS	WIP_DISCRETE_JOBS.COMMON_ROUTING_SEQUENCE_ID
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.MATERIAL_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.MATERIAL_OVERHEAD_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.RESOURCE_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.OUTSIDE_PROCESSING_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.MATERIAL_VARIANCE_ACCOUNT
WIP_DISCRETE_JOBS	MTL_RTG_ITEM_REVISIONS	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.ROUTING_REVISION
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.RESOURCE_VARIANCE_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.OUTSIDE_PROC_VARIANCE_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.STD_COST_ADJUSTMENT_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.OVERHEAD_ACCOUNT
WIP_DISCRETE_JOBS	GL_CODE_COMBINATIONS	WIP_DISCRETE_JOBS.OVERHEAD_VARIANCE_ACCOUNT
WIP_DISCRETE_JOBS	MTL_SYSTEM_ITEMS_B	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_DISCRETE_JOBS	MTL_SYSTEM_ITEMS_B	WIP_DISCRETE_JOBS.BOM_REFERENCE_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_DISCRETE_JOBS	MTL_SYSTEM_ITEMS_B	WIP_DISCRETE_JOBS.ROUTING_REFERENCE_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_DISCRETE_JOBS	MTL_KANBAN_CARDS	WIP_DISCRETE_JOBS.KANBAN_CARD_ID
WIP_DISCRETE_JOBS	PJM_UNIT_NUMBERS	WIP_DISCRETE_JOBS.END_ITEM_UNIT_NUMBER
WIP_DISCRETE_JOBS	WIP_ENTITIES	WIP_DISCRETE_JOBS.WIP_ENTITY_ID
WIP_DISCRETE_JOBS	WIP_ACCOUNTING_CLASSES	WIP_DISCRETE_JOBS.CLASS_CODE WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_DISCRETE_JOBS	MTL_ITEM_SUB_INVENTORIES	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.COMPLETION_SUBINVENTORY
WIP_DISCRETE_JOBS	MTL_SECONDARY_INVENTORIES	WIP_DISCRETE_JOBS.COMPLETION_SUBINVENTORY WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_DISCRETE_JOBS	MTL_ITEM_LOCATIONS	WIP_DISCRETE_JOBS.COMPLETION_LOCATOR_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID
CSD_REPAIR_JOB_XREF	WIP_DISCRETE_JOBS	CSD_REPAIR_JOB_XREF.WIP_ENTITY_ID
CSD_REPAIR_JOB_XREF	WIP_DISCRETE_JOBS	CSD_REPAIR_JOB_XREF.WIP_ENTITY_ID
CSD_REPAIR_ORDER_GROUPS	WIP_DISCRETE_JOBS	CSD_REPAIR_ORDER_GROUPS.WIP_ENTITY_ID
CSI_ITEM_INSTANCES	WIP_DISCRETE_JOBS	CSI_ITEM_INSTANCES.WIP_JOB_ID
CST_EAM_BALANCE_BY_ACCOUNTS	WIP_DISCRETE_JOBS	CST_EAM_BALANCE_BY_ACCOUNTS.WIP_ENTITY_ID
EAM_METER_READINGS	WIP_DISCRETE_JOBS	EAM_METER_READINGS.WIP_ENTITY_ID
EAM_PM_LAST_SERVICE	WIP_DISCRETE_JOBS	EAM_PM_LAST_SERVICE.WIP_ENTITY_ID
JMF_SUBCONTRACT_ORDERS	WIP_DISCRETE_JOBS	JMF_SUBCONTRACT_ORDERS.WIP_ENTITY_ID
MTL_MATERIAL_TRANSACTIONS	WIP_DISCRETE_JOBS	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	WIP_DISCRETE_JOBS	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID
WIP_DJ_CLOSE_TEMP	WIP_DISCRETE_JOBS	WIP_DJ_CLOSE_TEMP.WIP_ENTITY_ID
WIP_EAM_WORK_REQUESTS	WIP_DISCRETE_JOBS	WIP_EAM_WORK_REQUESTS.WIP_ENTITY_ID
WIP_JOB_SCHEDULE_INTERFACE	WIP_DISCRETE_JOBS	WIP_JOB_SCHEDULE_INTERFACE.WIP_ENTITY_ID
WIP_OPERATIONS	WIP_DISCRETE_JOBS	WIP_OPERATIONS.WIP_ENTITY_ID
WIP_PERIOD_BALANCES	WIP_DISCRETE_JOBS	WIP_PERIOD_BALANCES.WIP_ENTITY_ID
WIP_REQUIREMENT_OPERATIONS	WIP_DISCRETE_JOBS	WIP_REQUIREMENT_OPERATIONS.WIP_ENTITY_ID
WIP_SHOP_FLOOR_STATUSES	WIP_DISCRETE_JOBS	WIP_SHOP_FLOOR_STATUSES.WIP_ENTITY_ID
WIP_SO_ALLOCATIONS	WIP_DISCRETE_JOBS	WIP_SO_ALLOCATIONS.WIP_ENTITY_ID
WIP_TRANSACTION_ACCOUNTS	WIP_DISCRETE_JOBS	WIP_TRANSACTION_ACCOUNTS.WIP_ENTITY_ID