APPS.AHL_UC_TREE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 380: mtl_system_items_kfv M

376: M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info,
377: 'N'
378: FROM csi_ii_relationships R,
379: csi_item_instances C,
380: mtl_system_items_kfv M
381: WHERE R.object_id = c_instance_id
382: AND R.subject_id = C.instance_id
383: AND C.inventory_item_id = M.inventory_item_id
384: AND C.inv_master_organization_id = M.organization_id

Line 611: FROM mtl_system_items_kfv M,

607: FUNCTION part_info(p_instance_id NUMBER) RETURN VARCHAR2 IS
608: l_part_info VARCHAR2(80);
609: CURSOR get_part_info(c_instance_id NUMBER) IS
610: SELECT M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info
611: FROM mtl_system_items_kfv M,
612: csi_item_instances C
613: WHERE C.instance_id = c_instance_id
614: AND C.inventory_item_id = M.inventory_item_id
615: AND C.inv_master_organization_id = M.organization_id;