APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 204: FROM mtl_system_items_b_kfv

200: CURSOR msi_item_number_csr (cp_item_number IN VARCHAR2,
201: cp_organization_id IN NUMBER)
202: IS
203: SELECT inventory_item_id
204: FROM mtl_system_items_b_kfv
205: WHERE concatenated_segments = cp_item_number
206: AND organization_id = cp_organization_id;
207:
208: CURSOR msii_item_number_csr (cp_item_number IN VARCHAR2,

Line 990: From mtl_system_items_b_kfv

986: --Bug: 5522789 Tokenise the message to display item number.
987: l_token := 'VALUE';
988: IF icoi_rec.item_number IS NULL AND l_inventory_item_id <> null THEN /*Added for bug 10034833*/
989: Select concatenated_segments into l_item_number
990: From mtl_system_items_b_kfv
991: where INVENTORY_ITEM_ID = l_inventory_item_id
992: AND organization_id = l_organization_id; -- org
993: ELSE
994: l_item_number := icoi_rec.item_number;