1. Tables and Views for Sales and Fusion Service
  2. OKC_SUPPLIER_SEC_PREDICATE_V

OKC_SUPPLIER_SEC_PREDICATE_V

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

CONTRACT_ID

Query

SQL_Statement

SELECT

a.contract_id

FROM

okc_k_headers_all_b a,

poz_supp_access_sites_v b

WHERE

a.supplier_site_id = b.party_site_id

AND EXISTS (

SELECT

1

FROM

poz_contact_attributes

WHERE

access_level = 'SUPPLIER_SITE'

AND per_party_id = hrc_session_util.get_user_partyid

)

UNION ALL

SELECT

a.contract_id

FROM

okc_k_headers_all_b a,

okc_k_party_roles_b b,

poz_supp_access_suppliers_v c

WHERE

a.id = b.dnz_chr_id

AND a.major_version = b.major_version

AND b.version_type in ('C','A')

AND b.primary_yn = 'Y'

AND b.object1_id1 = c.party_id

AND EXISTS (

SELECT

1

FROM

poz_contact_attributes

WHERE

access_level = 'SUPPLIER'

AND per_party_id = hrc_session_util.get_user_partyid

)