Skip to main content
Question

Multiple PART_HANDLING_UNIT per Part Creates Multiple Order Lines


Forum|alt.badge.img+2

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.

 

 

 

 

 

 

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings