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'))))));