APPS.INV_ITEM_CATALOG_ELE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 60: FROM mtl_system_items_b

56: CURSOR org_item_exists_csr
57: ( p_inventory_item_id NUMBER
58: ) IS
59: SELECT organization_id
60: FROM mtl_system_items_b
61: WHERE inventory_item_id = p_inventory_item_id;
62:
63:
64: CURSOR catalog_group_element_csr (p_element_name VARCHAR2,p_inventory_item_id NUMBER)

Line 74: FROM mtl_system_items_b

70:
71: CURSOR catalog_group_csr (p_inventory_item_id NUMBER)
72: IS
73: SELECT item_Catalog_group_id
74: FROM mtl_system_items_b
75: WHERE inventory_item_id = p_inventory_item_id
76: AND item_Catalog_group_id IS NOT NULL;
77:
78:

Line 262: From mtl_system_items_b_kfv

258: --Bug: 5522789 Tokenise the message to display item number.
259: IF p_item_number IS NULL THEN
260: Select concatenated_segments
261: into l_item_number
262: From mtl_system_items_b_kfv
263: where INVENTORY_ITEM_ID = l_inventory_item_id
264: AND organization_id = l_org_id;
265: ELSE
266: l_item_number := p_item_number;