Query all components of the WIP discrete work order

WIP-> discrete-> Discrete Task

Task kevin13: information of all components in this ticket:

Select MSI. segment1,
MSI. description,
WDJ. class_code,
WDJ. status_type,
WDJ. start_quantity,
Wdj.net _ quantity,
WDJ. quantity_completed,
WDJ. quantity_scrapped,
WDJ. scheduled_start_date,
WDJ. scheduled_completion_date,
Wro. operation_seq_num,
Dept. department_code,
Wro. date_required,
Msi1.segment1,
Msi1.description,
Wro. required_quantity,
Wro. quantity_issued,
(Wro. required_quantity-wro. quantity_issued) quantity_open
From wip_discrete_jobs WDJ,
Wip_entities we,
Mtl_system_items_ B MSI,
Wip_requirement_operations wro,
Mtl_system_items_ B msi1,
Bom_administrative ments Dept
Where WDJ. wip_entity_id = We. wip_entity_id
And WDJ. primary_item_id = MSI. inventory_item_id
And WDJ. organization_id = MSI. organization_id
And WDJ. wip_entity_id = wro. wip_entity_id
And wro. inventory_item_id = msi1.inventory _ item_id
And wro. organization_id = msi1.organization _ id
And wro. department_id = Dept. department_id
And wro. organization_id = 103
And WDJ. organization_id = 103
And we. wip_entity_name =' Kevin13 ';

 

The current quantity must be associated with mtl_onhand_quantities or mtl_onhand_quantities_detail.

This table does not include inventory in transit.

To include similar inventory such as the amount in transit, it is best to use APIs for calculation.