Need Help or Suggestion in the Assignment
HI,
I need you to create a procedure that will accept LPN# and
a Two Letter Code. I want to you translate all the lots / items in the LPN to
new Lots, with a Postfix.
e.g.
Suppose you have an LPN 123
LPN has two items.
Item A .. Lot 00010 Qty 100
Item A.. Lot 00020 Qty 50
Item B.. Lot 00043 Qty 50
NOW If I call your procedure with parameters of LPN and Postfix.
E.g. If I call your procedure with (LPN 123, 'XY')
YOu need to cycle through all the quantity in the LPN and do a Lot translate for each.
So the end result should be the same LPN, with
e.g.
Suppose you have an LPN 123
LPN has two items.
Item A .. Lot 00010 Qty 100
Item A.. Lot 00020 Qty 50
Item B.. Lot 00043 Qty 50
NOW If I call your procedure with parameters of LPN and Postfix.
E.g. If I call your procedure with (LPN 123, 'XY')
YOu need to cycle through all the quantity in the LPN and do a Lot translate for each.
So the end result should be the same LPN, with
0