WIP Views (206)

WIP - Work in Process — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`WIPBV_ACCOUNTING_CLASSES`
`WIPBV_FLOW_SCHEDULES`
`WIPBV_FLOW_SCHED_COMPS`
`WIPBV_INTRAOP_STEP_STATUSES`
`WIPBV_JOB_CLOSE_VARIANCE_TXNS`
`WIPBV_MFG_COST_UPDATE_TXNS`
`WIPBV_MFG_ORDERS`
`WIPBV_MFG_RESOURCE_TXNS`
`WIPBV_MFG_TRANSACTIONS`
`WIPBV_MTL_TXN_ALLOCATIONS`
`WIPBV_OSP_MFG_TXNS`
`WIPBV_OVERHEAD_MFG_TXNS`
`WIPBV_PERIOD_CLOSE_VAR_TXNS`
`WIPBV_REPETITIVE_SCHEDULES`
`WIPBV_WIP_COMPONENTS`
`WIPBV_WIP_EMPLOYEE_LABOR_RATES`	Employee labor rate and labor rate effective date information.
`WIPBV_WIP_INTRAOPERATION_STEPS`
`WIPBV_WIP_JOBS`
`WIPBV_WIP_MOVE_TRANSACTIONS`
`WIPBV_WIP_MOVE_TXN_ALLOCATIONS`
`WIPBV_WIP_OPERATIONS`
`WIPBV_WIP_OPERATION_RESOURCES`
`WIPBV_WIP_PERIOD_BALANCES`
`WIPBV_WIP_REPETITIVE_ITEMS`
`WIPBV_WIP_RESERVATIONS`
`WIPBV_WIP_SCHEDULE_GROUPS`
`WIPBV_WIP_STATUS_CODES`
`WIPBV_WIP_TXN_ALLOCATIONS`
`WIPFV_ACCOUNTING_CLASSES`
`WIPFV_FLOW_SCHEDULES`
`WIPFV_FLOW_SCHED_COMPS`
`WIPFV_INTRAOP_STEP_STATUSES`
`WIPFV_JOB_CLOSE_VARIANCE_TXNS`
`WIPFV_MFG_COST_UPDATE_TXNS`
`WIPFV_MFG_ORDERS`
`WIPFV_MFG_RESOURCE_TXNS`
`WIPFV_MFG_TRANSACTIONS`
`WIPFV_MTL_TXN_ALLOCATIONS`
`WIPFV_OSP_MFG_TXNS`
`WIPFV_OVERHEAD_MFG_TXNS`
`WIPFV_PERIOD_CLOSE_VAR_TXNS`
`WIPFV_REPETITIVE_SCHEDULES`
`WIPFV_WIP_COMPONENTS`
`WIPFV_WIP_EMPLOYEE_LABOR_RATES`
`WIPFV_WIP_INTRAOPERATION_STEPS`
`WIPFV_WIP_JOBS`
`WIPFV_WIP_MOVE_TRANSACTIONS`
`WIPFV_WIP_MOVE_TXN_ALLOCATIONS`
`WIPFV_WIP_OPERATIONS`
`WIPFV_WIP_OPERATION_RESOURCES`
`WIPFV_WIP_PERIOD_BALANCES`
`WIPFV_WIP_REPETITIVE_ITEMS`
`WIPFV_WIP_RESERVATIONS`
`WIPFV_WIP_SCHEDULE_GROUPS`
`WIPFV_WIP_STATUS_CODES`
`WIPFV_WIP_TXN_ALLOCATIONS`
`WIP_ACTIVE_DISCRETE_JOBS_VAL_V`	Active discrete jobs
`WIP_BIS_LATE_PROD_COMP_V`	Discrete jobs or repetitive schedules that completed late
`WIP_BIS_PERF_TO_PLAN_V`	Number of items produced/scheduled
`WIP_BIS_PERIOD_BALANCE_V`	Value of WIP for discrete jobs and repetitive schdules
`WIP_BIS_PRODUCTIVITIES_V`	Efficiency for hour-based resources
`WIP_BIS_PROD_ASSY_YIELD_V`	Total/Scrapped quantity at specific organization/date
`WIP_BIS_PROD_DEPT_YIELD_V`	Completed/Scrapped quantity for department/operation/date
`WIP_BIS_PROD_VAL_EMP_V`	Average production per employee in an inventory organization
`WIP_BIS_SCRAP_REASONS_V`	Information about scrapped assemblies on a given date
`WIP_BIS_UTZ_CATNOITEM_V`	Resource Utilization including Product Category without Inventory Item
`WIP_BIS_UTZ_CAT_V`	Resource Utilization with Product Category and Inventory Item
`WIP_BIS_UTZ_NOCAT_V`	Resource Utilization including Inventory Item without Product Category
`WIP_COMMENT_CODES_V`	Types of comments that can be attached to WIP entities
`WIP_COMP_SALES_ORDERS_VAL_V`	Sales orders for completion transactions
`WIP_COST_TXN_INTERFACE_V`	Foreign-key data for WIP_COST_TXN_INTERFACE
`WIP_CUMULATIVE_SCRAP_V`
`WIP_CUR_NET_AVAILABLE_VIEW`	Current job/schedule material requirement subinventory quantities
`WIP_CUR_SUB_LOC_NET_AVAIL_VIEW`	Current job/schedule material requirement supply subinventory/locator quantities
`WIP_DEF_CAT_ACC_CLASSES_V`	Default accounting classes
`WIP_DEPT_IMM_DISPATCH_V`	Department immediate dispatch list
`WIP_DEPT_RESOURCES_V`	Resources owned by a department
`WIP_DEPT_UPS_DISPATCH_V`	Department upstream dispatch list
`WIP_DISCRETE_CLASSES_ALL_V`	Discrete and non-standard accounting classes
`WIP_DISCRETE_JOBS_ALL_V`	Summary discrete job data
`WIP_DISCRETE_JOBS_V`	Foreign-key data for WIP_DISCRETE_JOBS
`WIP_DISC_INTRAOP_STEPS_VAL_V`	Intraoperation steps
`WIP_EAM_COST_DETAILS_V`	Detailed cost information for EAM work orders
`WIP_EAM_CST_HEADER_V`	Cost information for EAM work orders
`WIP_EAM_DIRECT_ITEMS_V`	Direct Items for EAM work orders
`WIP_EAM_ENTITIES_V`	EAM work order information
`WIP_EAM_NEXT_OPERATIONS_V`	EAM Operation Dependency - Next Ops
`WIP_EAM_OP_COST_DETAILS_V`	Cost information by operation
`WIP_EAM_OSP_V`	This view shows all the resources for outside processing along with the requisitions and purchase orders information
`WIP_EAM_PARAMETERS_V`	View for EAM organization parameters.
`WIP_EAM_PRIOR_OPERATIONS_V`	EAM Operation Dependency - Prior Ops
`WIP_EAM_REQUIREMENTS_ALL_V`	This view provides all materials for a work order
`WIP_EAM_WORK_ORDERS_V`	Maintenance Work Orders
`WIP_EAM_WORK_ORDER_DTLS_V`	Detailed information for maintenance work orders
`WIP_EAM_WORK_REQUESTS_V`	View for Work Request information
`WIP_EAM_WO_SRV_ASSOC_V`
`WIP_ENTITY_COMMENTS_V`	Attachments to WIP entities
`WIP_EXPLOSIONS_V`	WIP explosion information
`WIP_FIRST_ACTIVE_SCHEDULE_V`	Earliest active repetitive schedule on a line for a repetitive assembly
`WIP_FIRST_OPEN_SCHEDULE_V`	Earliest open repetitive schedule on a line for a repetitive assembly
`WIP_FIRST_TXN_SCHEDULE_V`	Earliest transactable repetitive schedule on a line for a repetitive assembly
`WIP_FLOW_ASSEMBLIES_V`	Flow Workstation base view.
`WIP_FLOW_ASSEMBLY_EVENTS_V`	Flow Workstation base view.
`WIP_FLOW_LINE_LINEARITY_V`	Flow Workstation base view
`WIP_FLOW_MIX_LINEARITY_V`	Flow Workstation base view
`WIP_FLOW_OPEN_ALLOCATIONS_V`	Open allocations for flow schedules
`WIP_FLOW_SCHEDULES_V`	Foreign-key data for WIP_FLOW_SCHEDULES
`WIP_FLOW_SCHEDULE_EVENTS_V`	Flow Workstation base view
`WIP_ICX_COMPONENTS_V`	Component information for job/schedule operations
`WIP_ICX_OSP_WORKBENCH_V`	WIP outside processing purchase orders information
`WIP_INST_EMP_IMM_DISPATCH_V`	Employee resource instance immediate dispatch list
`WIP_INST_EMP_UPS_DISPATCH_V`	Employee resource instance upstream dispatch list
`WIP_INST_EQP_IMM_DISPATCH_V`	Equipment resource instance immediate dispatch list
`WIP_INST_EQP_UPS_DISPATCH_V`	Equipment resource instance upstream dispatch list
`WIP_INTERFACE_ERRORS_V`	Foreign-key data for WIP_INTERFACE_ERRORS
`WIP_JOBS_AND_SCHEDULES_V`	Summary data for jobs and schedules
`WIP_JOBS_RESERVATIONS_V`	Data for Jobs eligible for reservations
`WIP_JOB_ASSY_LINE_V`	Jobs, Repetitive Schedules, Flow Schedules and their assemblies and lines
`WIP_JOB_LOT_COMPOSITION_V`	Discrete job lot composition
`WIP_JOB_OPEN_ALLOCATIONS_V`	Open allocations for jobs
`WIP_JOB_SCHEDULE_INTERFACE_V`	Foreign-key data for WIP_JOB_SCHEDULE_INTERFACE
`WIP_JOB_SERIAL_NUMBERS_V`
`WIP_LINES_ALL_V`	Production lines
`WIP_LINES_VAL_V`	Enabled production lines
`WIP_LINE_OPERATIONS_V`	Flow Workstation base view
`WIP_LOTJOB_OPEN_ALLOCATIONS_V`	Open allocations for lot-based jobs
`WIP_MATERIAL_SHORTAGES_V`	Material shortage data
`WIP_MOVE_TRANSACTIONS_V`	Foreign-key data for WIP_MOVE_TRANSACTIONS
`WIP_MOVE_TXN_INTERFACE_V`	Foreign-key data WIP_MOVE_TXN_INTERFACE
`WIP_NET_AVAILABLE_VIEW`	Job/schedule material requirement subinventory quantities
`WIP_NON_STANDARD_CLASSES_VAL_V`	Nonstandard accounting classes
`WIP_ON_DISCRETE_JOBS_V`	AK Job Composition View
`WIP_OPEN_DEMANDS_V`	This view is used to retrieve sales orders that are not reserved.
`WIP_OPEN_DISCRETE_JOBS_VAL_V`	Open discrete jobs
`WIP_OPEN_FLOW_SCHEDULES_V`	This view is used to retrieve open flow schedules.
`WIP_OPEN_SCHEDULES_VAL_V`	Open repetitive schedules
`WIP_OPERATIONS_ALL_V`	Summary operation data
`WIP_OPERATIONS_INQ_V`	In-queue quantities for operations
`WIP_OPERATIONS_V`	Foreign-key data for WIP_OPERATIONS
`WIP_OPERATION_INSTRUCTIONS_V`	Instructions attached to operations
`WIP_OPERATION_RESOURCES_INQ_V`	Additional data for WIP_OPERATION_RESOURCES
`WIP_OPERATION_RESOURCES_V`	Foreign-key data for WIP_OPERATION_RESOURCES
`WIP_OPERATION_RESOURCE_USAGE_V`	Resolves foreign key data for WIP_OPERATION_RESOURCE_USAGE
`WIP_OPERATION_SKILLS_V`	This view is based on WIP_OPERATION_COMPETENCIES table.
`WIP_OPSM_WORK_ORDER_EXPORT_V`
`WIP_OP_RESOURCE_INSTANCES_V`	This view is used to select all instances of an operation resource.
`WIP_OP_RES_INSTANCE_USAGE_V`	Usage data for operation resources
`WIP_OSP_DEST_OPERATION_V`	Destination operation for outside processing resources
`WIP_OSP_JOBS_VAL_V`	Active jobs with outside processing resources
`WIP_OSP_LINES_VAL_V`	Enabled production lines with schedules with outside processing resources
`WIP_OSP_OPERATIONS_VAL_V`	Operations with outside processing resources
`WIP_OSP_REP_ASSY_VAL_V`	Repetitive assemblies and production lines with schedules with outside processing resources
`WIP_OSP_REP_SCHED_VAL_V`	Repetitive schedules with outside processing resources
`WIP_OSP_REQS_POS_V`	Requisitions and purchase orders information for a job or repetitive schedule
`WIP_OSP_RESOURCES_VAL_V`	Outside processing resources
`WIP_PARAMETERS_V`	Foreign-key data for WIP_PARAMETERS
`WIP_PCB_BOM_DEPARTMENTS_V`	WIP Production Control Board base view
`WIP_PCB_DEPT_IMM_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_DEPT_RESOURCES_V`	WIP Production Control Board base view
`WIP_PCB_DEPT_UPS_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_EMP_IMM_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_EMP_UPS_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_EQP_IMM_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_EQP_UPS_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_FLOW_ASSEMBLIES_V`	WIP Production Control Board base view
`WIP_PCB_FLOW_ASSEMBLY_EVENTS_V`	WIP Production Control Board base view
`WIP_PCB_FLOW_SCHEDULE_EVENTS_V`	WIP Production Control Board base view
`WIP_PCB_OPEN_FLOW_SCHEDULES_V`	WIP Production Control Board base view
`WIP_PCB_RES_IMM_DISPATCH_V`	WIP Production Control Board base view
`WIP_PCB_RES_INST_EMPLOYEES_V`	WIP Production Control Board base view
`WIP_PCB_RES_INST_EQUIPMENTS_V`	WIP Production Control Board base view
`WIP_PCB_RES_UPS_DISPATCH_V`	WIP Production Control Board base view
`WIP_REPETITIVE_CLASSES_VAL_V`	Repetitive accounting classes
`WIP_REPETITIVE_ENTITIES_V`	Repetitive assembly/item associations
`WIP_REPETITIVE_ITEMS_V`	Foreign-key data for WIP_REPETITIVE_ITEMS
`WIP_REPETITIVE_SCHEDULES_V`	Foreign-key data for WIP_REPETITIVE_SCHEDULES
`WIP_REP_ASSY_VAL_V`	Repetitive assemblies with active repetitive schedules
`WIP_REP_INTRAOP_STEPS_VAL_V`	Repetitive intraoperation steps
`WIP_REP_OPEN_ALLOCATIONS_V`	Open allocations for repetitive schedules
`WIP_REP_QUANTITY_SCRAPPED_V`	Quantity scrapped for repetitive schedules
`WIP_REQUIREMENT_OPERATIONS_V`	Foreign-key data for WIP_REQUIREMENT_OPERATIONS
`WIP_REQUIREMENT_OPS_INQ_V`	Additional data for WIP_REQUIREMENT_OPERATIONS
`WIP_RESERVATIONS_V`	This view is used to select reservations to WIP Discrete Jobs or WIP Flow Schedules.
`WIP_RES_IMM_DISPATCH_V`	Resource immediate dispatch list
`WIP_RES_INST_EMPLOYEES_V`	Employee resource instances
`WIP_RES_INST_EQUIPMENTS_V`	Equipment resource instances
`WIP_RES_UNITS_WORKED_VIEW`	Resource transaction quantities
`WIP_RES_UPS_DISPATCH_V`	Resource upstream dispatch list
`WIP_RET_SALES_ORDERS_VAL_V`	Sales orders for return transactions
`WIP_SALES_ORDER_LINES_V`	Sales order lines
`WIP_SCHEDULE_GROUPS_VAL_V`	Valid schedule groups
`WIP_SCHEDULING_ERRORS_V`	Errors encountered while processing Open Scheduling Interface requests
`WIP_SCHEDULING_EXCEPTIONS_V`	This view is used to select exceptions that occur during scheduling.
`WIP_SHOP_FLOOR_STATUSES_V`	Foreign-key data for WIP_SHOP_FLOOR_STATUSES
`WIP_SHOP_FLOOR_STATUSES_VAL_V`	Enabled shop floor statuses
`WIP_SO_ALLOCATIONS_V`	Foreign-key data for WIP_SO_ALLOCATIONS
`WIP_STANDARD_CLASSES_VAL_V`	Standard discrete accounting classes
`WIP_SUB_LOC_NET_AVAIL_VIEW`	Job/schedule material requirement supply subinventory/locator quantities
`WIP_SUB_OPERATION_RESOURCES_V`	Foreign-key data for WIP_OPERATION_RESOURCES
`WIP_TRANSACTIONS_V`	Foreign-key data for WIP_TRANSACTIONS
`WIP_TXN_COMP_INTERFACE_V`	Information from MTL_TRANSACTIONS_INTERFACE
`WIP_TXN_DISCRETE_JOBS_VAL_V`	Released and complete discrete jobs
`WIP_TXN_REP_ASSY_VAL_V`	Transactable repetitive assemblies
`WIP_TX_REP_INTRAOP_STEPS_VAL_V`	Repetitive intraoperation steps for released/complete schedules
`WIP_WORKFLOW_V`	Workflows that have been launched for job/repetitive schedules
`WIP_WS_PTPKPI_AGG_V`	MES Production to Plan KPI aggregated View