1977: FROM wsh_carriers c
1978: WHERE c.carrier_id = l_party_id
1979: UNION ALL
1980: SELECT 4 1981: FROM hz_relationships r, po_vendors v 1982: WHERE r.relationship_type = 'POS_VENDOR_PARTY' AND
1983: r.subject_id = v.vendor_id AND
1984: r.object_id = l_party_id;
1985: