Hello Community,
I have a Question in regards to Creating Views/Materialized Views in APEX; I have a lot of Repeat Code to Display the Status of Refund. For the most part All the Code is the Same
Except for the referenced Page Items in Where Clauses
Also to Note: The Reason I'm Creating the Views is due to the Number of Characters Allowed in PL/SQL Function Bodies in APEX Error: "Value too long by 1006 characters!"
How would I Create the Views and Still Account for the Different Page Items ? (See Screen Shots Below)
Would Each View be Created Seperately and Independent of each other ;
Mainly to solve "Value too long by 1006 characters!"
Secondly to Condense Code.

VS.
