Latest Posts »
Latest Comments »
Popular Posts »
If you are new here, you may want to subscribe to the following feeds Business Intelligence ,InfoCaptor

WIP Key tables wip_entities , wip_discrete_jobs, wip_transactions (1)

Written by Nilesh Jethwa

WIP_ENTITIES stores information about jobs, repetitive assemblies, and
flow schedules. Each row includes a unique entity name, the entity type,
and the assembly being built. Oracle Work in Process uses this information to control production activities and to ensure that entities with duplicate names are not created.

WIP_DISCRETE_JOBS stores discrete job information. Each row
represents a discrete job, and contains information about the assembly
being built, the revision of the assembly, the job quantity, the status of
the job, the material control method, accounting information, and job
schedule dates. Oracle Work in Process uses this information to control
discrete production.

WIP_TRANSACTIONS stores information about WIP resource
transactions. Each row represents a single resource transaction and
includes a unique transaction Identifier, a transaction date, the job or
repetitive schedule charged, the WIP operation and resource charges,
and the number of units of measure applied. Oracle Work in Process
uses this information to track resource charges and to calculate the
values stored in WIP_TRANSACTION_ACCOUNTS. 

 


Posted in ERP Tables |

Leave a Comment

Other Articles of interest
Free Dashboards and KPI examples
  • Oracle Purchasing (PO) key Vendor tables (5)
  • Oracle Purchasing (PO) key requisition tables (4)
  • Q&A : How does GL know which value set to use for a segment
  • Key ERP Tables
  • Application BI Tackles Tedious Task
  • Build a Dashboard from scratch
  • Oracle Inventory (INV) key tables - mtl_category_sets_b, mtl_categories_b (3)
  • Recent Jobs

    View All Jobs
    Post a Job