Oracle Forms

hello der....

plz help me in resolving a code..

my table name is item_info, it has column: item_type,item_no,doc_no,matching_grp,ship_to_loc, qty. For every item_type (S) there will b a row in the table with item type(R). Now i hv to match each row in that table and find out the matched rows, on the basis of matching grp , qty, doc_no n other columns. Its sort of a shipment n receipt type of matching.

plz help,, m stuck in this code...

any help will b appreciated....