JD Edwards EnterpriseOne
Wednesday, March 14, 2012
Items Missing Primary Location in F41021
/* Formatted on 2012/03/14 06:31 (Formatter Plus v4.8.8) */
SELECT ib.ibmcu, COUNT (*)
FROM testdta.f4102 ib
WHERE NOT EXISTS (
SELECT *
FROM testdta.f41021 li
WHERE ib.ibitm = li.liitm AND ib.ibmcu = li.limcu
AND li.lipbin = 'P')
group by ib.ibmcu
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment