APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 508: mtl_system_items_b msib

504:
505: IF l_maintenance_object_type = 2 THEN
506: SELECT count(*) into l_count
507: FROM wip_discrete_jobs wdj,
508: mtl_system_items_b msib
509: WHERE wdj.organization_id = msib.organization_id
510: AND wdj.maintenance_object_id = msib.inventory_item_id
511: AND wdj.organization_id = p_eam_wo_comp_rec.organization_id
512: AND wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id ;

Line 558: FROM mtl_system_items_b

554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check subinventory'); END IF;
555:
556: IF l_completion_info = 1 THEN
557: SELECT lot_control_code into l_lot_ctrl_code
558: FROM mtl_system_items_b
559: WHERE inventory_item_id = l_inventory_item_id
560: AND organization_id = l_org_id ;
561:
562: IF p_eam_wo_comp_rec.completion_subinventory IS NOT NULL THEN