APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 573: FROM MTL_SYSTEM_ITEMS_KFV

569: end;
570:
571: SELECT stock_enabled_flag,primary_uom_code
572: INTO l_stockable_flag,l_uom
573: FROM MTL_SYSTEM_ITEMS_KFV
574: WHERE inventory_item_id = p_eam_mat_req_rec.inventory_item_id
575: AND organization_id = p_eam_mat_req_rec.organization_id;
576:
577: IF(p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_DELETE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) THEN

Line 721: FROM wip_requirement_operations wro, mtl_system_items_kfv msi

717: sum(rql.quantity) quantity
718: FROM (
719: SELECT
720: wro.wip_entity_id, wro.operation_seq_num, wro.organization_id, wro.inventory_item_id
721: FROM wip_requirement_operations wro, mtl_system_items_kfv msi
722: WHERE msi.inventory_item_id = wro.inventory_item_id
723: AND msi.organization_id = wro.organization_id
724: AND nvl(msi.stock_enabled_flag, 'N') = 'N'
725: )