How can I fetch only supplier sites that belong to the supplier on a contract?

Add the Contract Party Contact DFF to the contract header. The header DFF has the contract_id parameter and it can be passed into the where clause condition and by using a where clause condition.

Here are the values to pass to the table value set of the supplier site DFF field:

• FROM: okc_k_headers_all_b a, okc_k_party_roles_b b, POZ_SUPPLIER_SITES_ALL_M c, POZ_SUPPLIERS d
• VALUE COLUMN NAME: VENDOR_SITE_CODE
• WHERE CLAUSE:
  • a.id = b.chr_id
  • and a.major_version = b.major_Version
  • and b.RLE_CODE = 'SUPPLIER'
  • and c.VENDOR_ID = d.vendor_id
  • and c.PRC_BU_ID = a.org_id
  • and d.party_id = b.OBJECT1_ID1
  • and a.contract_id = :{PARAMETER.ContractId}