APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 802: from OKL_TXD_AR_LN_DTLS_B txd,

798: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
799: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
800: -- null CONTRACT_BILLED_RENTS,
801: (select SUM(NVL(txd.amount,0))
802: from OKL_TXD_AR_LN_DTLS_B txd,
803: okl_strm_type_b sty
804: where txd.khr_id = khr.id
805: and txd.sty_id = sty.id
806: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,

Line 995: from OKL_TXD_AR_LN_DTLS_B txd

991:
992: null CONTRACT_TOT_PAST_DUE_AMT,
993: -- null CONTRACT_TOT_BILLED_RECEIVABLE,
994: (select SUM(NVL(txd.amount,0))
995: from OKL_TXD_AR_LN_DTLS_B txd
996: where txd.khr_id = khr.id ) CONTRACT_TOT_BILLED_RECEIVABLE,
997:
998: /*
999: -- for Net Investment

Line 1835: from OKL_TXD_AR_LN_DTLS_B txd,

1831: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1833: -- null CONTRACT_BILLED_RENTS,
1834: (select SUM(NVL(txd.amount,0))
1835: from OKL_TXD_AR_LN_DTLS_B txd,
1836: okl_strm_type_b sty
1837: where txd.khr_id = khr.id
1838: and txd.sty_id = sty.id
1839: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,

Line 2027: from OKL_TXD_AR_LN_DTLS_B txd

2023:
2024: null CONTRACT_TOT_PAST_DUE_AMT,
2025: -- null CONTRACT_TOT_BILLED_RECEIVABLE,
2026: (select SUM(NVL(txd.amount,0))
2027: from OKL_TXD_AR_LN_DTLS_B txd
2028: where txd.khr_id = khr.id ) CONTRACT_TOT_BILLED_RECEIVABLE,
2029:
2030: /*
2031: -- for Net Investment