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_QA_DATA_INTEGRITY dependencies on OKC_K_LINES_TL

Line 1535: OKC_K_LINES_TL b,

1531: capital_reduction_percent,
1532: oec,
1533: e.ste_code ste_code -- 5264170
1534: FROM OKL_K_LINES a,
1535: OKC_K_LINES_TL b,
1536: OKC_LINE_STYLES_V C,
1537: OKC_K_LINES_B d,
1538: OKC_STATUSES_B e
1539: WHERE a.ID = p_id

Line 1559: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

1555: l_oec_amount OKL_K_LINES.OEC%TYPE;
1556: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1557: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1558: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1559: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
1560: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;
1561:
1562: line_ind NUMBER;
1563: ind NUMBER;

Line 4378: okc_k_lines_tl cle_tl,

4374:
4375: CURSOR asset_num_csr(p_cle_id NUMBER) IS
4376: SELECT name
4377: FROM okc_k_lines_b cle1,
4378: okc_k_lines_tl cle_tl,
4379: okc_k_lines_b cle2
4380: WHERE cle_tl.id = cle2.id
4381: AND cle1.id = p_cle_id
4382: AND cle2.id = cle1.cle_id

Line 4417: l_asset_num okc_k_lines_tl.name%TYPE;

4413: l_location_id hz_party_sites.location_id%TYPE;
4414: l_serial_number_control_code VARCHAR2(3);
4415: l_trx_line_type_book VARCHAR2(10);
4416: l_party_site_id hz_party_site_uses.party_site_id%TYPE;
4417: l_asset_num okc_k_lines_tl.name%TYPE;
4418: l_okl_location_name VARCHAR2(160);
4419: l_ib_location_name VARCHAR2(160);
4420: l_contract_start_date okc_k_headers_b.start_date%TYPE;
4421: l_inv_organization_id okc_k_headers_b.inv_organization_id%TYPE;

Line 10270: okc_k_lines_tl orig_clet,

10266: select --trunc(orig_cleb.date_terminated) date_terminated,
10267: trunc(decode(sign(orig_cleb.end_date - orig_cleb.date_terminated),-1,orig_cleb.end_date,orig_cleb.date_terminated)) date_terminated,
10268: orig_clet.name asset_number
10269: from okc_k_lines_b orig_cleb,
10270: okc_k_lines_tl orig_clet,
10271: okc_k_lines_b cleb
10272: where orig_clet.id = orig_cleb.id
10273: and orig_clet.language = userenv('LANG')
10274: and orig_cleb.id = cleb.orig_system_id1

Line 11135: okc_k_lines_tl clet,

11131: cleb_asst.start_date asset_start_date,
11132: kle.amount,
11133: kle.subsidy_override_amount
11134: FROM okl_k_lines kle,
11135: okc_k_lines_tl clet,
11136: okc_k_lines_b cleb,
11137: okc_line_styles_b lseb,
11138: okc_k_lines_tl clet_asst,
11139: okc_k_lines_b cleb_asst,

Line 11138: okc_k_lines_tl clet_asst,

11134: FROM okl_k_lines kle,
11135: okc_k_lines_tl clet,
11136: okc_k_lines_b cleb,
11137: okc_line_styles_b lseb,
11138: okc_k_lines_tl clet_asst,
11139: okc_k_lines_b cleb_asst,
11140: okc_line_styles_b lseb_asst
11141: WHERE kle.id = cleb.id
11142: AND clet.id = cleb.id