APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 201: FROM mtl_system_items_b_kfv

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

Line 937: From mtl_system_items_b_kfv

933: --Bug: 5522789 Tokenise the message to display item number.
934: l_token := 'VALUE';
935: IF icoi_rec.item_number IS NULL THEN
936: Select concatenated_segments into l_item_number
937: From mtl_system_items_b_kfv
938: where INVENTORY_ITEM_ID = l_inventory_item_id
939: AND organization_id = l_organization_id; -- org
940: ELSE
941: l_item_number := icoi_rec.item_number;