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