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_K_LINE_FIN_EXT_PVT dependencies on DUAL

Line 232: ASSET_RESIDUAL_PERCENT,

228: CONTRACT_LINE_DFF15,
229:
230: ASSET_DATE_DELIVERY_EXPECTED,
231: ASSET_DATE_FUNDING_EXPECTED,
232: ASSET_RESIDUAL_PERCENT,
233: ASSET_RES_GUARANTOR_TYPE_CODE,
234: ASSET_RES_GUARANTOR_TYPE,
235: ASSET_RESIDUAL_AMT_GUARANTEE,
236: ASSET_RESIDUAL_AMOUNT,

Line 235: ASSET_RESIDUAL_AMT_GUARANTEE,

231: ASSET_DATE_FUNDING_EXPECTED,
232: ASSET_RESIDUAL_PERCENT,
233: ASSET_RES_GUARANTOR_TYPE_CODE,
234: ASSET_RES_GUARANTOR_TYPE,
235: ASSET_RESIDUAL_AMT_GUARANTEE,
236: ASSET_RESIDUAL_AMOUNT,
237: CONTRACT_LINE_NAME,
238:
239: ASSET_UPFRONT_TAX,

Line 236: ASSET_RESIDUAL_AMOUNT,

232: ASSET_RESIDUAL_PERCENT,
233: ASSET_RES_GUARANTOR_TYPE_CODE,
234: ASSET_RES_GUARANTOR_TYPE,
235: ASSET_RESIDUAL_AMT_GUARANTEE,
236: ASSET_RESIDUAL_AMOUNT,
237: CONTRACT_LINE_NAME,
238:
239: ASSET_UPFRONT_TAX,
240:

Line 466: LINE_RESIDUAL_AMOUNT,

462: LINE_UNBILLED_DUE_AMOUNT,
463: LINE_OEC,
464: TOTAL_ASSET_TRADEIN_AMOUNT,
465: TOTAL_ACTIVE_LINE_FINANCED_AMT,
466: LINE_RESIDUAL_AMOUNT,
467: LINE_RENT_AMOUNT,
468: LINE_BILLED_RENTS,
469: LINE_BILLED_RENTS_FUNC,
470: LINE_BILLED_NON_RENTS,

Line 572: ASSET_RESIDUAL_PERCENT,

568: CONTRACT_LINE_DFF15,
569:
570: ASSET_DATE_DELIVERY_EXPECTED,
571: ASSET_DATE_FUNDING_EXPECTED,
572: ASSET_RESIDUAL_PERCENT,
573: ASSET_RES_GUARANTOR_TYPE_CODE,
574: ASSET_RES_GUARANTOR_TYPE,
575: ASSET_RESIDUAL_AMT_GUARANTEE,
576: ASSET_RESIDUAL_AMOUNT,

Line 575: ASSET_RESIDUAL_AMT_GUARANTEE,

571: ASSET_DATE_FUNDING_EXPECTED,
572: ASSET_RESIDUAL_PERCENT,
573: ASSET_RES_GUARANTOR_TYPE_CODE,
574: ASSET_RES_GUARANTOR_TYPE,
575: ASSET_RESIDUAL_AMT_GUARANTEE,
576: ASSET_RESIDUAL_AMOUNT,
577: CONTRACT_LINE_NAME,
578:
579: ASSET_UPFRONT_TAX,

Line 576: ASSET_RESIDUAL_AMOUNT,

572: ASSET_RESIDUAL_PERCENT,
573: ASSET_RES_GUARANTOR_TYPE_CODE,
574: ASSET_RES_GUARANTOR_TYPE,
575: ASSET_RESIDUAL_AMT_GUARANTEE,
576: ASSET_RESIDUAL_AMOUNT,
577: CONTRACT_LINE_NAME,
578:
579: ASSET_UPFRONT_TAX,
580:

Line 806: LINE_RESIDUAL_AMOUNT,

802: LINE_UNBILLED_DUE_AMOUNT,
803: LINE_OEC,
804: TOTAL_ASSET_TRADEIN_AMOUNT,
805: TOTAL_ACTIVE_LINE_FINANCED_AMT,
806: LINE_RESIDUAL_AMOUNT,
807: LINE_RENT_AMOUNT,
808: LINE_BILLED_RENTS,
809: (NVL(LINE_BILLED_RENTS,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1)) LINE_BILLED_RENTS_FUNC,
810: (NVL(LINE_TOTAL_BILLED,0) - NVL(LINE_BILLED_RENTS,0) ) LINE_BILLED_NON_RENTS,

Line 822: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),

818:
819:
820: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
821: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
822: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
823: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
824: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0),
825: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0),
826: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +

Line 823: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),

819:
820: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
821: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
822: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
823: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
824: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0),
825: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0),
826: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +
827: nvl(TOTAL_ASSET_CAP_FEE_AMOUNT,0) + nvl(LINE_CAPITALIZED_INTEREST,0) - nvl(LINE_ACCUMULATED_DEPRECIATION,0) -

Line 834: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),

830:
831:
832: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
833: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
834: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),
835: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
836: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
837: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
838: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +

Line 835: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),

831:
832: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
833: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
834: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),
835: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
836: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
837: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
838: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +
839: nvl(TOTAL_ASSET_CAP_FEE_AMOUNT,0) + nvl(LINE_CAPITALIZED_INTEREST,0) - nvl(LINE_ACCUMULATED_DEPRECIATION,0) -

Line 942: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,

938: kle.ATTRIBUTE15 CONTRACT_LINE_DFF15,
939:
940: kle.DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED,
941: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
942: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
943: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
944: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
945: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
946: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

Line 943: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,

939:
940: kle.DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED,
941: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
942: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
943: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
944: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
945: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
946: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
947: cle_TL.NAME CONTRACT_LINE_NAME,

Line 945: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,

941: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
942: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
943: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
944: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
945: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
946: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
947: cle_TL.NAME CONTRACT_LINE_NAME,
948:
949: decode(cle.lse_id, 33,(select SUM(NVL(txs.total_tax,0))

Line 946: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

942: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
943: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
944: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
945: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
946: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
947: cle_TL.NAME CONTRACT_LINE_NAME,
948:
949: decode(cle.lse_id, 33,(select SUM(NVL(txs.total_tax,0))
950: from okl_tax_sources txs

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 2137: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'

2133:
2134: AND cle_status_tl.code = cle.sts_code
2135: AND cle_status_tl.language = USERENV('LANG')
2136:
2137: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'
2138: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE
2139:
2140: AND sales_tax.cle_id (+) = cle.id
2141: AND sales_tax.dnz_chr_id (+) = cle.dnz_chr_id

Line 2138: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE

2134: AND cle_status_tl.code = cle.sts_code
2135: AND cle_status_tl.language = USERENV('LANG')
2136:
2137: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'
2138: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE
2139:
2140: AND sales_tax.cle_id (+) = cle.id
2141: AND sales_tax.dnz_chr_id (+) = cle.dnz_chr_id
2142:

Line 2361: ASSET_RESIDUAL_PERCENT,

2357: CONTRACT_LINE_DFF15,
2358:
2359: ASSET_DATE_DELIVERY_EXPECTED,
2360: ASSET_DATE_FUNDING_EXPECTED,
2361: ASSET_RESIDUAL_PERCENT,
2362: ASSET_RES_GUARANTOR_TYPE_CODE,
2363: ASSET_RES_GUARANTOR_TYPE,
2364: ASSET_RESIDUAL_AMT_GUARANTEE,
2365: ASSET_RESIDUAL_AMOUNT,

Line 2364: ASSET_RESIDUAL_AMT_GUARANTEE,

2360: ASSET_DATE_FUNDING_EXPECTED,
2361: ASSET_RESIDUAL_PERCENT,
2362: ASSET_RES_GUARANTOR_TYPE_CODE,
2363: ASSET_RES_GUARANTOR_TYPE,
2364: ASSET_RESIDUAL_AMT_GUARANTEE,
2365: ASSET_RESIDUAL_AMOUNT,
2366: CONTRACT_LINE_NAME,
2367:
2368: ASSET_UPFRONT_TAX,

Line 2365: ASSET_RESIDUAL_AMOUNT,

2361: ASSET_RESIDUAL_PERCENT,
2362: ASSET_RES_GUARANTOR_TYPE_CODE,
2363: ASSET_RES_GUARANTOR_TYPE,
2364: ASSET_RESIDUAL_AMT_GUARANTEE,
2365: ASSET_RESIDUAL_AMOUNT,
2366: CONTRACT_LINE_NAME,
2367:
2368: ASSET_UPFRONT_TAX,
2369:

Line 2595: LINE_RESIDUAL_AMOUNT,

2591: LINE_UNBILLED_DUE_AMOUNT,
2592: LINE_OEC,
2593: TOTAL_ASSET_TRADEIN_AMOUNT,
2594: TOTAL_ACTIVE_LINE_FINANCED_AMT,
2595: LINE_RESIDUAL_AMOUNT,
2596: LINE_RENT_AMOUNT,
2597: LINE_BILLED_RENTS,
2598: LINE_BILLED_RENTS_FUNC,
2599: LINE_BILLED_NON_RENTS,

Line 2701: ASSET_RESIDUAL_PERCENT,

2697: CONTRACT_LINE_DFF15,
2698:
2699: ASSET_DATE_DELIVERY_EXPECTED,
2700: ASSET_DATE_FUNDING_EXPECTED,
2701: ASSET_RESIDUAL_PERCENT,
2702: ASSET_RES_GUARANTOR_TYPE_CODE,
2703: ASSET_RES_GUARANTOR_TYPE,
2704: ASSET_RESIDUAL_AMT_GUARANTEE,
2705: ASSET_RESIDUAL_AMOUNT,

Line 2704: ASSET_RESIDUAL_AMT_GUARANTEE,

2700: ASSET_DATE_FUNDING_EXPECTED,
2701: ASSET_RESIDUAL_PERCENT,
2702: ASSET_RES_GUARANTOR_TYPE_CODE,
2703: ASSET_RES_GUARANTOR_TYPE,
2704: ASSET_RESIDUAL_AMT_GUARANTEE,
2705: ASSET_RESIDUAL_AMOUNT,
2706: CONTRACT_LINE_NAME,
2707:
2708: ASSET_UPFRONT_TAX,

Line 2705: ASSET_RESIDUAL_AMOUNT,

2701: ASSET_RESIDUAL_PERCENT,
2702: ASSET_RES_GUARANTOR_TYPE_CODE,
2703: ASSET_RES_GUARANTOR_TYPE,
2704: ASSET_RESIDUAL_AMT_GUARANTEE,
2705: ASSET_RESIDUAL_AMOUNT,
2706: CONTRACT_LINE_NAME,
2707:
2708: ASSET_UPFRONT_TAX,
2709:

Line 2935: LINE_RESIDUAL_AMOUNT,

2931: LINE_UNBILLED_DUE_AMOUNT,
2932: LINE_OEC,
2933: TOTAL_ASSET_TRADEIN_AMOUNT,
2934: TOTAL_ACTIVE_LINE_FINANCED_AMT,
2935: LINE_RESIDUAL_AMOUNT,
2936: LINE_RENT_AMOUNT,
2937: LINE_BILLED_RENTS,
2938: (NVL(LINE_BILLED_RENTS,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1)) LINE_BILLED_RENTS_FUNC,
2939: (NVL(LINE_TOTAL_BILLED,0) - NVL(LINE_BILLED_RENTS,0) ) LINE_BILLED_NON_RENTS,

Line 2951: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),

2947:
2948:
2949: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
2950: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
2951: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
2952: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
2953: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0),
2954: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0),
2955: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +

Line 2952: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),

2948:
2949: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
2950: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
2951: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
2952: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
2953: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0),
2954: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0),
2955: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +
2956: nvl(TOTAL_ASSET_CAP_FEE_AMOUNT,0) + nvl(LINE_CAPITALIZED_INTEREST,0) - nvl(LINE_ACCUMULATED_DEPRECIATION,0) -

Line 2963: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),

2959:
2960:
2961: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
2962: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
2963: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2964: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2965: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2966: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2967: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +

Line 2964: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),

2960:
2961: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
2962: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
2963: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2964: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2965: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2966: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
2967: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +
2968: nvl(TOTAL_ASSET_CAP_FEE_AMOUNT,0) + nvl(LINE_CAPITALIZED_INTEREST,0) - nvl(LINE_ACCUMULATED_DEPRECIATION,0) -

Line 3071: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,

3067: kle.ATTRIBUTE15 CONTRACT_LINE_DFF15,
3068:
3069: kle.DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED,
3070: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
3071: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
3072: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
3073: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
3074: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
3075: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

Line 3072: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,

3068:
3069: kle.DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED,
3070: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
3071: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
3072: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
3073: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
3074: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
3075: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
3076: cle_TL.NAME CONTRACT_LINE_NAME,

Line 3074: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,

3070: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
3071: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
3072: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
3073: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
3074: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
3075: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
3076: cle_TL.NAME CONTRACT_LINE_NAME,
3077:
3078: decode(cle.lse_id, 33,(select SUM(NVL(txs.total_tax,0))

Line 3075: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

3071: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
3072: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
3073: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
3074: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
3075: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
3076: cle_TL.NAME CONTRACT_LINE_NAME,
3077:
3078: decode(cle.lse_id, 33,(select SUM(NVL(txs.total_tax,0))
3079: from okl_tax_sources txs

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 4198: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'

4194:
4195: AND cle_status_tl.code = cle.sts_code
4196: AND cle_status_tl.language = USERENV('LANG')
4197:
4198: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'
4199: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE
4200:
4201: AND sales_tax.cle_id (+) = cle.id
4202:

Line 4199: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE

4195: AND cle_status_tl.code = cle.sts_code
4196: AND cle_status_tl.language = USERENV('LANG')
4197:
4198: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'
4199: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE
4200:
4201: AND sales_tax.cle_id (+) = cle.id
4202:
4203: AND property_tax.cle_id (+) = cle.id

Line 4420: ASSET_RESIDUAL_PERCENT,

4416: CONTRACT_LINE_DFF15,
4417:
4418: ASSET_DATE_DELIVERY_EXPECTED,
4419: ASSET_DATE_FUNDING_EXPECTED,
4420: ASSET_RESIDUAL_PERCENT,
4421: ASSET_RES_GUARANTOR_TYPE_CODE,
4422: ASSET_RES_GUARANTOR_TYPE,
4423: ASSET_RESIDUAL_AMT_GUARANTEE,
4424: ASSET_RESIDUAL_AMOUNT,

Line 4423: ASSET_RESIDUAL_AMT_GUARANTEE,

4419: ASSET_DATE_FUNDING_EXPECTED,
4420: ASSET_RESIDUAL_PERCENT,
4421: ASSET_RES_GUARANTOR_TYPE_CODE,
4422: ASSET_RES_GUARANTOR_TYPE,
4423: ASSET_RESIDUAL_AMT_GUARANTEE,
4424: ASSET_RESIDUAL_AMOUNT,
4425: CONTRACT_LINE_NAME,
4426:
4427: ASSET_UPFRONT_TAX,

Line 4424: ASSET_RESIDUAL_AMOUNT,

4420: ASSET_RESIDUAL_PERCENT,
4421: ASSET_RES_GUARANTOR_TYPE_CODE,
4422: ASSET_RES_GUARANTOR_TYPE,
4423: ASSET_RESIDUAL_AMT_GUARANTEE,
4424: ASSET_RESIDUAL_AMOUNT,
4425: CONTRACT_LINE_NAME,
4426:
4427: ASSET_UPFRONT_TAX,
4428:

Line 4654: LINE_RESIDUAL_AMOUNT,

4650: LINE_UNBILLED_DUE_AMOUNT,
4651: LINE_OEC,
4652: TOTAL_ASSET_TRADEIN_AMOUNT,
4653: TOTAL_ACTIVE_LINE_FINANCED_AMT,
4654: LINE_RESIDUAL_AMOUNT,
4655: LINE_RENT_AMOUNT,
4656: LINE_BILLED_RENTS,
4657: LINE_BILLED_RENTS_FUNC,
4658: LINE_BILLED_NON_RENTS,

Line 4760: ASSET_RESIDUAL_PERCENT,

4756: CONTRACT_LINE_DFF15,
4757:
4758: ASSET_DATE_DELIVERY_EXPECTED,
4759: ASSET_DATE_FUNDING_EXPECTED,
4760: ASSET_RESIDUAL_PERCENT,
4761: ASSET_RES_GUARANTOR_TYPE_CODE,
4762: ASSET_RES_GUARANTOR_TYPE,
4763: ASSET_RESIDUAL_AMT_GUARANTEE,
4764: ASSET_RESIDUAL_AMOUNT,

Line 4763: ASSET_RESIDUAL_AMT_GUARANTEE,

4759: ASSET_DATE_FUNDING_EXPECTED,
4760: ASSET_RESIDUAL_PERCENT,
4761: ASSET_RES_GUARANTOR_TYPE_CODE,
4762: ASSET_RES_GUARANTOR_TYPE,
4763: ASSET_RESIDUAL_AMT_GUARANTEE,
4764: ASSET_RESIDUAL_AMOUNT,
4765: CONTRACT_LINE_NAME,
4766:
4767: ASSET_UPFRONT_TAX,

Line 4764: ASSET_RESIDUAL_AMOUNT,

4760: ASSET_RESIDUAL_PERCENT,
4761: ASSET_RES_GUARANTOR_TYPE_CODE,
4762: ASSET_RES_GUARANTOR_TYPE,
4763: ASSET_RESIDUAL_AMT_GUARANTEE,
4764: ASSET_RESIDUAL_AMOUNT,
4765: CONTRACT_LINE_NAME,
4766:
4767: ASSET_UPFRONT_TAX,
4768:

Line 4994: LINE_RESIDUAL_AMOUNT,

4990: LINE_UNBILLED_DUE_AMOUNT,
4991: LINE_OEC,
4992: TOTAL_ASSET_TRADEIN_AMOUNT,
4993: TOTAL_ACTIVE_LINE_FINANCED_AMT,
4994: LINE_RESIDUAL_AMOUNT,
4995: LINE_RENT_AMOUNT,
4996: LINE_BILLED_RENTS,
4997: (NVL(LINE_BILLED_RENTS,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1)) LINE_BILLED_RENTS_FUNC,
4998: (NVL(LINE_TOTAL_BILLED,0) - NVL(LINE_BILLED_RENTS,0) ) LINE_BILLED_NON_RENTS,

Line 5010: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),

5006:
5007:
5008: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
5009: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
5010: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
5011: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
5012: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0),
5013: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0),
5014: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +

Line 5011: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),

5007:
5008: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
5009: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
5010: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
5011: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)),
5012: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0),
5013: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0),
5014: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +
5015: nvl(TOTAL_ASSET_CAP_FEE_AMOUNT,0) + nvl(LINE_CAPITALIZED_INTEREST,0) - nvl(LINE_ACCUMULATED_DEPRECIATION,0) -

Line 5022: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),

5018:
5019:
5020: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
5021: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
5022: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5023: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5024: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5025: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5026: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +

Line 5023: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),

5019:
5020: NVL(DECODE(CONTRACT_STATUS_CODE, 'EXPIRED',0,
5021: (DECODE(CONTRACT_BOOK_CLASS_CODE, 'LEASEDF',
5022: (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0))* nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5023: 'LEASEST', (nvl(LINE_RENT_AMOUNT,0) + nvl(LINE_RESIDUAL_AMOUNT,0) - nvl(LINE_UNEARNED_INCOME,0)) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5024: 'LOAN', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5025: 'LOAN-REVOLVING', nvl(LINE_PRINCIPAL_BALANCE,0) * nvl(CONTRACT_CURRENCY_CONV_RATE,1),
5026: 'LEASEOP', (nvl(LINE_OEC,0) - nvl(TOTAL_ASSET_TRADEIN_AMOUNT,0) - nvl(LINE_CAPITALIZED_REDUCTION,0) +
5027: nvl(TOTAL_ASSET_CAP_FEE_AMOUNT,0) + nvl(LINE_CAPITALIZED_INTEREST,0) - nvl(LINE_ACCUMULATED_DEPRECIATION,0) -

Line 5130: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,

5126: kle.ATTRIBUTE15 CONTRACT_LINE_DFF15,
5127:
5128: kle.DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED,
5129: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
5130: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
5131: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
5132: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
5133: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
5134: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

Line 5131: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,

5127:
5128: kle.DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED,
5129: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
5130: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
5131: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
5132: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
5133: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
5134: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
5135: cle_TL.NAME CONTRACT_LINE_NAME,

Line 5133: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,

5129: kle.DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED,
5130: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
5131: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
5132: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
5133: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
5134: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
5135: cle_TL.NAME CONTRACT_LINE_NAME,
5136:
5137: decode(cle.lse_id, 33,(select SUM(NVL(txs.total_tax,0))

Line 5134: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

5130: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,
5131: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,
5132: lookup_res_guarantor.meaning ASSET_RES_GUARANTOR_TYPE,
5133: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,
5134: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,
5135: cle_TL.NAME CONTRACT_LINE_NAME,
5136:
5137: decode(cle.lse_id, 33,(select SUM(NVL(txs.total_tax,0))
5138: from okl_tax_sources txs

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 6113: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'

6109:
6110: AND cle_status_tl.code = cle.sts_code
6111: AND cle_status_tl.language = USERENV('LANG')
6112:
6113: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'
6114: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE
6115:
6116: AND sales_tax.cle_id (+) = cle.id
6117:

Line 6114: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE

6110: AND cle_status_tl.code = cle.sts_code
6111: AND cle_status_tl.language = USERENV('LANG')
6112:
6113: AND lookup_res_guarantor.lookup_type (+) = 'OKL_RESIDUAL_CODE'
6114: AND lookup_res_guarantor.lookup_code (+) = kle.RESIDUAL_CODE
6115:
6116: AND sales_tax.cle_id (+) = cle.id
6117:
6118: AND property_tax.cle_id (+) = cle.id

Line 6360: FROM dual;

6356:
6357: CURSOR req_id_csr IS
6358: SELECT
6359: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
6360: FROM dual;
6361:
6362: ------------------------------------------------------------
6363: -- Operating Unit
6364: ------------------------------------------------------------