Min-Max Report: Package (INV_INVISMMX_XMLP_PKG) code required to build a custom version

Summary:

The information in the report output currently generated by the seeded Min-Max report is not sufficient for the user. Hence the following columns are required to be added to the output.

Item Description (Separate Column)

Legacy Number (Item Relationships)

Item Category (Purchasing Catalog)

Suggested Supplier & Item (Item Relationships, Comma separated incase of multiple values)

Unit List Price (item)

Reorder Estimate (List Price * Reord Qty)

However when we customize the report and add custom logic to the Data Model, the custom report is timing out when it is submitted for an entire inventory org (6k+ items).

So we are planning to create a separate custom report to generate the output with the required information and use the seeded program to perform the standard actions. But to build the custom report, we will require the code for the package INV_INVISMMX_XMLP_PKG so we can leverage the logic in a query for a custom report.