View: OKS_ENT_PARTY_CONT_V

Product:	OKS - Service Contracts
Description:	Lists all Party Contacts
Implementation/DBA Data:	APPS.OKS_ENT_PARTY_CONT_V

View Text

SELECT HDR.ID CONTRACT_ID
, CON.ID CONTACT_ID
, PRL.ID CONTACT_ROLE_ID
, TO_NUMBER(PRL.OBJECT1_ID1) PARTY_CONTACT_ID
, CON.CRO_CODE CONTACT_ROLE_CODE
, CRL.MEANING CONTACT_ROLE_NAME
FROM OKC_K_HEADERS_B HDR
, OKC_K_PARTY_ROLES_B PRL
, OKC_CONTACTS CON
, FND_LOOKUPS CRL
WHERE HDR.ID = PRL.DNZ_CHR_ID
AND PRL.ID = CON.CPL_ID
AND CRL.LOOKUP_CODE = CON.CRO_CODE
AND CRL.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'

Columns