[Home] [Help]
View: OKL_RECONCILE_DISPLAY_UV
View Text
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 (+)
Columns
Name |
ID |
PROGRAM_NUMBER |
VENDOR_PROGRAM |
NAME |
CONTRACT_NUMBER |
ELIGIBLE_CURE_AMOUNT |
CLAIMED_CURE_AMOUNT |
REPURCHASE_AMOUNT |
REPORT_DATE |
REPORT_NUMBER |
CHR_ID |
REPORT_ID |