55: IF p_inventory_item_id IS NOT NULL THEN
56: BEGIN
57: SELECT 'x'
58: INTO l_dummy
59: FROM mtl_system_items
60: WHERE inventory_item_id = p_inventory_item_id
61: AND organization_id = l_inv_valdn_org_id;
62: -- AND organization_id = cs_std.get_item_valdn_orgzn_id;
63: EXCEPTION
243: if p_usage_item_id is not null then
244: begin
245: select 'x'
246: into l_dummy
247: from mtl_system_items
248: where inventory_item_id = p_usage_item_id
249: and organization_id = l_inv_valdn_org_id
250: -- and organization_id = cs_std.get_item_valdn_orgzn_id
251: and usage_item_flag = 'Y';
1140: /* Check if the item is an EAM item */
1141: BEGIN
1142: SELECT distinct nvl(eam_item_type,0) eam_item_type
1143: INTO l_eam_item_type
1144: FROM mtl_system_items_b
1145: WHERE inventory_item_id = l_inventory_item_id;
1146: EXCEPTION
1147: WHEN NO_DATA_FOUND THEN
1148: l_eam_item_type := 0;