OA_WIP Critical Tables
The OA_WIP application class monitors the following Critical Tables:
Table | Description |
|---|---|
MTL_SYSTEM_ITEMS | Inventory master file (in version 11.03 only) |
MTL_SYSTEM_ITEMS_B | Inventory master file (in version 11i or later only) |
WIP_ENTITIES | Header level information about discrete jobs or repetitive assemblies |
WIP_DISCRETE_JOBS | Work order job definitions |
WIP_LINES | Work order lines |
WIP_REPETITIVE_ITEMS | Stores repetitive schedule information |
WIP_OPERATIONS | Stores sequence information about the operations related to a particular work order |
WIP_REQUIREMENT_OPERATIONS | Material requirements for jobs or schedules |
WIP_OPERATION_RESOURCES | Information about resources associated with a job or repetitive schedule |
WIP_SO_ALLOCATIONS | Stores historical and current information about the relationship between specific jobs and sales order lines for assemble-to-order items or configurations |
WIP_TRANSACTIONS | Keeps information about each resource transaction in Oracle WIP, which is used to track resources and to calculate values |
WIP_REPETITIVE_SCHEDULES | Stores information about repetitive schedules to control repetitive production |
Related topic