Need the joining table for Manage contract types columns buyer role and seller role — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need the joining table for Manage contract types columns buyer role and seller role

edited Aug 2, 2025 12:01PM in Enterprise Contracts 1 comment

Summary:

I need the joining for

OKC_CONTRACT_TYPE_PARTIES for buyer role and seller role as I am getting whole data for the roles but I need to get only buyer and seller role based on contract type please refer below screenshot for your reference


Content (please ensure you mask any confidential information):

select OPAB.NAME,
CASE
WHEN okch.INTENT = 'B' THEN FLV.MEANING
END AS "Buyer",
CASE
WHEN okch.INTENT = 'S' THEN FLV.MEANING
END AS "Seller"
from okc_contract_types_b okch
LEFT JOIN OKC_CONTRACT_TYPES_VL OPAB ON OPAB.CONTRACT_TYPE_ID=okch.CONTRACT_TYPE_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!