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_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_K_LINES

Line 2427: FROM okl_k_lines_full_v kle,

2423: p_asset_number IN VARCHAR2
2424: )
2425: IS
2426: SELECT 'Y' a
2427: FROM okl_k_lines_full_v kle,
2428: okc_line_styles_b lse
2429: WHERE kle.NAME = p_asset_number
2430: AND kle.lse_id = lse.ID
2431: AND lse.lty_code = 'FIXED_ASSET';

Line 3970: FROM okl_k_lines okl

3966: attribute12,
3967: attribute13,
3968: attribute14,
3969: attribute15
3970: FROM okl_k_lines okl
3971: WHERE okl.ID = p_kle_id;
3972:
3973: --record for storing okl_k_lines dffs and linked assets cle_id
3974: TYPE dff_rec_type IS RECORD (

Line 3973: --record for storing okl_k_lines dffs and linked assets cle_id

3969: attribute15
3970: FROM okl_k_lines okl
3971: WHERE okl.ID = p_kle_id;
3972:
3973: --record for storing okl_k_lines dffs and linked assets cle_id
3974: TYPE dff_rec_type IS RECORD (
3975: attribute_category okl_k_lines.attribute_category%TYPE,
3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,

Line 3975: attribute_category okl_k_lines.attribute_category%TYPE,

3971: WHERE okl.ID = p_kle_id;
3972:
3973: --record for storing okl_k_lines dffs and linked assets cle_id
3974: TYPE dff_rec_type IS RECORD (
3975: attribute_category okl_k_lines.attribute_category%TYPE,
3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,

Line 3976: attribute1 okl_k_lines.attribute1%TYPE,

3972:
3973: --record for storing okl_k_lines dffs and linked assets cle_id
3974: TYPE dff_rec_type IS RECORD (
3975: attribute_category okl_k_lines.attribute_category%TYPE,
3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,

Line 3977: attribute2 okl_k_lines.attribute2%TYPE,

3973: --record for storing okl_k_lines dffs and linked assets cle_id
3974: TYPE dff_rec_type IS RECORD (
3975: attribute_category okl_k_lines.attribute_category%TYPE,
3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,

Line 3978: attribute3 okl_k_lines.attribute3%TYPE,

3974: TYPE dff_rec_type IS RECORD (
3975: attribute_category okl_k_lines.attribute_category%TYPE,
3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,

Line 3979: attribute4 okl_k_lines.attribute4%TYPE,

3975: attribute_category okl_k_lines.attribute_category%TYPE,
3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,

Line 3980: attribute5 okl_k_lines.attribute5%TYPE,

3976: attribute1 okl_k_lines.attribute1%TYPE,
3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,

Line 3981: attribute6 okl_k_lines.attribute6%TYPE,

3977: attribute2 okl_k_lines.attribute2%TYPE,
3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,

Line 3982: attribute7 okl_k_lines.attribute7%TYPE,

3978: attribute3 okl_k_lines.attribute3%TYPE,
3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,

Line 3983: attribute8 okl_k_lines.attribute8%TYPE,

3979: attribute4 okl_k_lines.attribute4%TYPE,
3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,

Line 3984: attribute9 okl_k_lines.attribute9%TYPE,

3980: attribute5 okl_k_lines.attribute5%TYPE,
3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,

Line 3985: attribute10 okl_k_lines.attribute10%TYPE,

3981: attribute6 okl_k_lines.attribute6%TYPE,
3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,
3989: attribute14 okl_k_lines.attribute14%TYPE,

Line 3986: attribute11 okl_k_lines.attribute11%TYPE,

3982: attribute7 okl_k_lines.attribute7%TYPE,
3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,
3989: attribute14 okl_k_lines.attribute14%TYPE,
3990: attribute15 okl_k_lines.attribute15%TYPE

Line 3987: attribute12 okl_k_lines.attribute12%TYPE,

3983: attribute8 okl_k_lines.attribute8%TYPE,
3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,
3989: attribute14 okl_k_lines.attribute14%TYPE,
3990: attribute15 okl_k_lines.attribute15%TYPE
3991: );

Line 3988: attribute13 okl_k_lines.attribute13%TYPE,

3984: attribute9 okl_k_lines.attribute9%TYPE,
3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,
3989: attribute14 okl_k_lines.attribute14%TYPE,
3990: attribute15 okl_k_lines.attribute15%TYPE
3991: );
3992:

Line 3989: attribute14 okl_k_lines.attribute14%TYPE,

3985: attribute10 okl_k_lines.attribute10%TYPE,
3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,
3989: attribute14 okl_k_lines.attribute14%TYPE,
3990: attribute15 okl_k_lines.attribute15%TYPE
3991: );
3992:
3993: txl_contracts_dff_rec dff_rec_type;

Line 3990: attribute15 okl_k_lines.attribute15%TYPE

3986: attribute11 okl_k_lines.attribute11%TYPE,
3987: attribute12 okl_k_lines.attribute12%TYPE,
3988: attribute13 okl_k_lines.attribute13%TYPE,
3989: attribute14 okl_k_lines.attribute14%TYPE,
3990: attribute15 okl_k_lines.attribute15%TYPE
3991: );
3992:
3993: txl_contracts_dff_rec dff_rec_type;
3994:

Line 7983: FROM okl_k_lines_v kle,

7979: IS
7980: SELECT cle.ID ID,
7981: cle.NAME NAME,
7982: kle.residual_value residual_value
7983: FROM okl_k_lines_v kle,
7984: okc_k_lines_v cle,
7985: okc_k_headers_v khr
7986: WHERE cle.chr_id = p_khr_id
7987: AND cle.chr_id = khr.ID

Line 11163: -- : rmunjulu LOANS_ENHANCEMENTS get and set termination value in okl_K_lines and okl_contract_balances

11159: -- Changed SLL rule to LASLL
11160: -- : SECHAWLA 28-OCT-03 2846988 Update payments on quote acceptance
11161: -- Added a call to update_payments procedure
11162: -- : rmunjulu EDAT Added code for effective dated terminations
11163: -- : rmunjulu LOANS_ENHANCEMENTS get and set termination value in okl_K_lines and okl_contract_balances
11164: -- End of Comments
11165: PROCEDURE update_lines (
11166: p_api_version IN NUMBER,
11167: p_init_msg_list IN VARCHAR2,

Line 11263: okl_k_lines kle,

11259: IS
11260: SELECT SUM (kle.capital_amount) amount,
11261: cle.cle_id cle_id
11262: FROM okc_k_lines_b cle,
11263: okl_k_lines kle,
11264: okc_line_styles_b lse
11265: WHERE kle.ID = cle.ID
11266: AND cle.dnz_chr_id = p_chr_id
11267: AND cle.lse_id = lse.ID

Line 11283: okl_k_lines kle,

11279: IS
11280: SELECT SUM (kle.capital_amount) amount,
11281: cle.cle_id cle_id
11282: FROM okc_k_lines_b cle,
11283: okl_k_lines kle,
11284: okc_line_styles_b lse
11285: WHERE kle.ID = cle.ID
11286: AND cle.dnz_chr_id = p_chr_id
11287: AND cle.lse_id = lse.ID