1 person found this helpful
I guess you must look in PO_REQUISITION_LINES_ALL table, since a requisition can probably have both catalog-items and non-catalog-item lines. That said, perhaps explore the following columns from PO_REQUISITION_LINES_ALL table:
- NONCAT_TEMPLATE_ID - this refers to Non-Catalog Request template identifier
Thanks very much to both of you for your helpful replies, I wish I could have marked both of them as correct!
po_requisition_lines_all.catalog_type does the job perfectly - I don't know how I missed it.