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 233: ASSET_RESIDUAL_PERCENT,

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

Line 236: ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 237: ASSET_RESIDUAL_AMOUNT,

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

Line 467: LINE_RESIDUAL_AMOUNT,

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

Line 573: ASSET_RESIDUAL_PERCENT,

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

Line 576: ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 577: ASSET_RESIDUAL_AMOUNT,

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

Line 807: LINE_RESIDUAL_AMOUNT,

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

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

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

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

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

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

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

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

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

Line 943: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,

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

Line 944: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,

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

Line 946: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 947: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

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

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

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

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

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

Line 2362: ASSET_RESIDUAL_PERCENT,

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

Line 2365: ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 2366: ASSET_RESIDUAL_AMOUNT,

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

Line 2596: LINE_RESIDUAL_AMOUNT,

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

Line 2702: ASSET_RESIDUAL_PERCENT,

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

Line 2705: ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 2706: ASSET_RESIDUAL_AMOUNT,

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

Line 2936: LINE_RESIDUAL_AMOUNT,

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

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

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

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

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

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

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

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

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

Line 3072: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,

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

Line 3073: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,

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

Line 3075: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 3076: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

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

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

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

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

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

Line 4421: ASSET_RESIDUAL_PERCENT,

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

Line 4424: ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 4425: ASSET_RESIDUAL_AMOUNT,

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

Line 4655: LINE_RESIDUAL_AMOUNT,

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

Line 4761: ASSET_RESIDUAL_PERCENT,

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

Line 4764: ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 4765: ASSET_RESIDUAL_AMOUNT,

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

Line 4995: LINE_RESIDUAL_AMOUNT,

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

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

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

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

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

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

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

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

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

Line 5131: kle.RESIDUAL_PERCENTAGE ASSET_RESIDUAL_PERCENT,

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

Line 5132: kle.RESIDUAL_CODE ASSET_RES_GUARANTOR_TYPE_CODE,

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

Line 5134: kle.RESIDUAL_GRNTY_AMOUNT ASSET_RESIDUAL_AMT_GUARANTEE,

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

Line 5135: kle.RESIDUAL_VALUE ASSET_RESIDUAL_AMOUNT,

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

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

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

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

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

Line 6361: FROM dual;

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