Freight Carriers: Query to fetch Freight Carriers in Oracle Apps
Freight Carriers: Navigation: Shipping/OM Super User responsibilities -> Setup -> Shipping -> Freight Carrier, Cost Types -> Freight Carriers Query to Fetch Freight Carriers: select wc.carrier_name, WC.FREIGHT_CODE, wcs.service_level, wcs.mode_of_transport, ship_method_code, WOC.ORGANIZATION_CODE from apps.WSH_CARRIERS_V WC, apps.WSH_CARRIER_SERVICES WCS, apps.WSH_ORG_CARRIER_SERVICES_V woc where wc.carrier_id = wcs.carrier_id and wcs.carrier_service_id = woc.carrier_service_id and WC.ACTIVE ='A' and wc.carrier_name ='EUROPOST' order by wc.carrier_name,WOC.ORGANIZATION_CODE