Hi all,
is there a way to make sure that there can be one and only one PART_HANDLING UNIT per Part?
Occasionally and accidentally two PART_HANDLING_UNITs are associated with a Part which ‘fans' the data we have in our Crystal Reports for either Sales Order or Purchase Orders reports.
-- SQL to fund duplicate PHUs:
SELECT PC.PART_NO PC_PART_NO, COUNT(*) Recs
FROM IFSAPP.PART_CATALOG PC, IFSAPP.PART_HANDLING_UNIT PHU
WHERE PC.PART_NO = PHU.PART_NO (+)
GROUP BY PC.PART_NO
HAVING COUNT(*) > 1
ORDER BY 1
Is there a way to enforce that one and only one PHU can be created per Part?
Thanks,
Craig.