APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 1363: from OKL_TXD_AR_LN_DTLS_B txd,

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

Line 1370: from OKL_TXD_AR_LN_DTLS_B txd

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

Line 3480: from OKL_TXD_AR_LN_DTLS_B txd,

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

Line 3487: from OKL_TXD_AR_LN_DTLS_B txd

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

Line 5506: from OKL_TXD_AR_LN_DTLS_B txd,

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

Line 5513: from OKL_TXD_AR_LN_DTLS_B txd

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