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_OPEN_INTERFACE_PVT dependencies on OKC_K_LINES_B

Line 1849: OKC_K_LINES_B CLEB_FA,

1845: AND EXISTS ( SELECT fa.asset_id
1846: FROM FA_ADDITIONS_B FA,
1847: OKL_ASSET_RETURNS_B OAR,
1848: OKC_K_ITEMS CIM_FA,
1849: OKC_K_LINES_B CLEB_FA,
1850: OKC_K_LINES_B CLEB_TL,
1851: OKC_K_HEADERS_B CHRB
1852: WHERE cleb_tl.chr_id = chrb.id
1853: AND chrb.inv_organization_id = p_org_id

Line 1850: OKC_K_LINES_B CLEB_TL,

1846: FROM FA_ADDITIONS_B FA,
1847: OKL_ASSET_RETURNS_B OAR,
1848: OKC_K_ITEMS CIM_FA,
1849: OKC_K_LINES_B CLEB_FA,
1850: OKC_K_LINES_B CLEB_TL,
1851: OKC_K_HEADERS_B CHRB
1852: WHERE cleb_tl.chr_id = chrb.id
1853: AND chrb.inv_organization_id = p_org_id
1854: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID

Line 1868: okc_k_lines_b cleb_2,

1864: AND oli.asset_number = p_asset_number -- Bug #15992711: Add extra condition to fetch the record pertaining to asset number
1865: AND not exists (SELECT '1'
1866: FROM okc_k_headers_b chrb_2,
1867: okc_statuses_b chr_sts,
1868: okc_k_lines_b cleb_2,
1869: okc_statuses_b cle_sts,
1870: okc_k_items cim_2
1871: WHERE chrb_2.id = cleb_2.dnz_chr_id
1872: AND chrb_2.scs_code in ('LEASE','LOAN')

Line 1896: OKC_K_LINES_B CLEB_FA,

1892: AND NOT EXISTS (SELECT fa.asset_id
1893: FROM FA_ADDITIONS_B FA,
1894: OKL_ASSET_RETURNS_B OAR,
1895: OKC_K_ITEMS CIM_FA,
1896: OKC_K_LINES_B CLEB_FA,
1897: OKC_K_LINES_B CLEB_TL,
1898: OKC_K_HEADERS_B CHRB
1899: WHERE cleb_tl.chr_id = chrb.id
1900: AND chrb.inv_organization_id = p_org_id

Line 1897: OKC_K_LINES_B CLEB_TL,

1893: FROM FA_ADDITIONS_B FA,
1894: OKL_ASSET_RETURNS_B OAR,
1895: OKC_K_ITEMS CIM_FA,
1896: OKC_K_LINES_B CLEB_FA,
1897: OKC_K_LINES_B CLEB_TL,
1898: OKC_K_HEADERS_B CHRB
1899: WHERE cleb_tl.chr_id = chrb.id
1900: AND chrb.inv_organization_id = p_org_id
1901: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID

Line 23878: p_line_id IN okc_k_lines_b.id%TYPE,

23874: x_return_status OUT NOCOPY VARCHAR2,
23875: x_msg_count OUT NOCOPY NUMBER,
23876: x_msg_data OUT NOCOPY VARCHAR2,
23877: p_contract_id IN okc_k_headers_b.id%TYPE,
23878: p_line_id IN okc_k_lines_b.id%TYPE,
23879: p_line_type IN okl_lines_interface.line_type%TYPE,
23880: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23881: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23882: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,