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 1844: OKC_K_LINES_B CLEB_FA,

1840: AND EXISTS ( SELECT fa.asset_id
1841: FROM FA_ADDITIONS_B FA,
1842: OKL_ASSET_RETURNS_B OAR,
1843: OKC_K_ITEMS CIM_FA,
1844: OKC_K_LINES_B CLEB_FA,
1845: OKC_K_LINES_B CLEB_TL,
1846: OKC_K_HEADERS_B CHRB
1847: WHERE cleb_tl.chr_id = chrb.id
1848: AND chrb.inv_organization_id = p_org_id

Line 1845: OKC_K_LINES_B CLEB_TL,

1841: FROM FA_ADDITIONS_B FA,
1842: OKL_ASSET_RETURNS_B OAR,
1843: OKC_K_ITEMS CIM_FA,
1844: OKC_K_LINES_B CLEB_FA,
1845: OKC_K_LINES_B CLEB_TL,
1846: OKC_K_HEADERS_B CHRB
1847: WHERE cleb_tl.chr_id = chrb.id
1848: AND chrb.inv_organization_id = p_org_id
1849: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID

Line 1862: okc_k_lines_b cleb_2,

1858: AND fa.asset_number = oli.asset_number
1859: AND not exists (SELECT '1'
1860: FROM okc_k_headers_b chrb_2,
1861: okc_statuses_b chr_sts,
1862: okc_k_lines_b cleb_2,
1863: okc_statuses_b cle_sts,
1864: okc_k_items cim_2
1865: WHERE chrb_2.id = cleb_2.dnz_chr_id
1866: AND chrb_2.scs_code in ('LEASE','LOAN')

Line 1890: OKC_K_LINES_B CLEB_FA,

1886: AND NOT EXISTS (SELECT fa.asset_id
1887: FROM FA_ADDITIONS_B FA,
1888: OKL_ASSET_RETURNS_B OAR,
1889: OKC_K_ITEMS CIM_FA,
1890: OKC_K_LINES_B CLEB_FA,
1891: OKC_K_LINES_B CLEB_TL,
1892: OKC_K_HEADERS_B CHRB
1893: WHERE cleb_tl.chr_id = chrb.id
1894: AND chrb.inv_organization_id = p_org_id

Line 1891: OKC_K_LINES_B CLEB_TL,

1887: FROM FA_ADDITIONS_B FA,
1888: OKL_ASSET_RETURNS_B OAR,
1889: OKC_K_ITEMS CIM_FA,
1890: OKC_K_LINES_B CLEB_FA,
1891: OKC_K_LINES_B CLEB_TL,
1892: OKC_K_HEADERS_B CHRB
1893: WHERE cleb_tl.chr_id = chrb.id
1894: AND chrb.inv_organization_id = p_org_id
1895: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID

Line 23689: p_line_id IN okc_k_lines_b.id%TYPE,

23685: x_return_status OUT NOCOPY VARCHAR2,
23686: x_msg_count OUT NOCOPY NUMBER,
23687: x_msg_data OUT NOCOPY VARCHAR2,
23688: p_contract_id IN okc_k_headers_b.id%TYPE,
23689: p_line_id IN okc_k_lines_b.id%TYPE,
23690: p_line_type IN okl_lines_interface.line_type%TYPE,
23691: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23692: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23693: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,