2955: select pht.line_number, pht.freight_carrier_code
2956: from pos_exasn_headers pht
2957: where pht.freight_carrier_code is not null
2958: and 0= 2959: (select count(*) from org_freight oft 2960: where nvl(oft.disable_date, sysdate) >= sysdate
2961: and oft.freight_code = pht.freight_carrier_code
2962: and organization_id = pht.ship_to_org_id
2963: );