Below queries are for Oracle Applications Order Management and Advance Pricing Modules.
SELECT l.list_line_id,q.qualifier_grouping_no,
q.qualifier_id, q.qualifier_context, q.qualifier_attr_value,
q.comparison_operator_code,q.qualifier_precedence,q.qual_attr_value_from_number,
q.qualifier_attribute,q.end_date_active,l.end_date_active,h.end_date_active
FROM
qp_list_headers_all h,
qp_list_lines l,
qp_qualifiers q
where h.list_header_id = l.list_header_id
and h.list_header_id = q.list_header_id
and h.list_header_id = &list_id -- Price List Header ID or Modifier header ID
and NVL(h.end_date_active,sysdate) >= sysdate
and NVL(l.end_date_active,sysdate) >= sysdate
and NVL(q.end_date_active,sysdate) >= sysdate;
q.qualifier_id, q.qualifier_context, q.qualifier_attr_value,
q.comparison_operator_code,q.qualifier_precedence,q.qual_attr_value_from_number,
q.qualifier_attribute,q.end_date_active,l.end_date_active,h.end_date_active
FROM
qp_list_headers_all h,
qp_list_lines l,
qp_qualifiers q
where h.list_header_id = l.list_header_id
and h.list_header_id = q.list_header_id
and h.list_header_id = &list_id -- Price List Header ID or Modifier header ID
and NVL(h.end_date_active,sysdate) >= sysdate
and NVL(l.end_date_active,sysdate) >= sysdate
and NVL(q.end_date_active,sysdate) >= sysdate;
select q.qualifier_id,q.qualifier_context,q.qualifier_attribute,qualifier_attr_value ,
ct.prc_context_id, qs.segment_code
from qp_qualifiers q , qp_prc_contexts_b ct , qp_segments_b qs
where q.list_header_id = &ListHeaderID --PriceList Header ID
and ct.prc_context_type ='QUALIFIER'
and q.qualifier_context = ct.prc_context_code
and qs.prc_context_id = ct.prc_context_id
and qs.segment_mapping_column = q.qualifier_attribute
ct.prc_context_id, qs.segment_code
from qp_qualifiers q , qp_prc_contexts_b ct , qp_segments_b qs
where q.list_header_id = &ListHeaderID --PriceList Header ID
and ct.prc_context_type ='QUALIFIER'
and q.qualifier_context = ct.prc_context_code
and qs.prc_context_id = ct.prc_context_id
and qs.segment_mapping_column = q.qualifier_attribute
No comments:
Post a Comment