VIEW: APPS.OKS_ENT_PARTY_CONT_V

Source

View Text - Preformatted

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_ALL_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'

View Text - HTML Formatted

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_ALL_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'