Hi

There are multiple views are there

you can set the org context and access these standard view

check the below view which match for your requirement

POR_VIEW_REQ_RECEIPTS_V
POR_VIEW_REQS_V
PO_REQ_LINES_AUTOCREATE_V
PO_REQ_LINES_REF_V
PO_REQ_LINES_TRX_V

Thanks

Hi,

If I understood your requirement correctly, you can use the like function to get the results

select *
from po_requisition_lines_all
where item_description like '%&1%'

Where &1 is parameter value (Which is part of description)

Regards,

Sirisha

Hi -

Thanks for the confirmation, yes, you may have to use one like item_description like '%&part_description%'

regards.

Ananth