gemma-l
6/26/2017 - 11:31 AM

pallet lookup

pallet lookup

select vi.ceid, vi.date6 as useby, vi.ItemID, plu.PLUCode
from vw_ce_ims_items vi
join vw_df_plu_file plu on vi.PLUID=plu.PLUID
where vi.ItemID in (
	select childitemid
	from ims_associations
	where ParentItemID=826901292000055403
	)
	AND PLUCode='122418'
order by PLUCode