VIEW: APPS.IEX_EXCLUSION_ELIGIBLE_UV

Source

View Text - Preformatted

SELECT KHR.ID CONTRACT_ID ,KHR.CONTRACT_NUMBER CONTRACT_NUMBER ,JRE.SOURCE_NAME CASE_OWNER ,pty.name PARTY_NAME ,ICA.owner_resource_id OWNER_ID ,PTY.id1 PARTY_ID ,NULL CURED FROM OKC_K_HEADERS_V KHR,IEX_CASES_ALL_B ICA,JTF_RS_RESOURCE_EXTNS JRE,OKX_PARTIES_V PTY,OKC_K_PARTY_ROLES_V RLE,IEX_CASE_OBJECTS ICO WHERE ICO.object_id = KHR.id and ICO.cas_id = ICA.cas_id AND ICA.owner_resource_id = JRE.RESOURCE_ID and KHR.scs_code in ('LEASE','LOAN') and RLE.chr_id = KHR.id and RLE.object1_id1 = PTY.id1 and RLE.object1_id2 = PTY.id2 and RLE.rle_code = 'LESSEE'

View Text - HTML Formatted

SELECT KHR.ID CONTRACT_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, JRE.SOURCE_NAME CASE_OWNER
, PTY.NAME PARTY_NAME
, ICA.OWNER_RESOURCE_ID OWNER_ID
, PTY.ID1 PARTY_ID
, NULL CURED
FROM OKC_K_HEADERS_V KHR
, IEX_CASES_ALL_B ICA
, JTF_RS_RESOURCE_EXTNS JRE
, OKX_PARTIES_V PTY
, OKC_K_PARTY_ROLES_V RLE
, IEX_CASE_OBJECTS ICO
WHERE ICO.OBJECT_ID = KHR.ID
AND ICO.CAS_ID = ICA.CAS_ID
AND ICA.OWNER_RESOURCE_ID = JRE.RESOURCE_ID
AND KHR.SCS_CODE IN ('LEASE'
, 'LOAN')
AND RLE.CHR_ID = KHR.ID
AND RLE.OBJECT1_ID1 = PTY.ID1
AND RLE.OBJECT1_ID2 = PTY.ID2
AND RLE.RLE_CODE = 'LESSEE'