B2B Trading Partner Lookup sql query
 How B2B looks for the Trading Partner Agreement in the MDS database  SELECT *   FROM DEV_SOAINFRA.B2B_LIFECYCLE    WHERE ((SENDER_NAME        = <Sender Name e.g. MyCompany>)    AND ((RECEIVER_NAME        = <Recipient Name e.g. ACME>)    AND ((DOCTYPE_NAME         = <Document Name e.g. CUSDEC>)    AND ((DOC_PROTOCOL_VERSION = <Document version e.g. D96B>)    AND ((DIRECTION            = <Can be INBOUND or OUTBOUND>)    AND (STATE                 = 'Active'))))));