VIEW: APPS.OKL_RECONCILE_DISPLAY_UV

Source

View Text - Preformatted

SELECT prog.id id ,prog.contract_number program_number ,prog.short_description vendor_program ,pty.name name ,chr.contract_number contract_number ,cra.eligible_cure_amount eligible_cure_amount ,cra.claimed_cure_amount claimed_cure_amount ,cra.repurchase_amount repurchase_amount ,crt.report_date report_date ,crt.report_number report_number ,cam.chr_id chr_id ,crt.cure_report_id cure_report_id FROM OKC_K_HEADERS_V PROG,OKC_K_PARTY_ROLES_V RLE,OKX_PARTIES_V PTY,OKL_K_HEADERS_V KHR,OKC_K_HEADERS_V CHR,OKL_CURE_REPORTS_ALL CRT,OKL_CURE_REPORT_AMTS_ALL CRA,OKL_CURE_AMOUNTS CAM where CRT.Cure_report_id = CRA.cure_report_id (+) and CRA.Cure_amount_id = CAM.Cure_amount_id (+) and CAM.Chr_id = CHR.id (+) and CHR.id = KHR.id (+) and ( CHR.scs_code in ('LEASE','LOAN') OR CHR.scs_code IS NULL) and KHR.khr_id = PROG.id (+) and ( PROG.scs_code = 'PROGRAM' OR PROG.scs_code IS NULL ) and CHR.id = RLE.chr_id (+) and ( RLE.rle_code = 'LESSEE' OR RLE.rle_code IS NULL) and RLE.object1_id1 = PTY.id1 (+) and RLE.object1_id2 = PTY.id2 (+)

View Text - HTML Formatted

SELECT PROG.ID ID
, PROG.CONTRACT_NUMBER PROGRAM_NUMBER
, PROG.SHORT_DESCRIPTION VENDOR_PROGRAM
, PTY.NAME NAME
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CRA.ELIGIBLE_CURE_AMOUNT ELIGIBLE_CURE_AMOUNT
, CRA.CLAIMED_CURE_AMOUNT CLAIMED_CURE_AMOUNT
, CRA.REPURCHASE_AMOUNT REPURCHASE_AMOUNT
, CRT.REPORT_DATE REPORT_DATE
, CRT.REPORT_NUMBER REPORT_NUMBER
, CAM.CHR_ID CHR_ID
, CRT.CURE_REPORT_ID CURE_REPORT_ID
FROM OKC_K_HEADERS_V PROG
, OKC_K_PARTY_ROLES_V RLE
, OKX_PARTIES_V PTY
, OKL_K_HEADERS_V KHR
, OKC_K_HEADERS_V CHR
, OKL_CURE_REPORTS_ALL CRT
, OKL_CURE_REPORT_AMTS_ALL CRA
, OKL_CURE_AMOUNTS CAM
WHERE CRT.CURE_REPORT_ID = CRA.CURE_REPORT_ID (+)
AND CRA.CURE_AMOUNT_ID = CAM.CURE_AMOUNT_ID (+)
AND CAM.CHR_ID = CHR.ID (+)
AND CHR.ID = KHR.ID (+)
AND ( CHR.SCS_CODE IN ('LEASE'
, 'LOAN') OR CHR.SCS_CODE IS NULL)
AND KHR.KHR_ID = PROG.ID (+)
AND ( PROG.SCS_CODE = 'PROGRAM' OR PROG.SCS_CODE IS NULL )
AND CHR.ID = RLE.CHR_ID (+)
AND ( RLE.RLE_CODE = 'LESSEE' OR RLE.RLE_CODE IS NULL)
AND RLE.OBJECT1_ID1 = PTY.ID1 (+)
AND RLE.OBJECT1_ID2 = PTY.ID2 (+)