Ship Methods in Oracle order

Select * from fnd_lookup_values_vl
 where LOOKUP_TYPE = 'SHIP_METHOD'


Shipping Method LOV IN Order--> Other Form

select fl.meaning meaning
       from   wsh_carrier_services wsh,
       wsh_org_carrier_services wsh_org ,
       fnd_lookup_values_vl fl ,
       HZ_PARTIES HP
where  wsh_org.organization_id=1219--:parameter.lov_num_param1
  and  wsh_org.carrier_service_id = wsh.carrier_service_id
  and    fl.LOOKUP_TYPE = 'SHIP_METHOD'
  and    fl.LOOKUP_CODE =  wsh.SHIP_METHOD_CODE
  and    fl.VIEW_APPLICATION_ID = 3
  and    wsh.carrier_id = HP.party_id
  and    HP.STATUS= 'A'
  and    sysdate between fl.start_date_active
  and    nvl(fl.end_date_active,sysdate)
  and    fl.enabled_flag='Y'
  and    WSH_ORG.ENABLED_FLAG = 'Y'
order by meaning