I want to retrieve information tied to catalog items.

[M_Tomy]

Dear Experts.

I am having trouble with an inventory operation, please let me know.

I would like to get a list of the assignee groups associated with a flow of catalog items.
It doesn't matter how you do it, as long as you can see the catalog item, the catalog item owner name, the flow name, and the assignee group in the list.

Thank you in advance.

[Ankur Bawiskar]

@M_Tomy 

you want to see/extract a report on something like this

Catalog Item 1, Flow Name, Owner Name, Assignment Group

[M_Tomy]

@Ankur Bawiskar 

Thank you for your prompt reply.

The report you suggested is fine.
But I don't know which table to use to get the data to create the report.
Which table should I link to which table to create the report?

Thanks in advance.

[Ankur Bawiskar]

@M_Tomy 

most of the info can be found from sc_req_item but if you want other info then possibly you need to join tables using database views