APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_SEEDED_FUNCTIONS_PVT

Line 1329: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,

1325: rl_ASSET_FILING_TITLE.rule_information8 ASSET_FILING_REGIS_EXP_DATE,
1326:
1327: -- formulas
1328: decode(cle.lse_id,33,
1329: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,
1330:
1331: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
1332:
1333: decode(cle.lse_id,33,

Line 1331: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,

1327: -- formulas
1328: decode(cle.lse_id,33,
1329: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,
1330:
1331: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
1332:
1333: decode(cle.lse_id,33,
1334: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
1335:

Line 1334: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,

1330:
1331: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
1332:
1333: decode(cle.lse_id,33,
1334: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
1335:
1336: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
1337:
1338: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,

Line 1336: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,

1332:
1333: decode(cle.lse_id,33,
1334: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
1335:
1336: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
1337:
1338: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
1339: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
1340:

Line 1339: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,

1335:
1336: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
1337:
1338: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
1339: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
1340:
1341: decode(cle.lse_id,33,
1342: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
1343:

Line 1342: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,

1338: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
1339: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
1340:
1341: decode(cle.lse_id,33,
1342: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
1343:
1344: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
1345:
1346: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,

Line 1344: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,

1340:
1341: decode(cle.lse_id,33,
1342: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
1343:
1344: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
1345:
1346: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
1347:
1348: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,

Line 1346: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,

1342: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
1343:
1344: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
1345:
1346: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
1347:
1348: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
1349:
1350: decode(cle.lse_id,33,

Line 1348: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,

1344: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
1345:
1346: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
1347:
1348: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
1349:
1350: decode(cle.lse_id,33,
1351: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
1352:

Line 1351: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,

1347:
1348: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
1349:
1350: decode(cle.lse_id,33,
1351: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
1352:
1353: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
1354:
1355: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,

Line 1353: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,

1349:
1350: decode(cle.lse_id,33,
1351: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
1352:
1353: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
1354:
1355: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
1356:
1357: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,

Line 1355: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,

1351: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
1352:
1353: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
1354:
1355: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
1356:
1357: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
1358:
1359: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,

Line 1357: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,

1353: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
1354:
1355: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
1356:
1357: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
1358:
1359: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
1360:
1361: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para

Line 1359: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,

1355: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
1356:
1357: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
1358:
1359: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
1360:
1361: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
1362:
1363: (select SUM(NVL(txd.amount,0))

Line 1361: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para

1357: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
1358:
1359: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
1360:
1361: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
1362:
1363: (select SUM(NVL(txd.amount,0))
1364: from OKL_TXD_AR_LN_DTLS_B txd,
1365: okl_strm_type_b sty

Line 1374: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,

1370: (select SUM(NVL(txd.amount,0))
1371: from OKL_TXD_AR_LN_DTLS_B txd
1372: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
1373:
1374: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
1375:
1376: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,
1377:
1378: --LINE_BILLED_NON_RENTS_FUNC,

Line 1376: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,

1372: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
1373:
1374: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
1375:
1376: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,
1377:
1378: --LINE_BILLED_NON_RENTS_FUNC,
1379: --LINE_CAP_AMOUNT,
1380: -- NET_INVESTMENT,

Line 1398: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,

1394: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
1395: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
1396:
1397: decode(cle.lse_id,33,
1398: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
1399:
1400: decode(cle.lse_id,33,
1401: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
1402:

Line 1401: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,

1397: decode(cle.lse_id,33,
1398: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
1399:
1400: decode(cle.lse_id,33,
1401: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
1402:
1403: decode(cle.lse_id,33,
1404: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,
1405:

Line 1404: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,

1400: decode(cle.lse_id,33,
1401: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
1402:
1403: decode(cle.lse_id,33,
1404: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,
1405:
1406:
1407: l_last_updated_by CREATED_BY,
1408: -- -1 CREATED_BY,

Line 3446: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,

3442: rl_ASSET_FILING_TITLE.rule_information8 ASSET_FILING_REGIS_EXP_DATE,
3443:
3444: -- formulas
3445: decode(cle.lse_id,33,
3446: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,
3447:
3448: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
3449:
3450: decode(cle.lse_id,33,

Line 3448: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,

3444: -- formulas
3445: decode(cle.lse_id,33,
3446: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,
3447:
3448: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
3449:
3450: decode(cle.lse_id,33,
3451: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
3452:

Line 3451: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,

3447:
3448: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
3449:
3450: decode(cle.lse_id,33,
3451: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
3452:
3453: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
3454:
3455: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,

Line 3453: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,

3449:
3450: decode(cle.lse_id,33,
3451: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
3452:
3453: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
3454:
3455: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
3456: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
3457:

Line 3456: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,

3452:
3453: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
3454:
3455: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
3456: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
3457:
3458: decode(cle.lse_id,33,
3459: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
3460:

Line 3459: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,

3455: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
3456: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
3457:
3458: decode(cle.lse_id,33,
3459: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
3460:
3461: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
3462:
3463: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,

Line 3461: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,

3457:
3458: decode(cle.lse_id,33,
3459: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
3460:
3461: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
3462:
3463: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
3464:
3465: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,

Line 3463: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,

3459: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
3460:
3461: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
3462:
3463: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
3464:
3465: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
3466:
3467: decode(cle.lse_id,33,

Line 3465: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,

3461: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
3462:
3463: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
3464:
3465: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
3466:
3467: decode(cle.lse_id,33,
3468: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
3469:

Line 3468: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,

3464:
3465: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
3466:
3467: decode(cle.lse_id,33,
3468: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
3469:
3470: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
3471:
3472: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,

Line 3470: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,

3466:
3467: decode(cle.lse_id,33,
3468: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
3469:
3470: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
3471:
3472: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
3473:
3474: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,

Line 3472: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,

3468: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
3469:
3470: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
3471:
3472: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
3473:
3474: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
3475:
3476: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,

Line 3474: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,

3470: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
3471:
3472: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
3473:
3474: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
3475:
3476: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
3477:
3478: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para

Line 3476: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,

3472: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
3473:
3474: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
3475:
3476: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
3477:
3478: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
3479:
3480: (select SUM(NVL(txd.amount,0))

Line 3478: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para

3474: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
3475:
3476: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
3477:
3478: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
3479:
3480: (select SUM(NVL(txd.amount,0))
3481: from OKL_TXD_AR_LN_DTLS_B txd,
3482: okl_strm_type_b sty

Line 3491: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,

3487: (select SUM(NVL(txd.amount,0))
3488: from OKL_TXD_AR_LN_DTLS_B txd
3489: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
3490:
3491: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
3492:
3493: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,
3494:
3495: --LINE_BILLED_NON_RENTS_FUNC,

Line 3493: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,

3489: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
3490:
3491: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
3492:
3493: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,
3494:
3495: --LINE_BILLED_NON_RENTS_FUNC,
3496: --LINE_CAP_AMOUNT,
3497: -- NET_INVESTMENT,

Line 3513: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,

3509: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
3510: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
3511:
3512: decode(cle.lse_id,33,
3513: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
3514:
3515: decode(cle.lse_id,33,
3516: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
3517:

Line 3516: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,

3512: decode(cle.lse_id,33,
3513: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
3514:
3515: decode(cle.lse_id,33,
3516: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
3517:
3518: decode(cle.lse_id,33,
3519: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,
3520:

Line 3519: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,

3515: decode(cle.lse_id,33,
3516: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
3517:
3518: decode(cle.lse_id,33,
3519: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,
3520:
3521:
3522: l_last_updated_by CREATED_BY,
3523: -- -1 CREATED_BY,

Line 5472: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,

5468: rl_ASSET_FILING_TITLE.rule_information8 ASSET_FILING_REGIS_EXP_DATE,
5469:
5470: -- formulas
5471: decode(cle.lse_id,33,
5472: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,
5473:
5474: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
5475:
5476: decode(cle.lse_id,33,

Line 5474: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,

5470: -- formulas
5471: decode(cle.lse_id,33,
5472: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_service_capitalized(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_CAP_SERVICE_AMOUNT,
5473:
5474: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
5475:
5476: decode(cle.lse_id,33,
5477: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
5478:

Line 5477: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,

5473:
5474: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_accumulated_deprn(cle.dnz_chr_id,cle.id),0) LINE_ACCUMULATED_DEPRECIATION,
5475:
5476: decode(cle.lse_id,33,
5477: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
5478:
5479: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
5480:
5481: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,

Line 5479: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,

5475:
5476: decode(cle.lse_id,33,
5477: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capital_reduction(cle.dnz_chr_id,cle.id),0),null) LINE_CAPITALIZED_REDUCTION,
5478:
5479: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
5480:
5481: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
5482: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
5483:

Line 5482: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,

5478:
5479: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_fees_capitalized(cle.dnz_chr_id,cle.id),0) TOTAL_ASSET_CAP_FEE_AMOUNT,
5480:
5481: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
5482: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
5483:
5484: decode(cle.lse_id,33,
5485: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
5486:

Line 5485: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,

5481: decode(cle.lse_id,33, NVL( kle.capitalized_interest, 0),null) LINE_CAPITALIZED_INTEREST,
5482: -- NVL(OKL_SEEDED_FUNCTIONS_PVT.line_capitalized_interest(chr.id,cle.id),0) LINE_CAPITALIZED_INTEREST,
5483:
5484: decode(cle.lse_id,33,
5485: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
5486:
5487: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
5488:
5489: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,

Line 5487: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,

5483:
5484: decode(cle.lse_id,33,
5485: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
5486:
5487: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
5488:
5489: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
5490:
5491: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,

Line 5489: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,

5485: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_discount(cle.dnz_chr_id,cle.id),0),null) LINE_DISCOUNT,
5486:
5487: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
5488:
5489: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
5490:
5491: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
5492:
5493: decode(cle.lse_id,33,

Line 5491: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,

5487: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_asset_cost(cle.dnz_chr_id,cle.id),0) LINE_ASSET_COST,
5488:
5489: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unbilled_streams(cle.dnz_chr_id,cle.id),0) LINE_UNBILLED_DUE_AMOUNT,
5490:
5491: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
5492:
5493: decode(cle.lse_id,33,
5494: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
5495:

Line 5494: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,

5490:
5491: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_oec(cle.dnz_chr_id,cle.id),0) LINE_OEC,
5492:
5493: decode(cle.lse_id,33,
5494: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
5495:
5496: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
5497:
5498: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,

Line 5496: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,

5492:
5493: decode(cle.lse_id,33,
5494: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
5495:
5496: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
5497:
5498: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
5499:
5500: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,

Line 5498: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,

5494: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_tradein(cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_TRADEIN_AMOUNT,
5495:
5496: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
5497:
5498: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
5499:
5500: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
5501:
5502: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,

Line 5500: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,

5496: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_financed_amount(cle.dnz_chr_id,cle.id),0) TOTAL_ACTIVE_LINE_FINANCED_AMT,
5497:
5498: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
5499:
5500: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
5501:
5502: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
5503:
5504: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para

Line 5502: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,

5498: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_residual_amount(cle.dnz_chr_id,cle.id),0) LINE_RESIDUAL_AMOUNT,
5499:
5500: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
5501:
5502: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
5503:
5504: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
5505:
5506: (select SUM(NVL(txd.amount,0))

Line 5504: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para

5500: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_rent_amount(cle.dnz_chr_id,cle.id),0) LINE_RENT_AMOUNT,
5501:
5502: NVL(OKL_SEEDED_FUNCTIONS_PVT.line_unearned_income (cle.dnz_chr_id,cle.id),0) LINE_UNEARNED_INCOME,
5503:
5504: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
5505:
5506: (select SUM(NVL(txd.amount,0))
5507: from OKL_TXD_AR_LN_DTLS_B txd,
5508: okl_strm_type_b sty

Line 5517: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,

5513: (select SUM(NVL(txd.amount,0))
5514: from OKL_TXD_AR_LN_DTLS_B txd
5515: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
5516:
5517: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
5518:
5519: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,
5520:
5521: --LINE_BILLED_NON_RENTS_FUNC,

Line 5519: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,

5515: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
5516:
5517: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
5518:
5519: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Rollover_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_ROLLOVER_FEE_AMT,
5520:
5521: --LINE_BILLED_NON_RENTS_FUNC,
5522: --LINE_CAP_AMOUNT,
5523: -- NET_INVESTMENT,

Line 5538: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,

5534: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
5535: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
5536:
5537: decode(cle.lse_id,33,
5538: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
5539:
5540: decode(cle.lse_id,33,
5541: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
5542:

Line 5541: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,

5537: decode(cle.lse_id,33,
5538: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
5539:
5540: decode(cle.lse_id,33,
5541: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
5542:
5543: decode(cle.lse_id,33,
5544: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,
5545:

Line 5544: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,

5540: decode(cle.lse_id,33,
5541: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_AMOUNT,
5542:
5543: decode(cle.lse_id,33,
5544: NVL(OKL_SEEDED_FUNCTIONS_PVT.get_line_subsidy_ovrd_amount (cle.dnz_chr_id,cle.id,NULL),0),null) TOTAL_ASSET_SUBSIDY_OVRD_AMT,
5545:
5546:
5547: l_last_updated_by CREATED_BY,
5548: -- -1 CREATED_BY,