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_ITEMS

Line 331: FROM OKC_K_ITEMS fa_cim,

327: FROM DUAL
328: WHERE EXISTS
329: (
330: SELECT 'Y'
331: FROM OKC_K_ITEMS fa_cim,
332: OKC_K_LINES_B fa_cle,
333: OKC_LINE_STYLES_B fa_lse,
334: OKC_STATUSES_B fa_sts
335: WHERE fa_cim.cle_id = fa_cle.id

Line 355: FROM OKC_K_ITEMS fa_cim,

351: AND fa_cle2.dnz_chr_id = chrid
352: )
353: UNION
354: SELECT 'Y'
355: FROM OKC_K_ITEMS fa_cim,
356: OKC_K_LINES_B fa_cle,
357: OKC_LINE_STYLES_B fa_lse,
358: OKC_STATUSES_B fa_sts
359: WHERE fa_cim.cle_id = fa_cle.id

Line 391: OKC_K_ITEMS fa_cim,

387: SELECT 1
388: FROM OKC_K_LINES_B fa_cle,
389: OKC_LINE_STYLES_B fa_lse,
390: OKC_STATUSES_B fa_sts,
391: OKC_K_ITEMS fa_cim,
392: FA_ADDITIONS_B FAB
393: WHERE fa_cim.cle_id = fa_cle.id
394: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id
395: AND fa_cle.dnz_chr_id = chrId

Line 4203: okc_k_items kitem,

4199: FROM okc_k_lines_v top,
4200: okc_k_lines_b item,
4201: okc_line_styles_b item_style,
4202: okc_line_styles_b top_style,
4203: okc_k_items kitem,
4204: mtl_system_items mtl
4205: WHERE top.dnz_chr_id = p_chr_id
4206: AND top.lse_id = top_style.id
4207: AND top_style.lty_code = 'FREE_FORM1'

Line 4311: FROM okc_k_items_v cim

4307: cim.object1_id1,
4308: cim.object1_id2,
4309: cim.jtot_object1_code,
4310: cim.number_of_items
4311: FROM okc_k_items_v cim
4312: WHERE cle_id = p_cle_id;
4313:
4314:
4315: CURSOR okl_iipv_csr (p_kle_id NUMBER) IS

Line 6648: FROM okc_k_items itm

6644:
6645: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,
6646: lineid OKC_K_LINES_B.ID%TYPE) IS
6647: SELECT itm.object1_id1
6648: FROM okc_k_items itm
6649: WHERE cle_id = lineid
6650: AND dnz_chr_id = chrid
6651: AND jtot_object1_code = 'OKL_STRMTYP';
6652:

Line 7158: okc_k_items ib_cim

7154: SELECT ib_cim.object1_id1 instance_id
7155: FROM okc_k_lines_b ib_cle,
7156: okc_k_lines_b inst_cle,
7157: okc_statuses_b sts,
7158: okc_k_items ib_cim
7159: WHERE inst_cle.dnz_chr_id = p_chr_id
7160: AND inst_cle.cle_id = p_fin_ast_cle_id
7161: AND inst_cle.lse_id = 43 -- FREE_FORM2 Line
7162: AND ib_cle.dnz_chr_id = p_chr_id

Line 7175: FROM okc_k_items cim

7171: p_cle_id IN NUMBER) IS
7172: SELECT cim.object1_id1,
7173: cim.object1_id2,
7174: cim.number_of_items
7175: FROM okc_k_items cim
7176: WHERE cim.cle_id = p_cle_id
7177: AND cim.dnz_chr_id = p_chr_id;
7178:
7179: l_rbk_item_rec l_item_csr%ROWTYPE;

Line 7187: FROM okc_k_items orig_ib_cim,

7183: p_rbk_fin_ast_cle_id IN NUMBER,
7184: p_orig_chr_id IN NUMBER,
7185: p_rbk_chr_id IN NUMBER) IS
7186: SELECT orig_ib_cim.object1_id1 instance_id
7187: FROM okc_k_items orig_ib_cim,
7188: okc_k_lines_b orig_ib_cle,
7189: okc_k_lines_b orig_inst_cle,
7190: okc_statuses_b inst_sts
7191: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id

Line 7217: okc_k_items svc_item,

7213: CURSOR check_svc_chr(p_object1_id1 IN VARCHAR2,
7214: p_jtot_object_code IN VARCHAR2) IS
7215: SELECT svc_cle.dnz_chr_id
7216: FROM okc_k_lines_b svc_cle,
7217: okc_k_items svc_item,
7218: okc_statuses_b sts,
7219: okc_k_headers_b svc_chr
7220: WHERE svc_item.object1_id1 = p_object1_id1
7221: AND svc_item.jtot_object1_code = p_jtot_object_code

Line 7234: okc_k_items svc_item,

7230: p_jtot_object_code IN VARCHAR2,
7231: p_source_object_code IN VARCHAR2) IS
7232: SELECT svc_cle.dnz_chr_id
7233: FROM okc_k_lines_b svc_cle,
7234: okc_k_items svc_item,
7235: okc_statuses_b sts,
7236: okc_k_headers_b svc_chr,
7237: cs_counter_groups csg,
7238: cs_counters cc

Line 9118: * from OKC_K_ITEMS_V ITM,

9114: /* Bug 3825314
9115: *
9116: * Cursor l_synd_csr ( chrId NUMBER ) IS
9117: * select kl.dnz_chr_id syndId
9118: * from OKC_K_ITEMS_V ITM,
9119: * OKC_K_LINES_V KL,
9120: * OKL_K_HEADERS_FULL_V KHR,
9121: * OKC_LINE_STYLES_B lse
9122: * where KL.LSE_ID=lse.id

Line 10609: okc_k_items item,

10605: NVL(line.capital_amount,0) capital_amount,
10606: line.start_date,
10607: strm.code strm_type
10608: FROM okl_k_lines_full_v line,
10609: okc_k_items item,
10610: okl_strmtyp_source_v strm,
10611: okc_line_styles_v style,
10612: okc_statuses_b sts
10613: WHERE line.dnz_chr_id = p_chr_id

Line 10641: okc_k_items item

10637: --Bug#3877032
10638: CURSOR link_asset_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
10639: SELECT line.start_date
10640: FROM okc_k_lines_b line,
10641: okc_k_items item
10642: WHERE item.cle_id = p_line_id
10643: AND item.object1_id1 = line.id
10644: AND item.object1_id2 = '#'
10645: AND line.dnz_chr_id = p_chr_id

Line 11624: FROM okc_k_items cim,

11620: CURSOR l_assets_txl_lines IS
11621: SELECT txl.asset_number asset_num,
11622: fa.id fa_id,
11623: txd.tax_book
11624: FROM okc_k_items cim,
11625: okc_k_lines_V fa,
11626: okc_line_styles_b fa_lse,
11627: OKL_TRX_ASSETS trx,
11628: okl_txl_assets_b txl,

Line 12394: okc_k_items cim,

12390: SELECT cle.id,
12391: cim.object1_id1,
12392: cim.object1_id2
12393: FROM okc_k_lines_b cle,
12394: okc_k_items cim,
12395: okc_line_styles_b lse,
12396: okc_statuses_b sts
12397: WHERE cle.dnz_chr_id = p_chr_id
12398: AND cle.cle_id = p_cle_id