How to incorporate logic of Custom Codes for Qualifiers and Modifiers in Price List

Hi,

We have few Custom codes for maintaining the price list . Now Business wants to implement Advance Priceing and wants to replace the custom codes with setups for Modifier, Qualifier and Price List.

Please let us know, how can we achieve the features through setups. Below is the sample code for selecting Items for which Price list needs to be updated.

      SELECT msi.inventory_item_id, msi.segment1, msi.description, msi.market_price

FROM mtl_system_items_b msi, mtl_descr_element_values mde

WHERE msi.organization_id = 81

--and msi.buyer_id = 92

AND Xxnm_Get_Vendor_Id(msi.inventory_item_id) = 436 -- MEriksen 22022012: Endret pga at lev. nå defineres med kilderegler.