eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on DUAL

Line 686: RESIDUAL_PERCENTAGE,

682: EVERGREEN_PERCENT,
683: AMOUNT_STAKE,
684: OCCUPANCY,
685: COVERAGE,
686: RESIDUAL_PERCENTAGE,
687: DATE_LAST_INSPECTION,
688: DATE_SOLD,
689: LRV_AMOUNT,
690: CAPITAL_REDUCTION,

Line 692: DATE_RESIDUAL_LAST_REVIEW,

688: DATE_SOLD,
689: LRV_AMOUNT,
690: CAPITAL_REDUCTION,
691: DATE_NEXT_INSPECTION_DUE,
692: DATE_RESIDUAL_LAST_REVIEW,
693: DATE_LAST_REAMORTISATION,
694: VENDOR_ADVANCE_PAID,
695: WEIGHTED_AVERAGE_LIFE,
696: TRADEIN_AMOUNT,

Line 717: RESIDUAL_VALUE,

713: REPURCHASED_AMOUNT,
714: DATE_COMMITMENT_EXPIRATION,
715: DATE_REPURCHASED,
716: DATE_APPRAISAL,
717: RESIDUAL_VALUE,
718: APPRAISAL_VALUE,
719: SECURED_DEAL_YN,
720: GAIN_LOSS,
721: FLOOR_AMOUNT,

Line 724: TRACKED_RESIDUAL,

720: GAIN_LOSS,
721: FLOOR_AMOUNT,
722: RE_LEASE_YN,
723: PREVIOUS_CONTRACT,
724: TRACKED_RESIDUAL,
725: DATE_TITLE_RECEIVED,
726: AMOUNT,
727: ATTRIBUTE_CATEGORY,
728: ATTRIBUTE1,

Line 756: RESIDUAL_GRNTY_AMOUNT,

752: DATE_ACCEPTED,
753: DATE_DELIVERY_EXPECTED,
754: OEC,
755: CAPITAL_AMOUNT,
756: RESIDUAL_GRNTY_AMOUNT,
757: RESIDUAL_CODE,
758: RVI_PREMIUM,
759: CREDIT_NATURE,
760: CAPITALIZED_INTEREST,

Line 757: RESIDUAL_CODE,

753: DATE_DELIVERY_EXPECTED,
754: OEC,
755: CAPITAL_AMOUNT,
756: RESIDUAL_GRNTY_AMOUNT,
757: RESIDUAL_CODE,
758: RVI_PREMIUM,
759: CREDIT_NATURE,
760: CAPITALIZED_INTEREST,
761: CAPITAL_REDUCTION_PERCENT,

Line 790: x_klev_rec.RESIDUAL_PERCENTAGE,

786: x_klev_rec.EVERGREEN_PERCENT,
787: x_klev_rec.AMOUNT_STAKE,
788: x_klev_rec.OCCUPANCY,
789: x_klev_rec.COVERAGE,
790: x_klev_rec.RESIDUAL_PERCENTAGE,
791: x_klev_rec.DATE_LAST_INSPECTION,
792: x_klev_rec.DATE_SOLD,
793: x_klev_rec.LRV_AMOUNT,
794: x_klev_rec.CAPITAL_REDUCTION,

Line 796: x_klev_rec.DATE_RESIDUAL_LAST_REVIEW,

792: x_klev_rec.DATE_SOLD,
793: x_klev_rec.LRV_AMOUNT,
794: x_klev_rec.CAPITAL_REDUCTION,
795: x_klev_rec.DATE_NEXT_INSPECTION_DUE,
796: x_klev_rec.DATE_RESIDUAL_LAST_REVIEW,
797: x_klev_rec.DATE_LAST_REAMORTISATION,
798: x_klev_rec.VENDOR_ADVANCE_PAID,
799: x_klev_rec.WEIGHTED_AVERAGE_LIFE,
800: x_klev_rec.TRADEIN_AMOUNT,

Line 821: x_klev_rec.RESIDUAL_VALUE,

817: x_klev_rec.REPURCHASED_AMOUNT,
818: x_klev_rec.DATE_COMMITMENT_EXPIRATION,
819: x_klev_rec.DATE_REPURCHASED,
820: x_klev_rec.DATE_APPRAISAL,
821: x_klev_rec.RESIDUAL_VALUE,
822: x_klev_rec.APPRAISAL_VALUE,
823: x_klev_rec.SECURED_DEAL_YN,
824: x_klev_rec.GAIN_LOSS,
825: x_klev_rec.FLOOR_AMOUNT,

Line 828: x_klev_rec.TRACKED_RESIDUAL,

824: x_klev_rec.GAIN_LOSS,
825: x_klev_rec.FLOOR_AMOUNT,
826: x_klev_rec.RE_LEASE_YN,
827: x_klev_rec.PREVIOUS_CONTRACT,
828: x_klev_rec.TRACKED_RESIDUAL,
829: x_klev_rec.DATE_TITLE_RECEIVED,
830: x_klev_rec.AMOUNT,
831: x_klev_rec.ATTRIBUTE_CATEGORY,
832: x_klev_rec.ATTRIBUTE1,

Line 860: x_klev_rec.RESIDUAL_GRNTY_AMOUNT,

856: x_klev_rec.DATE_ACCEPTED,
857: x_klev_rec.DATE_DELIVERY_EXPECTED,
858: x_klev_rec.OEC,
859: x_klev_rec.CAPITAL_AMOUNT,
860: x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
861: x_klev_rec.RESIDUAL_CODE,
862: x_klev_rec.RVI_PREMIUM,
863: x_klev_rec.CREDIT_NATURE,
864: x_klev_rec.CAPITALIZED_INTEREST,

Line 861: x_klev_rec.RESIDUAL_CODE,

857: x_klev_rec.DATE_DELIVERY_EXPECTED,
858: x_klev_rec.OEC,
859: x_klev_rec.CAPITAL_AMOUNT,
860: x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
861: x_klev_rec.RESIDUAL_CODE,
862: x_klev_rec.RVI_PREMIUM,
863: x_klev_rec.CREDIT_NATURE,
864: x_klev_rec.CAPITALIZED_INTEREST,
865: x_klev_rec.CAPITAL_REDUCTION_PERCENT,

Line 920: FROM DUAL

916:
917: -- To check the existence of the contract.
918: CURSOR c_get_contract(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
919: SELECT 1
920: FROM DUAL
921: WHERE EXISTS (SELECT '1'
922: FROM OKC_K_HEADERS_B
923: WHERE ID = p_chr_id);
924:

Line 1154: FROM DUAL

1150: ln_dummy NUMBER := 0;
1151: CURSOR c_chr_cle_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1152: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1153: SELECT 1
1154: FROM DUAL
1155: WHERE EXISTS (SELECT 1
1156: FROM OKC_SUBCLASS_TOP_LINE stl,
1157: OKC_LINE_STYLES_V lse,
1158: OKC_K_LINES_V cle

Line 1901: FROM DUAL

1897:
1898: -- To check the existence of the contract.
1899: CURSOR c_get_contract(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1900: SELECT 1
1901: FROM DUAL
1902: WHERE EXISTS (SELECT '1'
1903: FROM OKC_K_HEADERS_B
1904: WHERE ID = p_chr_id);
1905:

Line 2249: FROM DUAL

2245:
2246: CURSOR check_other_line(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
2247: IS
2248: SELECT '1'
2249: FROM DUAL
2250: WHERE EXISTS (SELECT '1'
2251: FROM OKC_K_LINES_B cle,
2252: OKC_LINE_STYLES_b lse
2253: WHERE cle.dnz_chr_id = p_chr_id

Line 3321: FROM DUAL

3317:
3318: CURSOR check_other_line(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3319: IS
3320: SELECT '1'
3321: FROM DUAL
3322: WHERE EXISTS (SELECT '1'
3323: FROM OKC_K_LINES_B cle,
3324: OKC_LINE_STYLES_b lse
3325: WHERE cle.dnz_chr_id = p_chr_id

Line 3333: FROM dual

3329:
3330: -- to check weather the given Chr id belongs to a Split Contract process
3331: CURSOR check_split_k_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
3332: SELECT 1
3333: FROM dual
3334: WHERE EXISTS (SELECT 1
3335: FROM okl_trx_contracts trx,
3336: okl_trx_types_tl try,
3337: okl_k_headers khr