View: OKI_K_CONTACTS_V

Product:	OKI - Contracts Intelligence
Description:	Information about contract contacts.
Implementation/DBA Data:	APPS.OKI_K_CONTACTS_V

View Text

SELECT CTT.ID PARTY_CONTACT_ID
, CTT.DNZ_CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CTT.CPL_ID PARTY_ROLE_ID
, CTT.CRO_CODE CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(CTT.OBJECT1_ID1) CONTACT_ID
, OKX.NAME CONTACT_NAME
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.ATTRIBUTE_CATEGORY
, CTT.ATTRIBUTE1
, CTT.ATTRIBUTE2
, CTT.ATTRIBUTE3
, CTT.ATTRIBUTE4
, CTT.ATTRIBUTE5
, CTT.ATTRIBUTE6
, CTT.ATTRIBUTE7
, CTT.ATTRIBUTE8
, CTT.ATTRIBUTE9
, CTT.ATTRIBUTE10
, CTT.ATTRIBUTE11
, CTT.ATTRIBUTE12
, CTT.ATTRIBUTE13
, CTT.ATTRIBUTE14
, CTT.ATTRIBUTE15
FROM OKI_SALES_K_HDRS SHD
, OKC_CONTACTS CTT
, FND_LOOKUPS CRO
, OKX_RESOURCES_V OKX
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = CTT.CRO_CODE
AND OKX.ID1 = CTT.OBJECT1_ID1
AND CTT.JTOT_OBJECT1_CODE = 'OKX_RESOURCE'
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U') UNION SELECT CTT.ID PARTY_CONTACT_ID
, CTT.DNZ_CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CTT.CPL_ID PARTY_ROLE_ID
, CTT.CRO_CODE CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(CTT.OBJECT1_ID1) CONTACT_ID
, OKX.NAME CONTACT_NAME
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.ATTRIBUTE_CATEGORY
, CTT.ATTRIBUTE1
, CTT.ATTRIBUTE2
, CTT.ATTRIBUTE3
, CTT.ATTRIBUTE4
, CTT.ATTRIBUTE5
, CTT.ATTRIBUTE6
, CTT.ATTRIBUTE7
, CTT.ATTRIBUTE8
, CTT.ATTRIBUTE9
, CTT.ATTRIBUTE10
, CTT.ATTRIBUTE11
, CTT.ATTRIBUTE12
, CTT.ATTRIBUTE13
, CTT.ATTRIBUTE14
, CTT.ATTRIBUTE15
FROM OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS CRO
, OKX_PARTY_CONTACTS_V OKX
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = CTT.CRO_CODE
AND OKX.ID1 = CTT.OBJECT1_ID1
AND CTT.JTOT_OBJECT1_CODE = 'OKX_PCONTACT'
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U') UNION SELECT CTT.ID PARTY_CONTACT_ID
, CTT.DNZ_CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CTT.CPL_ID PARTY_ROLE_ID
, CTT.CRO_CODE CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(CTT.OBJECT1_ID1) CONTACT_ID
, OKX.NAME CONTACT_NAME
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.ATTRIBUTE_CATEGORY
, CTT.ATTRIBUTE1
, CTT.ATTRIBUTE2
, CTT.ATTRIBUTE3
, CTT.ATTRIBUTE4
, CTT.ATTRIBUTE5
, CTT.ATTRIBUTE6
, CTT.ATTRIBUTE7
, CTT.ATTRIBUTE8
, CTT.ATTRIBUTE9
, CTT.ATTRIBUTE10
, CTT.ATTRIBUTE11
, CTT.ATTRIBUTE12
, CTT.ATTRIBUTE13
, CTT.ATTRIBUTE14
, CTT.ATTRIBUTE15
FROM OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS CRO
, OKX_CUST_ROLE_RESP_V OKX
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = CTT.CRO_CODE
AND OKX.ID1 = CTT.OBJECT1_ID1
AND CTT.JTOT_OBJECT1_CODE IN ('OKX_CONTADMIN'
, 'OKX_CONTBILL'
, 'OKX_CONTSHIP'
, 'OKX_CONTTECH')
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U') UNION SELECT CTT.ID PARTY_CONTACT_ID
, CTT.DNZ_CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CTT.CPL_ID PARTY_ROLE_ID
, CTT.CRO_CODE CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(CTT.OBJECT1_ID1) CONTACT_ID
, OKX.NAME CONTACT_NAME
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.ATTRIBUTE_CATEGORY
, CTT.ATTRIBUTE1
, CTT.ATTRIBUTE2
, CTT.ATTRIBUTE3
, CTT.ATTRIBUTE4
, CTT.ATTRIBUTE5
, CTT.ATTRIBUTE6
, CTT.ATTRIBUTE7
, CTT.ATTRIBUTE8
, CTT.ATTRIBUTE9
, CTT.ATTRIBUTE10
, CTT.ATTRIBUTE11
, CTT.ATTRIBUTE12
, CTT.ATTRIBUTE13
, CTT.ATTRIBUTE14
, CTT.ATTRIBUTE15
FROM OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS CRO
, OKX_BUYERS_V OKX
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = CTT.CRO_CODE
AND OKX.ID1 = CTT.OBJECT1_ID1
AND CTT.JTOT_OBJECT1_CODE = 'OKX_BUYER'
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U') UNION SELECT CTT.ID PARTY_CONTACT_ID
, CTT.DNZ_CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CTT.CPL_ID PARTY_ROLE_ID
, CTT.CRO_CODE CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(CTT.OBJECT1_ID1) CONTACT_ID
, OKX.NAME CONTACT_NAME
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.ATTRIBUTE_CATEGORY
, CTT.ATTRIBUTE1
, CTT.ATTRIBUTE2
, CTT.ATTRIBUTE3
, CTT.ATTRIBUTE4
, CTT.ATTRIBUTE5
, CTT.ATTRIBUTE6
, CTT.ATTRIBUTE7
, CTT.ATTRIBUTE8
, CTT.ATTRIBUTE9
, CTT.ATTRIBUTE10
, CTT.ATTRIBUTE11
, CTT.ATTRIBUTE12
, CTT.ATTRIBUTE13
, CTT.ATTRIBUTE14
, CTT.ATTRIBUTE15
FROM OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS CRO
, OKX_VENDOR_CONTACTS_V OKX
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = CTT.CRO_CODE
AND OKX.ID1 = CTT.OBJECT1_ID1
AND CTT.JTOT_OBJECT1_CODE = 'OKX_VCONTACT'
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U') UNION SELECT CTT.ID PARTY_CONTACT_ID
, CTT.DNZ_CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CTT.CPL_ID PARTY_ROLE_ID
, CTT.CRO_CODE CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(CTT.OBJECT1_ID1) CONTACT_ID
, OKX.NAME CONTACT_NAME
, CTT.CREATION_DATE
, CTT.LAST_UPDATE_DATE
, CTT.ATTRIBUTE_CATEGORY
, CTT.ATTRIBUTE1
, CTT.ATTRIBUTE2
, CTT.ATTRIBUTE3
, CTT.ATTRIBUTE4
, CTT.ATTRIBUTE5
, CTT.ATTRIBUTE6
, CTT.ATTRIBUTE7
, CTT.ATTRIBUTE8
, CTT.ATTRIBUTE9
, CTT.ATTRIBUTE10
, CTT.ATTRIBUTE11
, CTT.ATTRIBUTE12
, CTT.ATTRIBUTE13
, CTT.ATTRIBUTE14
, CTT.ATTRIBUTE15
FROM OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS CRO
, OKX_SALESREPS_V OKX
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = CTT.CRO_CODE
AND OKX.ID1 = CTT.OBJECT1_ID1
AND CTT.JTOT_OBJECT1_CODE = 'OKX_SALESPER'
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U')

Columns