APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 1364: from OKL_TXD_AR_LN_DTLS_B txd,

1360:
1361: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
1362:
1363: (select SUM(NVL(txd.amount,0))
1364: from OKL_TXD_AR_LN_DTLS_B txd,
1365: okl_strm_type_b sty
1366: where txd.kle_id = kle.id
1367: and txd.sty_id = sty.id
1368: and sty.STREAM_TYPE_PURPOSE = 'RENT') LINE_BILLED_RENTS,

Line 1371: from OKL_TXD_AR_LN_DTLS_B txd

1367: and txd.sty_id = sty.id
1368: and sty.STREAM_TYPE_PURPOSE = 'RENT') LINE_BILLED_RENTS,
1369:
1370: (select SUM(NVL(txd.amount,0))
1371: from OKL_TXD_AR_LN_DTLS_B txd
1372: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
1373:
1374: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
1375:

Line 3481: from OKL_TXD_AR_LN_DTLS_B txd,

3477:
3478: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
3479:
3480: (select SUM(NVL(txd.amount,0))
3481: from OKL_TXD_AR_LN_DTLS_B txd,
3482: okl_strm_type_b sty
3483: where txd.kle_id = kle.id
3484: and txd.sty_id = sty.id
3485: and sty.STREAM_TYPE_PURPOSE = 'RENT') LINE_BILLED_RENTS,

Line 3488: from OKL_TXD_AR_LN_DTLS_B txd

3484: and txd.sty_id = sty.id
3485: and sty.STREAM_TYPE_PURPOSE = 'RENT') LINE_BILLED_RENTS,
3486:
3487: (select SUM(NVL(txd.amount,0))
3488: from OKL_TXD_AR_LN_DTLS_B txd
3489: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
3490:
3491: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
3492:

Line 5507: from OKL_TXD_AR_LN_DTLS_B txd,

5503:
5504: NVL(OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE(cle.dnz_chr_id, cle.id),0) LINE_PRINCIPAL_BALANCE, -- addl para
5505:
5506: (select SUM(NVL(txd.amount,0))
5507: from OKL_TXD_AR_LN_DTLS_B txd,
5508: okl_strm_type_b sty
5509: where txd.kle_id = kle.id
5510: and txd.sty_id = sty.id
5511: and sty.STREAM_TYPE_PURPOSE = 'RENT') LINE_BILLED_RENTS,

Line 5514: from OKL_TXD_AR_LN_DTLS_B txd

5510: and txd.sty_id = sty.id
5511: and sty.STREAM_TYPE_PURPOSE = 'RENT') LINE_BILLED_RENTS,
5512:
5513: (select SUM(NVL(txd.amount,0))
5514: from OKL_TXD_AR_LN_DTLS_B txd
5515: where txd.kle_id = kle.id ) LINE_TOTAL_BILLED,
5516:
5517: NVL(OKL_SEEDED_FUNCTIONS_PVT.Total_Asset_Financed_Fee_Amt(cle.dnz_chr_id, cle.id),0) TOTAL_ASSET_FINANCED_FEE_AMT,
5518: