APPS.CSP_REQUIREMENT_LINES_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 46: FROM mtl_system_items_b

42: l_inventory_item_id Number;
43: -- Hint: Declare cursor and local variables
44: CURSOR C_Get_Item_Id IS
45: SELECT inventory_item_id
46: FROM mtl_system_items_b
47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')

Line 190: FROM mtl_system_items_b

186: AND l_pvt_RQL_Tbl(I).inventory_item_id <> FND_API.G_MISS_NUM) THEN
187: BEGIN
188: SELECT count(inventory_item_id)
189: INTO l_count
190: FROM mtl_system_items_b
191: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id;
192: IF (l_count <= 0) THEN
193: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');
194: FND_MSG_PUB.ADD;