APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_SEEDED_FUNCTIONS_PVT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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