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_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_SEEDED_FUNCTIONS_PVT

Line 794: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,

790: khr.TRADEIN_AMOUNT CONTRACT_TRADEIN_AMOUNT,
791: khr.DATE_TRADEIN CONTRACT_TRADEIN_DATE,
792: khr.LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID,
793: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
794: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,

Line 795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,

791: khr.DATE_TRADEIN CONTRACT_TRADEIN_DATE,
792: khr.LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID,
793: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
794: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,

Line 796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,

792: khr.LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID,
793: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
794: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,

Line 797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,

793: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
794: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,

Line 798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,

794: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,

Line 799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,

795: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,

Line 800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,

796: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,

Line 801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,

797: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,

Line 802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,

798: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,

Line 803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,

799: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,

Line 804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,

800: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,

Line 805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,

801: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para

Line 806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,

802: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,

Line 807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,

803: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,

Line 808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,

804: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,

Line 809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para

805: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,

Line 810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,

806: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
814: -- null CONTRACT_BILLED_RENTS,

Line 811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,

807: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
814: -- null CONTRACT_BILLED_RENTS,
815: (select SUM(NVL(txd.amount,0))

Line 812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,

808: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
814: -- null CONTRACT_BILLED_RENTS,
815: (select SUM(NVL(txd.amount,0))
816: from OKL_TXD_AR_LN_DTLS_B txd,

Line 813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,

809: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
810: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
811: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
814: -- null CONTRACT_BILLED_RENTS,
815: (select SUM(NVL(txd.amount,0))
816: from OKL_TXD_AR_LN_DTLS_B txd,
817: okl_strm_type_b sty

Line 825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,

821:
822: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para

Line 826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,

822: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
830:

Line 827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para

823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
830:
831: hr_org.name OPERATING_UNIT,

Line 828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para

824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
830:
831: hr_org.name OPERATING_UNIT,
832: hr_org.short_code OPERATING_UNIT_SHORT_CODE,

Line 829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para

825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
830:
831: hr_org.name OPERATING_UNIT,
832: hr_org.short_code OPERATING_UNIT_SHORT_CODE,
833: status.ste_code CONTRACT_STATUS_TYPE_CODE,

Line 1014: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),

1010: where txd.khr_id = khr.id ) CONTRACT_TOT_BILLED_RECEIVABLE,
1011:
1012: /*
1013: -- for Net Investment
1014: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1015: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1016: 0 ) CONTRACT_UNEARNED_INCOME,
1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),

Line 1015: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),

1011:
1012: /*
1013: -- for Net Investment
1014: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1015: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1016: 0 ) CONTRACT_UNEARNED_INCOME,
1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1019: 0) CONTRACT_RESIDUAL_AMOUNT,

Line 1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),

1013: -- for Net Investment
1014: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1015: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1016: 0 ) CONTRACT_UNEARNED_INCOME,
1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1019: 0) CONTRACT_RESIDUAL_AMOUNT,
1020: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1021: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),

Line 1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),

1014: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1015: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
1016: 0 ) CONTRACT_UNEARNED_INCOME,
1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1019: 0) CONTRACT_RESIDUAL_AMOUNT,
1020: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1021: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1022: 0) CONTRACT_RENT_AMOUNT,

Line 1020: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),

1016: 0 ) CONTRACT_UNEARNED_INCOME,
1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1019: 0) CONTRACT_RESIDUAL_AMOUNT,
1020: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1021: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1022: 0) CONTRACT_RENT_AMOUNT,
1023: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
1024: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP

Line 1021: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),

1017: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1018: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
1019: 0) CONTRACT_RESIDUAL_AMOUNT,
1020: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1021: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1022: 0) CONTRACT_RENT_AMOUNT,
1023: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
1024: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
1025: */

Line 1023: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),

1019: 0) CONTRACT_RESIDUAL_AMOUNT,
1020: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1021: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
1022: 0) CONTRACT_RENT_AMOUNT,
1023: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
1024: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
1025: */
1026: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
1027: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,

Line 1027: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,

1023: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
1024: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
1025: */
1026: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
1027: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
1028: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
1029: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
1030: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
1031:

Line 1028: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,

1024: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
1025: */
1026: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
1027: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
1028: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
1029: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
1030: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
1031:
1032:

Line 1029: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,

1025: */
1026: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
1027: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
1028: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
1029: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
1030: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
1031:
1032:
1033: -- OKL_ACCOUNTING_UTIL.get_curr_con_rate(chr.CURRENCY_CODE, ledger.CURRENCY_CODE, trunc(sysdate), khr.CURRENCY_CONVERSION_TYPE) currency_convertion_rate

Line 1030: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,

1026: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
1027: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
1028: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
1029: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
1030: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
1031:
1032:
1033: -- OKL_ACCOUNTING_UTIL.get_curr_con_rate(chr.CURRENCY_CODE, ledger.CURRENCY_CODE, trunc(sysdate), khr.CURRENCY_CONVERSION_TYPE) currency_convertion_rate
1034:

Line 1827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,

1823: khr.TRADEIN_AMOUNT CONTRACT_TRADEIN_AMOUNT,
1824: khr.DATE_TRADEIN CONTRACT_TRADEIN_DATE,
1825: khr.LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID,
1826: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
1827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,

Line 1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,

1824: khr.DATE_TRADEIN CONTRACT_TRADEIN_DATE,
1825: khr.LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID,
1826: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
1827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,

Line 1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,

1825: khr.LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID,
1826: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
1827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,

Line 1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,

1826: khr.DATE_FIRST_ACTIVITY CONTRACT_FIRST_ACTIVITY_DATE,
1827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,

Line 1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,

1827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACCUMULATED_DEPRN(chr.id, null),0) CONTRACT_ACCUMULATED_DEP,
1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,

Line 1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,

1828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_CAPITAL_REDUCTION(chr.id, null),0) CONTRACT_CAPITALIZED_REDUCTION,
1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,

Line 1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,

1829: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FEES_CAPITALIZED(chr.id, null),0) CONTRACT_CAPITALIZED_FEE,
1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,

Line 1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,

1830: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capitalized_interest(chr.id, null),0) CONTRACT_CAPITALIZED_INTEREST,
1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,

Line 1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,

1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DISCOUNT(chr.id, null),0) CONTRACT_DISCOUNT,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,

Line 1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,

1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ASSET_COST(chr.id, null),0) CONTRACT_ASSET_COST,
1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,

Line 1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,

1833: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_FINANCED_FEE(chr.id, null),0) CONTRACT_FINANCED_FEE,
1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,

Line 1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,

1834: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_NEXT_PAYMENT_AMOUNT(chr.id, null),0) CONTRACT_NEXT_PAYMENT_AMT,
1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para

Line 1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,

1835: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACCRUED_INT(chr.id, null),0) CONTRACT_TOTAL_ACCRUED_INT,
1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,

Line 1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,

1836: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_TOTAL_ACTUAL_INT(chr.id, null),0) CONTRACT_TOTAL_ACTUAL_INT,
1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,

Line 1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,

1837: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_asset_subsidy_amount(chr.id, null),0) CONTRACT_SUBSIDY_AMOUNT,
1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,

Line 1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para

1838: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNACCRUED_SUBSIDY(chr.id, null),0) CONTRACT_UNACCRUED_SUBSIDY,
1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,

Line 1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,

1839: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_STREAMS(chr.id, null),0) CONTRACT_UNBILLED_DUE_AMOUNT,
1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1847: -- null CONTRACT_BILLED_RENTS,

Line 1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,

1840: DECODE(khr.deal_type,'LOAN',NULL,'LOAN-REVOLVING',NULL,NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_UNBILLED_RECEIVABLES(chr.id, null),0)) CONTRACT_UNBILLED_RECEIVABLES,
1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1847: -- null CONTRACT_BILLED_RENTS,
1848: (select SUM(NVL(txd.amount,0))

Line 1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,

1841: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_OEC(chr.id, null),0) CONTRACT_OEC,
1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1847: -- null CONTRACT_BILLED_RENTS,
1848: (select SUM(NVL(txd.amount,0))
1849: from OKL_TXD_AR_LN_DTLS_B txd,

Line 1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,

1842: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(chr.id, null),0) CONTRACT_ACTUAL_PRINC_BAL, -- addl para
1843: NVL(OKL_SEEDED_FUNCTIONS_PVT.ROLLOVER_FEE(chr.id, null),0) ROLLOVER_FEE_AMOUNT,
1844: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_funded(chr.id, null),0) TOTAL_AMOUNT_PAID_TO_DEALER,
1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1847: -- null CONTRACT_BILLED_RENTS,
1848: (select SUM(NVL(txd.amount,0))
1849: from OKL_TXD_AR_LN_DTLS_B txd,
1850: okl_strm_type_b sty

Line 1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,

1854:
1855: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
1862: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para

Line 1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,

1855: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
1862: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
1863:

Line 1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para

1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
1862: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
1863:
1864: hr_org.name OPERATING_UNIT,

Line 1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para

1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
1862: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
1863:
1864: hr_org.name OPERATING_UNIT,
1865: hr_org.short_code OPERATING_UNIT_SHORT_CODE,

Line 1862: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para

1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para
1862: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_IN_YEAR(chr.id, null),0) CONTRACT_DAYS_IN_YEAR, -- addl para
1863:
1864: hr_org.name OPERATING_UNIT,
1865: hr_org.short_code OPERATING_UNIT_SHORT_CODE,
1866: status.ste_code CONTRACT_STATUS_TYPE_CODE,

Line 2046: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),

2042: where txd.khr_id = khr.id ) CONTRACT_TOT_BILLED_RECEIVABLE,
2043:
2044: /*
2045: -- for Net Investment
2046: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2047: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2048: 0 ) CONTRACT_UNEARNED_INCOME,
2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),

Line 2047: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),

2043:
2044: /*
2045: -- for Net Investment
2046: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2047: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2048: 0 ) CONTRACT_UNEARNED_INCOME,
2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2051: 0) CONTRACT_RESIDUAL_AMOUNT,

Line 2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),

2045: -- for Net Investment
2046: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2047: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2048: 0 ) CONTRACT_UNEARNED_INCOME,
2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2051: 0) CONTRACT_RESIDUAL_AMOUNT,
2052: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2053: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),

Line 2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),

2046: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2047: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0),
2048: 0 ) CONTRACT_UNEARNED_INCOME,
2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2051: 0) CONTRACT_RESIDUAL_AMOUNT,
2052: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2053: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2054: 0) CONTRACT_RENT_AMOUNT,

Line 2052: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),

2048: 0 ) CONTRACT_UNEARNED_INCOME,
2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2051: 0) CONTRACT_RESIDUAL_AMOUNT,
2052: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2053: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2054: 0) CONTRACT_RENT_AMOUNT,
2055: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
2056: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP

Line 2053: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),

2049: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2050: 'LEASEST', NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0),
2051: 0) CONTRACT_RESIDUAL_AMOUNT,
2052: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2053: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2054: 0) CONTRACT_RENT_AMOUNT,
2055: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
2056: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
2057: */

Line 2055: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),

2051: 0) CONTRACT_RESIDUAL_AMOUNT,
2052: DECODE(khr.deal_type, 'LEASEDF', NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2053: 'LEASEST',NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0),
2054: 0) CONTRACT_RENT_AMOUNT,
2055: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
2056: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
2057: */
2058: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
2059: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,

Line 2059: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,

2055: DECODE(khr.deal_type, 'LEASEOP', NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0),
2056: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
2057: */
2058: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
2059: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
2060: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:

Line 2060: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,

2056: 0) CONTRACT_ACC_DEPRECIATION, --Duplicate of CONTRACT_ACCUMULATED_DEP
2057: */
2058: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
2059: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
2060: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:
2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,

Line 2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,

2057: */
2058: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
2059: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
2060: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:
2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
2065: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,

Line 2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,

2058: --sechawla : calculate CONTRACT_UNEARNED_INCOME, CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION for all types of leases
2059: NVL(Okl_Seeded_Functions_Pvt.contract_unearned_income(chr.id, null),0) CONTRACT_UNEARNED_INCOME,
2060: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:
2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
2065: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
2066: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,