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