APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 77: SELECT segment1 INTO l_inventory_item_name FROM mtl_system_items WHERE inventory_item_id=p_eam_mat_req_rec.inventory_item_id AND organization_id=p_eam_mat_req_rec.organization_id;

73: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
74: p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
75: THEN
76: --Start bug# 11672256
77: SELECT segment1 INTO l_inventory_item_name FROM mtl_system_items WHERE inventory_item_id=p_eam_mat_req_rec.inventory_item_id AND organization_id=p_eam_mat_req_rec.organization_id;
78: l_token_tbl(1).token_name := 'INVENTORY_ITEM_NAME';
79: l_token_tbl(1).token_value := l_inventory_item_name;
80: --End bug# 11672256
81:

Line 242: from mtl_system_items

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

Line 254: from mtl_system_items where

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

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

254: from mtl_system_items where
255: inventory_item_id = p_eam_mat_req_rec.inventory_item_id
256: and organization_id = p_eam_mat_req_rec.organization_id;
257: if l_stockable_flag = 'N' then
258: select count(*) into l_count from mtl_system_items
259: where inventory_item_id = p_eam_mat_req_rec.inventory_item_id
260: and organization_id = p_eam_mat_req_rec.organization_id
261: and purchasing_enabled_flag = 'Y'
262: and purchasing_item_flag = 'Y';

Line 577: FROM MTL_SYSTEM_ITEMS_KFV

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

Line 726: FROM wip_requirement_operations wro, mtl_system_items_kfv msi

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