✨ Description of Change

Link to GitHub issue or Jira ticket:
https://pihemr.atlassian.net/browse/OBPIH-6610

Description:
See tickets description (File to review: order-summary-helper-views.sql, rest is the calculate inverse items that's in separate PR)

📈 Test Plan

We require that all code changes come paired with a method of testing them. Please select which of the following testing approaches you've included with this change:

• Frontend automation tests (unit)
• Backend automation tests (unit, API, smoke)
• End-to-end tests (Playwright)
• Manual tests (please describe below)
• Not Applicable

Description of test plan (if applicable):
Order summary (derived status) calculation for payment statuses (invoices) needs to be checked.

✅ Quality Checks

Please confirm and check each of the following to ensure that your change conforms to the coding standards of the project:

• The pull request title is prefixed with the issue/ticket number (Ex: [OBS-123] for Jira, [#0000] for GitHub, or [OBS-123, OBPIH-123] if there are multiple), or with [N/A] if not applicable
• The pull request description has enough information for someone without context to be able to understand the change and why it is needed
• The change has tests that prove the issue is fixed / the feature works as intended