APPS.INV_ITEM_CATALOG_ELE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 59: FROM mtl_system_items_b

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

Line 73: FROM mtl_system_items_b

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

Line 233: From mtl_system_items_b_kfv

229: --Bug: 5522789 Tokenise the message to display item number.
230: IF p_item_number IS NULL THEN
231: Select concatenated_segments
232: into l_item_number
233: From mtl_system_items_b_kfv
234: where INVENTORY_ITEM_ID = l_inventory_item_id
235: AND organization_id = l_org_id;
236: ELSE
237: l_item_number := p_item_number;