mhas01
asked on
How to obtain value_from and value_from_meaning from oracle canned applications' query
Hey experts.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Other consideration, this form is part of the E-business suite of ORACLE, and also part of the ADVANCED PRICING module, so it you are familiar with this module, it might be easier. Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
On the other side, actually I know that QP_QUALIFIERS_V is a VIEW, but the base tables don't expose this value either. I think it is based in a relationship stated in the form somehow, and that is actually why I am asking this question.
Searching in the form I was not able to successfully find this value, and that is other reason why I asked in this forum. Don't get me wrong please, I really appreciate your question but it has not leaded me to the resolution. Thank you anyway. Please don't hesitate to reply back if my comments make any sense or not, to clarify. I really appreciate it.