Enterprise Asset Management - EBS (MOSC)

MOSC Banner

WIP_REQUIREMENT_OPERATIONS_V table does not display all materials in the work order

We have a work order that has 16 material requirements (2 inventory items and 14 direct items). However, if we query the work order from WIP_REQUIREMENT_OPERATIONS_V, only 3 materials display in the result: 2 inventory items and 1 direct items. Please see below:


Work Order Materials View:


When running query:

select * from WIP_REQUIREMENT_OPERATIONS_V where wip_entity_id = 300810. Only these 3 display:



Hope someone can help me on this.


Thanks,

Roma

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center