Extract Item data in given Item Range

Hi Tech Gurus/Experts,

We have Multi Segments (Segment1 to Segment4) Item code for System item Key FlexField in R12.1.3.

Segment3 is dependent on Segment2.  Now we are passing ITEM_FROM & ITEM_TO as parameters in PL/SQL procedure and

wants to extract the item data in  Item Range.

For example,

If we passing ,

ITEM_FROM.segment1 = 'AA'

ITEM_FROM.segment2 = '015'

ITEM_TO.segment1 = 'AA'

ITEM_TO.segment2 = '020'

then extracts only those items lying in from and to range.

How can I get the same in PL/SQL stored procedure ?

regards

Sanjay