VIEW: APPS.OKI_K_CONTACTS_V

Source

View Text - Preformatted

SELECT ctt.id party_contact_id , shd.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 = to_number(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 all select ctt.id party_contact_id ,shd.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 = to_number(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 all select ctt.id party_contact_id ,shd.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 =to_number( 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 all select ctt.id party_contact_id ,shd.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 = to_number(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 all select ctt.id party_contact_id ,shd.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 = to_number(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 all select ctt.id party_contact_id ,shd.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 = to_number(ctt.object1_id1) and ctt.jtot_object1_code = 'OKX_SALEPERS' and ctt.dnz_chr_id = shd.chr_id and okc_util.get_k_access_level(shd.chr_id, shd.scs_code) in ('R','U')

View Text - HTML Formatted

SELECT CTT.ID PARTY_CONTACT_ID
, SHD.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 = TO_NUMBER(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 ALL SELECT CTT.ID PARTY_CONTACT_ID
, SHD.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 = TO_NUMBER(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 ALL SELECT CTT.ID PARTY_CONTACT_ID
, SHD.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 =TO_NUMBER( 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 ALL SELECT CTT.ID PARTY_CONTACT_ID
, SHD.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 = TO_NUMBER(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 ALL SELECT CTT.ID PARTY_CONTACT_ID
, SHD.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 = TO_NUMBER(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 ALL SELECT CTT.ID PARTY_CONTACT_ID
, SHD.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 = TO_NUMBER(CTT.OBJECT1_ID1)
AND CTT.JTOT_OBJECT1_CODE = 'OKX_SALEPERS'
AND CTT.DNZ_CHR_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U')