SELECT ACT_CALC_RATE||' '||decode(rate_type,'R','Rate/Metric Ton','P','Price of Bag','B','Basis Price','M','Rate/100 Meter') INTO B_PRICE FROM SALES.SALES_SALEADV_QUALITY WHERE QTY_CODE=:QTY_CODE AND SALE_ADV_NO=(:MILL_ORDER_NO2) AND COMP_CODE=:CCODE AND PRODUCT_CODE=(:PRODUCT_CODE);