APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SECONDARY_LOCATORS

Line 2123: FROM mtl_item_locations a, mtl_secondary_locators b

2119: RETURN 'Y';
2120: ELSE
2121: SELECT count(*)
2122: INTO l_temp
2123: FROM mtl_item_locations a, mtl_secondary_locators b
2124: WHERE b.organization_id = p_org_id
2125: AND b.inventory_item_id = p_inventory_item_id
2126: AND b.subinventory_code = p_sub_code
2127: AND a.inventory_location_id = b.secondary_locator

Line 4278: FROM mtl_secondary_locators b

4274: loc_valid := TRUE;
4275: ELSE
4276: SELECT count(*)
4277: INTO l_temp
4278: FROM mtl_secondary_locators b
4279: WHERE b.organization_id = p_org_id
4280: AND b.inventory_item_id = p_inventory_item_id
4281: AND b.subinventory_code = p_sub_code
4282: AND b.secondary_locator = p_loc_id;