Search 800 + Posts

Jan 12, 2011

Query to get Qualifier associated with Customer Account

Below is simple  Query to get Qualifier associated with Customer Account
 
SELECT 
      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
       from  qp_qualifiers q
     where qualifier_context = 'CUSTOMER'
       and  q.qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
       and q.comparison_operator_code = '='
       and q.qualifier_attr_value = '&Enter_Customer_account_ID'

No comments:

Post a Comment