Shipping carrier details - wsh_carriers_v

   SELECT wc.ROWID, hp.party_id, wc.scac_code, wc.freight_code,
          wc.manifesting_enabled_flag, wc.currency_code, hp.party_name,
          DECODE (hpu.party_id, NULL, 'I', 'A'), hpu.party_usg_assignment_id,
          wc.attribute_category, wc.attribute1, wc.attribute2, wc.attribute3,
          wc.attribute4, wc.attribute5, wc.attribute6, wc.attribute7,