VIEW: APPS.OKI_K_PARTIES_V

Source

View Text - Preformatted

SELECT cpr.id party_role_id ,shd.chr_id contract_id ,shd.contract_number ,shd.contract_number_modifier ,shd.complete_contract_number ,cpr.rle_code role_code ,rle.meaning role_meaning ,to_number(cpr.object1_id1) party_id ,okx.name party_name ,okx.party_number ,cpr.creation_date ,cpr.last_update_date ,cpr.attribute_category ,cpr.attribute1 ,cpr.attribute2 ,cpr.attribute3 ,cpr.attribute4 ,cpr.attribute5 ,cpr.attribute6 ,cpr.attribute7 ,cpr.attribute8 ,cpr.attribute9 ,cpr.attribute10 ,cpr.attribute11 ,cpr.attribute12 ,cpr.attribute13 ,cpr.attribute14 ,cpr.attribute15 FROM OKC_K_PARTY_ROLES_B CPR,OKI_SALES_K_HDRS SHD,FND_LOOKUPS RLE,OKX_PARTIES_V OKX WHERE rle.lookup_type = 'OKC_ROLE' and rle.lookup_code = cpr.rle_code and okx.id1 = to_number(cpr.object1_id1) and cpr.jtot_object1_code = 'OKX_PARTY' and cpr.dnz_chr_id = shd.chr_id and cpr.chr_id is not null and okc_util.get_k_access_level(shd.chr_id, shd.scs_code) in ('R','U') union all select cpr.id ,shd.chr_id ,shd.contract_number ,shd.contract_number_modifier ,shd.complete_contract_number ,cpr.rle_code role_code ,rle.meaning ,to_number(cpr.object1_id1) party_id ,okx.name ,okx.party_number ,cpr.creation_date ,cpr.last_update_date ,cpr.attribute_category ,cpr.attribute1 ,cpr.attribute2 ,cpr.attribute3 ,cpr.attribute4 ,cpr.attribute5 ,cpr.attribute6 ,cpr.attribute7 ,cpr.attribute8 ,cpr.attribute9 ,cpr.attribute10 ,cpr.attribute11 ,cpr.attribute12 ,cpr.attribute13 ,cpr.attribute14 ,cpr.attribute15 from okc_k_party_roles_b cpr ,oki_sales_k_hdrs shd ,fnd_lookups rle ,okx_organization_defs_v okx where rle.lookup_type = 'OKC_ROLE' and rle.lookup_code = cpr.rle_code and okx.organization_type = 'OPERATING_UNIT' and okx.information_type = 'Operating Unit Information' and okx.id1 = to_number(cpr.object1_id1) and cpr.jtot_object1_code = 'OKX_OPERUNIT' and cpr.dnz_chr_id = shd.chr_id and cpr.chr_id is not null and okc_util.get_k_access_level(shd.chr_id, shd.scs_code) in ('R','U')

View Text - HTML Formatted

SELECT CPR.ID PARTY_ROLE_ID
, SHD.CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CPR.RLE_CODE ROLE_CODE
, RLE.MEANING ROLE_MEANING
, TO_NUMBER(CPR.OBJECT1_ID1) PARTY_ID
, OKX.NAME PARTY_NAME
, OKX.PARTY_NUMBER
, CPR.CREATION_DATE
, CPR.LAST_UPDATE_DATE
, CPR.ATTRIBUTE_CATEGORY
, CPR.ATTRIBUTE1
, CPR.ATTRIBUTE2
, CPR.ATTRIBUTE3
, CPR.ATTRIBUTE4
, CPR.ATTRIBUTE5
, CPR.ATTRIBUTE6
, CPR.ATTRIBUTE7
, CPR.ATTRIBUTE8
, CPR.ATTRIBUTE9
, CPR.ATTRIBUTE10
, CPR.ATTRIBUTE11
, CPR.ATTRIBUTE12
, CPR.ATTRIBUTE13
, CPR.ATTRIBUTE14
, CPR.ATTRIBUTE15
FROM OKC_K_PARTY_ROLES_B CPR
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS RLE
, OKX_PARTIES_V OKX
WHERE RLE.LOOKUP_TYPE = 'OKC_ROLE'
AND RLE.LOOKUP_CODE = CPR.RLE_CODE
AND OKX.ID1 = TO_NUMBER(CPR.OBJECT1_ID1)
AND CPR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND CPR.DNZ_CHR_ID = SHD.CHR_ID
AND CPR.CHR_ID IS NOT NULL
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U') UNION ALL SELECT CPR.ID
, SHD.CHR_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CPR.RLE_CODE ROLE_CODE
, RLE.MEANING
, TO_NUMBER(CPR.OBJECT1_ID1) PARTY_ID
, OKX.NAME
, OKX.PARTY_NUMBER
, CPR.CREATION_DATE
, CPR.LAST_UPDATE_DATE
, CPR.ATTRIBUTE_CATEGORY
, CPR.ATTRIBUTE1
, CPR.ATTRIBUTE2
, CPR.ATTRIBUTE3
, CPR.ATTRIBUTE4
, CPR.ATTRIBUTE5
, CPR.ATTRIBUTE6
, CPR.ATTRIBUTE7
, CPR.ATTRIBUTE8
, CPR.ATTRIBUTE9
, CPR.ATTRIBUTE10
, CPR.ATTRIBUTE11
, CPR.ATTRIBUTE12
, CPR.ATTRIBUTE13
, CPR.ATTRIBUTE14
, CPR.ATTRIBUTE15
FROM OKC_K_PARTY_ROLES_B CPR
, OKI_SALES_K_HDRS SHD
, FND_LOOKUPS RLE
, OKX_ORGANIZATION_DEFS_V OKX
WHERE RLE.LOOKUP_TYPE = 'OKC_ROLE'
AND RLE.LOOKUP_CODE = CPR.RLE_CODE
AND OKX.ORGANIZATION_TYPE = 'OPERATING_UNIT'
AND OKX.INFORMATION_TYPE = 'OPERATING UNIT INFORMATION'
AND OKX.ID1 = TO_NUMBER(CPR.OBJECT1_ID1)
AND CPR.JTOT_OBJECT1_CODE = 'OKX_OPERUNIT'
AND CPR.DNZ_CHR_ID = SHD.CHR_ID
AND CPR.CHR_ID IS NOT NULL
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U')