differentiate item units (merged) [message #294363] |
Thu, 17 January 2008 05:57 |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
Hi All,
I have the following issue.
I have an Item with no 123445.
This item has a commodity pack size of 1 unit and a commodity pack size of 10 units but the user cannot see which is which.
so the user cannot distinguish between the single commodity pack size and a multipack commodity pack size.
I need to write a query for this.
can you please give me idea to distinguish these items.
Thank you,
|
|
|
|
|
Re: distingishing items [message #294391 is a reply to message #294363] |
Thu, 17 January 2008 07:45 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
There is not one useful piece of information in this post. If you didn't mentioned the word "query" I wouldn't even know this has anything to do with a database.
|
|
|
differentiate item units [message #295104 is a reply to message #294363] |
Mon, 21 January 2008 06:15 |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
Hi All,
I have the table like as follows.
Item Unit material
12345 1 systems
12345 6 systems
2342 1 book
3245 1 cells
3245 8 cells
3289 1 shirt
3200 1 pants
3200 9 pants
from the above table for Eg. Item No 12345.
This item has a commodity pack size of 1 unit and a commodity pack size of 6 units but the user cannot see which is which.
so the user cannot distinguish between the single commodity pack size and a multipack commodity pack size.
Now the requirement is :::::
So need to update it as
if it has one unit then : systems_1
If it has multiple units Then : systems_6 [for item 12345]
Like this I need to update all the items.
Please write a query for this..
Please let me know if u need more Info...
Thank you.
|
|
|
|
|
|
|
|
Re: differentiate item units [message #295115 is a reply to message #295111] |
Mon, 21 January 2008 06:35 |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
hi,
if i concatenate like there will be another column right?
But i need to update in Material column itself.
How it is?
so i need o/p as
Item Unit material
12345 1 systems_1
12345 6 systems_6
2342 1 book_1
3245 1 cells_1
3245 8 cells_8
3289 1 shirt_1
3200 1 pants_1
3200 9 pants_9
Thank u
[Updated on: Mon, 21 January 2008 06:36] Report message to a moderator
|
|
|
|
Re: differentiate item units [message #295121 is a reply to message #295117] |
Mon, 21 January 2008 06:39 |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
I have already tried it .. But I am not getting in that Material column. i am getting new_column named it as " Orig_material".
But this is not my req...
So I am requesting to write a query for this...
Thank u.
|
|
|
|
|
|
Re: differentiate item units (merged) [message #295144 is a reply to message #294363] |
Mon, 21 January 2008 08:12 |
ramanajv1968
Messages: 168 Registered: December 2005 Location: HYDERABAD
|
Senior Member |
|
|
Here is the demostration
SQL> desc item_desc;
Name Null? Type
----------------------------------------- -------- -----------------------
ITEM NUMBER
UNIT NUMBER
MATERIAL VARCHAR2(20)
before updating the values
SQL> select * from item_desc;
ITEM UNIT MATERIAL
---------- ---------- --------------------
12345 1 systems
12345 6 systems
2342 1 book
3245 1 cells
2345 8 cells
3289 1 shirt
3200 1 pants
3200 1 pants
8 rows selected.
SQL> update item_desc set material = material||'_'||unit;
8 rows updated.
SQL> select * from item_desc;
ITEM UNIT MATERIAL
---------- ---------- --------------------
12345 1 systems_1
12345 6 systems_6
2342 1 book_1
3245 1 cells_1
2345 8 cells_8
3289 1 shirt_1
3200 1 pants_1
3200 1 pants_1
8 rows selected.
|
|
|
|
Re: differentiate item units (merged) [message #295150 is a reply to message #294363] |
Mon, 21 January 2008 08:26 |
ramanajv1968
Messages: 168 Registered: December 2005 Location: HYDERABAD
|
Senior Member |
|
|
@michel
sorry i didnot get you.
but my intension is to close this thread by giving the solution.
As i said early i am looking to help some one with the information i know and would like to leran from my mistakes.
so,looking for the opertunity to help help and help to enhance my self.
[Updated on: Mon, 21 January 2008 09:33] by Moderator Report message to a moderator
|
|
|
|
|