eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_FUNDING_PVT

Line 822: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,

818: where txd.khr_id = khr.id
819: and txd.sty_id = sty.id
820: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
821:
822: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,

Line 823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,

819: and txd.sty_id = sty.id
820: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
821:
822: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para

Line 824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,

820: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
821:
822: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
823: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
824: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
825: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
826: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
827: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
828: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para

Line 1035: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,

1031:
1032:
1033: -- OKL_ACCOUNTING_UTIL.get_curr_con_rate(chr.CURRENCY_CODE, ledger.CURRENCY_CODE, trunc(sysdate), khr.CURRENCY_CONVERSION_TYPE) currency_convertion_rate
1034:
1035: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
1036: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
1037: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,
1038:
1039: l_last_updated_by CREATED_BY,

Line 1036: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,

1032:
1033: -- OKL_ACCOUNTING_UTIL.get_curr_con_rate(chr.CURRENCY_CODE, ledger.CURRENCY_CODE, trunc(sysdate), khr.CURRENCY_CONVERSION_TYPE) currency_convertion_rate
1034:
1035: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
1036: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
1037: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,
1038:
1039: l_last_updated_by CREATED_BY,
1040: sysdate CREATION_DATE,

Line 1037: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,

1033: -- OKL_ACCOUNTING_UTIL.get_curr_con_rate(chr.CURRENCY_CODE, ledger.CURRENCY_CODE, trunc(sysdate), khr.CURRENCY_CONVERSION_TYPE) currency_convertion_rate
1034:
1035: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
1036: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
1037: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,
1038:
1039: l_last_updated_by CREATED_BY,
1040: sysdate CREATION_DATE,
1041: l_last_updated_by LAST_UPDATED_BY,

Line 1855: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,

1851: where txd.khr_id = khr.id
1852: and txd.sty_id = sty.id
1853: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
1854:
1855: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,

Line 1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,

1852: and txd.sty_id = sty.id
1853: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
1854:
1855: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para

Line 1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,

1853: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
1854:
1855: NVL(OKL_FUNDING_PVT.get_total_retention(chr.id),0) SUPPLIER_RETENTION_FUNDING_AMT,
1856: NVL(OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(chr.id),0) ASSETS_FUNDED_AMOUNT,
1857: NVL(OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(chr.id),0) EXPENSE_FUNDED_AMOUNT,
1858: NVL(OKL_SEEDED_FUNCTIONS_PVT.FEE_IDC_AMOUNT(chr.id, null),0) CONTRACT_IDC_AMOUNT,
1859: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRIN_BALANCE(chr.id, null),0) CONTRACT_SCHEDULED_PRINC_BAL,
1860: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_INTEREST_RATE(chr.id, null),0) CONTRACT_INTEREST_RATE, -- addl para
1861: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_DAYS_TO_ACCRUE(chr.id, null),0) CONTRACT_DAYS_TO_ACCRUE, -- addl para

Line 2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,

2060: NVL(Okl_Seeded_Functions_Pvt.contract_residual_amount(chr.id, null),0) CONTRACT_RESIDUAL_AMOUNT,
2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:
2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
2065: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
2066: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,
2067:
2068: l_last_updated_by CREATED_BY,

Line 2065: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,

2061: NVL(Okl_Seeded_Functions_Pvt.contract_rent_amount(chr.id, null),0) CONTRACT_RENT_AMOUNT,
2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:
2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
2065: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
2066: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,
2067:
2068: l_last_updated_by CREATED_BY,
2069: sysdate CREATION_DATE,

Line 2066: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,

2062: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_ACC_DEPRECIATION(chr.id, null),0) CONTRACT_ACC_DEPRECIATION,
2063:
2064: NVL(OKL_FUNDING_PVT.get_amount_prefunded(chr.id),0) CONTRACT_AMOUNT_PREFUNDED,
2065: NVL(OKL_FUNDING_PVT.get_chr_funded_adjs(chr.id),0) CONTRACT_FUNDED_ADJS,
2066: NVL(OKL_FUNDING_PVT.get_amount_manu_disb(chr.id),0) CONTRACT_AMOUNT_MANU_DISB,
2067:
2068: l_last_updated_by CREATED_BY,
2069: sysdate CREATION_DATE,
2070: l_last_updated_by LAST_UPDATED_BY,