| Operation Details |  |
| Description: | Searches for overlapping allocation target items. |
| Sterotype: | ns |
| SQL | |
SELECT
COUNT(*)
INTO
:numberOfRecords
FROM
AllocationTargetItem
WHERE
(
allocationTargetItemID <> :allocationTargetItemID
OR :allocationTargetItemIDIsNull <> '0'
)
AND
(
upper(relatedName) LIKE :relatedName
)
|