Oracle Forms

Hi!

Need help! As you can see here in this program unit, an LOV auf in a specific mask is populated with POPULATE_GROUP_WITH_QUERY:

PROCEDURE populate_price_code_rg IS
--
v_tmp NUMBER;
--
v_query VARCHAR2(5000) :=
'select pc.price_code price_code
,pc.description description
,pl.list_price list_price
, ph.currency_code currency_code
from BDS_PRICELIST_LINE pl,
BDS_PRICELIST_HEAD ph,
bds_price_code pc
where pc.suborg_code = nvl('''||:b1.suborg_code||''', sd_app.get_env(''SUBORG_CODE''))
and pc.price_type = ''S''
and pc.active = ''Y''
and pc.company_code = nvl('''||:b1.company_code||''',pc.company_code)
and pc.company_code IN (SELECT company_code
FROM bu_company_valid_env_v)
and ph.suborg_code = pc.suborg_code
AND pl.suborg_code = ph.suborg_code
AND pl.pricelist_name = ph.pricelist_name
AND pl.selection_price_code = pc.price_code
AND ph.price_Type = ''S'' -- only Sales Pricelists
AND ph.active = ''Y''
AND pl.price_eff_qty <= 1
AND pl.price_eff_date <= sysdate
AND ph.company_code = pc.company_code
order by pc.price_code'
;
--
BEGIN
--
v_tmp := POPULATE_GROUP_WITH_QUERY ('B1_SELECTION_PRICE_CODE',v_query);
--
END;

My problem now is, that i can't sort the list with order by?! How could this be? Is there something special wth POPULATE_GROUP_WITH_QUERY, that no order by at the end of a query is taken or what?

thnx in advance!