VIEW: APPS.OKI_K_SALESREP_V

Source

View Text - Preformatted

SELECT ksr.party_contact_id ,ksr.contract_id ,shd.contract_number ,shd.contract_number_modifier ,shd.complete_contract_number ,ksr.party_role_id ,ksr.contact_role_code ,cro.meaning contact_role_meaning ,to_number(ksr.contact_id) contact_id ,jrs.name salesrep_name ,ksr.creation_date ,ksr.last_update_date ,ksr.attribute_category ,ksr.attribute1 ,ksr.attribute2 ,ksr.attribute3 ,ksr.attribute4 ,ksr.attribute5 ,ksr.attribute6 ,ksr.attribute7 ,ksr.attribute8 ,ksr.attribute9 ,ksr.attribute10 ,ksr.attribute11 ,ksr.attribute12 ,ksr.attribute13 ,ksr.attribute14 ,ksr.attribute15 FROM JTF_RS_SALESREPS JRS,OKI_K_SALESREPS KSR,OKI_SALES_K_HDRS SHD,FND_LOOKUPS CRO WHERE cro.lookup_type = 'OKC_CONTACT_ROLE' and cro.lookup_code = ksr.contact_role_code and jrs.salesrep_id =ksr.contact_id and jrs.org_id = shd.authoring_org_id and ksr.contract_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 KSR.PARTY_CONTACT_ID
, KSR.CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, KSR.PARTY_ROLE_ID
, KSR.CONTACT_ROLE_CODE
, CRO.MEANING CONTACT_ROLE_MEANING
, TO_NUMBER(KSR.CONTACT_ID) CONTACT_ID
, JRS.NAME SALESREP_NAME
, KSR.CREATION_DATE
, KSR.LAST_UPDATE_DATE
, KSR.ATTRIBUTE_CATEGORY
, KSR.ATTRIBUTE1
, KSR.ATTRIBUTE2
, KSR.ATTRIBUTE3
, KSR.ATTRIBUTE4
, KSR.ATTRIBUTE5
, KSR.ATTRIBUTE6
, KSR.ATTRIBUTE7
, KSR.ATTRIBUTE8
, KSR.ATTRIBUTE9
, KSR.ATTRIBUTE10
, KSR.ATTRIBUTE11
, KSR.ATTRIBUTE12
, KSR.ATTRIBUTE13
, KSR.ATTRIBUTE14
, KSR.ATTRIBUTE15
FROM JTF_RS_SALESREPS JRS
, OKI_K_SALESREPS KSR
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS CRO
WHERE CRO.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CRO.LOOKUP_CODE = KSR.CONTACT_ROLE_CODE
AND JRS.SALESREP_ID =KSR.CONTACT_ID
AND JRS.ORG_ID = SHD.AUTHORING_ORG_ID
AND KSR.CONTRACT_ID = SHD.CHR_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U')