VIEW: APPS.OKL_CURE_CONTRACT_UV

Source

View Text - Preformatted

SELECT cruv.contract_number ,hzp.party_name ,cruv.vendor_id ,cruv.vendor_program_name ,cruv.rule_information5 ,0 ,cam.cure_amount_id ,cam.chr_id ,cam.cure_amount ,cam.repurchase_amount ,crf.refund_amount_due ,ncuv.cures_in_possession ,0 , NULL ,cam.CURE_AMOUNT ,cam.ELIGIBLE_CURE_AMOUNT ,cam.PAYMENTS_REMAINING ,cam.PAST_DUE_AMOUNT ,cam.OUTSTANDING_AMOUNT ,cam.TIMES_CURED ,CHR.CURRENCY_CODE FROM OKL_CURE_AMOUNTS_ALL CAM,OKL_CURE_RULE_UV CRUV,OKC_K_PARTY_ROLES_B CPR,HZ_PARTIES HZP,OKL_NO_OF_CURES_UV NCUV,OKC_K_HEADERS_V CHR,OKL_CURE_REFUNDS_DTLS_UV CRF WHERE cruv.contract_id = cam.chr_id AND chr.id = cruv.contract_id AND chr.id = cam.chr_id AND chr.id = cpr.chr_id AND cruv.contract_id = cpr.chr_id AND cpr.object1_id1 = hzp.party_id AND cpr.rle_code = 'LESSEE' AND cruv.contract_id = crf.contract_id (+) AND cruv.contract_id = ncuv.chr_id (+)

View Text - HTML Formatted

SELECT CRUV.CONTRACT_NUMBER
, HZP.PARTY_NAME
, CRUV.VENDOR_ID
, CRUV.VENDOR_PROGRAM_NAME
, CRUV.RULE_INFORMATION5
, 0
, CAM.CURE_AMOUNT_ID
, CAM.CHR_ID
, CAM.CURE_AMOUNT
, CAM.REPURCHASE_AMOUNT
, CRF.REFUND_AMOUNT_DUE
, NCUV.CURES_IN_POSSESSION
, 0
, NULL
, CAM.CURE_AMOUNT
, CAM.ELIGIBLE_CURE_AMOUNT
, CAM.PAYMENTS_REMAINING
, CAM.PAST_DUE_AMOUNT
, CAM.OUTSTANDING_AMOUNT
, CAM.TIMES_CURED
, CHR.CURRENCY_CODE
FROM OKL_CURE_AMOUNTS_ALL CAM
, OKL_CURE_RULE_UV CRUV
, OKC_K_PARTY_ROLES_B CPR
, HZ_PARTIES HZP
, OKL_NO_OF_CURES_UV NCUV
, OKC_K_HEADERS_V CHR
, OKL_CURE_REFUNDS_DTLS_UV CRF
WHERE CRUV.CONTRACT_ID = CAM.CHR_ID
AND CHR.ID = CRUV.CONTRACT_ID
AND CHR.ID = CAM.CHR_ID
AND CHR.ID = CPR.CHR_ID
AND CRUV.CONTRACT_ID = CPR.CHR_ID
AND CPR.OBJECT1_ID1 = HZP.PARTY_ID
AND CPR.RLE_CODE = 'LESSEE'
AND CRUV.CONTRACT_ID = CRF.CONTRACT_ID (+)
AND CRUV.CONTRACT_ID = NCUV.CHR_ID (+)