APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 238: from mtl_system_items

234:
235: -- Fix for bug# 3602041 - Removed check for bom_enabled flag in the where clause of the query
236: select 1
237: into g_dummy
238: from mtl_system_items
239: where inventory_item_id = p_eam_mat_req_rec.inventory_item_id
240: and organization_id = p_eam_mat_req_rec.organization_id
241: and ( bom_item_type = 4
242: and ( eam_item_type IS NULL or eam_item_type = 3 or eam_item_type = 1) );

Line 250: from mtl_system_items where

246:
247: -- Check that if item is stockable, then it is also purchased
248: -- and purchasable
249: select stock_enabled_flag into l_stockable_flag
250: from mtl_system_items where
251: inventory_item_id = p_eam_mat_req_rec.inventory_item_id
252: and organization_id = p_eam_mat_req_rec.organization_id;
253: if l_stockable_flag = 'N' then
254: select count(*) into l_count from mtl_system_items

Line 254: select count(*) into l_count from mtl_system_items

250: from mtl_system_items where
251: inventory_item_id = p_eam_mat_req_rec.inventory_item_id
252: and organization_id = p_eam_mat_req_rec.organization_id;
253: if l_stockable_flag = 'N' then
254: select count(*) into l_count from mtl_system_items
255: where inventory_item_id = p_eam_mat_req_rec.inventory_item_id
256: and organization_id = p_eam_mat_req_rec.organization_id
257: and purchasing_enabled_flag = 'Y'
258: and purchasing_item_flag = 'Y';

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: )