Thursday 13 June 2013

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
         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           
         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