Converting one record into many

Hi all

I have a table with Receipt lines for Purchase orders with the following structure:

PO_ID NUMBER;
PO_LINE_ID NUMBER;
ITEM_ID NUMBER;
LOC_ID NUMBER;
QUANTITY NUMBER; In order to print labels for all the items received I need to convert every record in this table
in as many record indicates.

For instance:

PO_ID        PO_LINE_ID        ITEM_ID        LOC_ID        QUANTITY
12                156                        9098888        65

I need to have:

ITEM_ID        LOC_ID
9098888        65
9098888        65
9098888        65

Of course there is a possibility using a temporary table but I wander if some of you have a way to to that
without an intermediate table, just SQL code.

Thanks in advance for your help

Cecilio Received on Thu Apr 07 2005 - 17:33:44 CDT