I hope you are doing great.
I am working in an oracle forms builder's form, QPXPRMLS.fmb to be more specific. There are several queries (views) involved in this form. There is a canvas called QUALIFIER_FIXED, which shows several columns. I intend to leverage these queries for creating a report of the price modifiers existing in the database, but whe it comes to showing the QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE, VALUE_FROM as well as the VALUE_FROM_MEANING, I have no clue where those values come from, as they are related to some LOV. I hope you can provide me with an easy query to extract these values from the tables they are stored.
I have resolved the part for the HEADERS, the MODIFIER LINES, the PRICE_BREAK attributes and so far, I have this query for the QUALIFIERS:
SELECT qualifier_grouping_no "Grouping Number", qualifier_context "Qualifier Context"
from qp_qualifiers_v where list_header_id = 8225 order by qualifier_grouping_no ; (8225 is just hardcoded for testing purposes)
For example, the query is returning the qualifier context as shown in the embedded image, but I need it to be Modifier List instead of MODLIST. I assume this is extracted from somewhere in the database, and wouldn't want to have to hardcode it.
Please ask for any clarification as required.
I also know how to obtain the value_from and the value_from_meaning but it is returning me values like QUALIFIERATTRIBUTE4, QUALIFIERATTRIBUTE2. I hope you can provide me a query to translate these values into more readable data.
Thank you very much in advance for your attention and interest.