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 1545: OKC_K_LINES_TL b,

1541: capital_reduction_percent,
1542: oec,
1543: e.ste_code ste_code -- 5264170
1544: FROM OKL_K_LINES a,
1545: OKC_K_LINES_TL b,
1546: OKC_LINE_STYLES_V C,
1547: OKC_K_LINES_B d,
1548: OKC_STATUSES_B e
1549: WHERE a.ID = p_id

Line 1585: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

1581: l_oec_amount OKL_K_LINES.OEC%TYPE;
1582: l_capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
1583: l_capital_reduction_percent OKL_K_LINES.CAPITAL_REDUCTION_PERCENT%TYPE;
1584: l_capitalize_down_payment_yn OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE;
1585: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
1586: l_ste_code OKC_STATUSES_B.STE_CODE%TYPE;
1587:
1588: line_ind NUMBER;
1589: ind NUMBER;

Line 4765: okc_k_lines_tl cle_tl,

4761:
4762: CURSOR asset_num_csr(p_cle_id NUMBER) IS
4763: SELECT name
4764: FROM okc_k_lines_b cle1,
4765: okc_k_lines_tl cle_tl,
4766: okc_k_lines_b cle2
4767: WHERE cle_tl.id = cle2.id
4768: AND cle1.id = p_cle_id
4769: AND cle2.id = cle1.cle_id

Line 4804: l_asset_num okc_k_lines_tl.name%TYPE;

4800: l_location_id hz_party_sites.location_id%TYPE;
4801: l_serial_number_control_code VARCHAR2(3);
4802: l_trx_line_type_book VARCHAR2(10);
4803: l_party_site_id hz_party_site_uses.party_site_id%TYPE;
4804: l_asset_num okc_k_lines_tl.name%TYPE;
4805: l_okl_location_name VARCHAR2(160);
4806: l_ib_location_name VARCHAR2(160);
4807: l_contract_start_date okc_k_headers_b.start_date%TYPE;
4808: l_inv_organization_id okc_k_headers_b.inv_organization_id%TYPE;

Line 10689: okc_k_lines_tl orig_clet,

10685: select --trunc(orig_cleb.date_terminated) date_terminated,
10686: trunc(decode(sign(orig_cleb.end_date - orig_cleb.date_terminated),-1,orig_cleb.end_date,orig_cleb.date_terminated)) date_terminated,
10687: orig_clet.name asset_number
10688: from okc_k_lines_b orig_cleb,
10689: okc_k_lines_tl orig_clet,
10690: okc_k_lines_b cleb,
10691: okl_k_lines kle
10692: where orig_clet.id = orig_cleb.id
10693: and orig_clet.language = userenv('LANG')

Line 11558: okc_k_lines_tl clet,

11554: cleb_asst.start_date asset_start_date,
11555: kle.amount,
11556: kle.subsidy_override_amount
11557: FROM okl_k_lines kle,
11558: okc_k_lines_tl clet,
11559: okc_k_lines_b cleb,
11560: okc_line_styles_b lseb,
11561: okc_k_lines_tl clet_asst,
11562: okc_k_lines_b cleb_asst,

Line 11561: okc_k_lines_tl clet_asst,

11557: FROM okl_k_lines kle,
11558: okc_k_lines_tl clet,
11559: okc_k_lines_b cleb,
11560: okc_line_styles_b lseb,
11561: okc_k_lines_tl clet_asst,
11562: okc_k_lines_b cleb_asst,
11563: okc_line_styles_b lseb_asst
11564: WHERE kle.id = cleb.id
11565: AND clet.id = cleb.id

Line 13755: okc_k_lines_tl clet_rbk,

13751: cleb_rbk.start_date,
13752: kle_rbk.capital_amount new_capital_amount,
13753: kle_orig.capital_amount orig_capital_amount
13754: FROM okc_k_lines_b cleb_rbk,
13755: okc_k_lines_tl clet_rbk,
13756: okl_k_lines kle_rbk,
13757: okl_k_lines kle_orig,
13758: okc_statuses_b sts
13759: WHERE cleb_rbk.chr_id = p_chr_id

Line 13776: okc_k_lines_tl clet_rbk,

13772: cleb_rbk.start_date,
13773: kle_rbk.amount new_amount,
13774: kle_orig.amount orig_amount
13775: FROM okc_k_lines_b cleb_rbk,
13776: okc_k_lines_tl clet_rbk,
13777: okl_k_lines kle_rbk,
13778: okl_k_lines kle_orig,
13779: okc_statuses_b sts
13780: WHERE cleb_rbk.chr_id = p_chr_id

Line 13797: okc_k_lines_tl clet_rbk,

13793: cleb_sub_rbk.start_date,
13794: kle_sub_rbk.amount new_amount,
13795: kle_sub_orig.amount orig_amount
13796: FROM okc_k_lines_b cleb_rbk,
13797: okc_k_lines_tl clet_rbk,
13798: okl_k_lines kle_rbk,
13799: okc_k_lines_b cleb_sub_rbk,
13800: okl_k_lines kle_sub_rbk,
13801: okl_k_lines kle_sub_orig,

Line 13981: okc_k_lines_tl clet_rbk,

13977: cleb_rbk.orig_system_id1 orig_cle_id,
13978: clet_rbk.name,
13979: cleb_rbk.start_date
13980: FROM okc_k_lines_b cleb_rbk,
13981: okc_k_lines_tl clet_rbk,
13982: okc_statuses_b sts
13983: WHERE cleb_rbk.chr_id = p_chr_id
13984: AND cleb_rbk.dnz_chr_id = p_chr_id
13985: AND cleb_rbk.lse_id = 33

Line 13998: okc_k_lines_tl clet_rbk,

13994: cleb_rbk.orig_system_id1 orig_cle_id,
13995: clet_rbk.name,
13996: cleb_rbk.start_date
13997: FROM okc_k_lines_b cleb_rbk,
13998: okc_k_lines_tl clet_rbk,
13999: okl_k_lines kle_rbk,
14000: okc_statuses_b sts
14001: WHERE cleb_rbk.chr_id = p_chr_id
14002: AND cleb_rbk.dnz_chr_id = p_chr_id

Line 14017: okc_k_lines_tl clet_rbk,

14013: cleb_sub_rbk.orig_system_id1 orig_cle_id,
14014: clet_rbk.name,
14015: cleb_sub_rbk.start_date
14016: FROM okc_k_lines_b cleb_rbk,
14017: okc_k_lines_tl clet_rbk,
14018: okl_k_lines kle_rbk,
14019: okc_k_lines_b cleb_sub_rbk,
14020: okc_statuses_b sts
14021: WHERE cleb_rbk.chr_id = p_chr_id

Line 14178: okc_k_lines_tl clet,

14174: cleb.start_date,
14175: kle.date_delivery_expected,
14176: kle.date_funding_expected
14177: FROM okc_k_lines_b cleb,
14178: okc_k_lines_tl clet,
14179: okl_k_lines kle,
14180: okc_statuses_b sts
14181: WHERE cleb.chr_id = p_chr_id
14182: AND cleb.dnz_chr_id = p_chr_id