573: end;
574:
575: SELECT stock_enabled_flag,primary_uom_code
576: INTO l_stockable_flag,l_uom
577: FROM MTL_SYSTEM_ITEMS_KFV
578: WHERE inventory_item_id = p_eam_mat_req_rec.inventory_item_id
579: AND organization_id = p_eam_mat_req_rec.organization_id;
580:
581: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN
722: sum(Decode(upper(NVL(rqh.authorization_status, 'APPROVED')), 'CANCELLED', 0, 'REJECTED', 0, 'SYSTEM_SAVED',0,rql.quantity)) quantity
723: FROM (
724: SELECT
725: wro.wip_entity_id, wro.operation_seq_num, wro.organization_id, wro.inventory_item_id
726: FROM wip_requirement_operations wro, mtl_system_items_kfv msi
727: WHERE msi.inventory_item_id = wro.inventory_item_id
728: AND msi.organization_id = wro.organization_id
729: AND nvl(msi.stock_enabled_flag, 'N') = 'N'
730: )