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_LINE_STYLES_B

Line 333: OKC_LINE_STYLES_B fa_lse,

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
336: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id
337: AND fa_cle.dnz_chr_id = chrid

Line 345: OKC_LINE_STYLES_B fa_lse2,

341: AND fa_sts.ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED')
342: AND fa_cim.object1_id1 IS NULL
343: AND EXISTS (SELECT '1'
344: FROM OKC_K_LINES_B fa_cle2,
345: OKC_LINE_STYLES_B fa_lse2,
346: OKC_STATUSES_B fa_sts2
347: WHERE fa_cle2.lse_id = fa_lse2.id
348: AND fa_lse2.lty_code = 'FIXED_ASSET'
349: AND fa_cle2.sts_code = fa_sts2.code

Line 357: OKC_LINE_STYLES_B fa_lse,

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
360: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id
361: AND fa_cle.dnz_chr_id = chrid

Line 373: OKC_LINE_STYLES_B fa_lse2,

369: WHERE FAB.Asset_id = TO_NUMBER(fa_cim.object1_id1)
370: )
371: AND EXISTS (SELECT '1'
372: FROM OKC_K_LINES_B fa_cle2,
373: OKC_LINE_STYLES_B fa_lse2,
374: OKC_STATUSES_B fa_sts2
375: WHERE fa_cle2.lse_id = fa_lse2.id
376: AND fa_lse2.lty_code = 'FIXED_ASSET'
377: AND fa_cle2.sts_code = fa_sts2.code

Line 389: OKC_LINE_STYLES_B fa_lse,

385: WHERE EXISTS
386: (
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

Line 3843: OKC_LINE_STYLES_B ls,

3839: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
3840: SELECT kle.id,
3841: kle.name
3842: FROM OKC_K_LINES_V kle,
3843: OKC_LINE_STYLES_B ls,
3844: OKC_STATUSES_B sts
3845: WHERE kle.lse_id = ls.id
3846: AND ls.lty_code = ltycode
3847: AND kle.dnz_chr_id = chrid

Line 4201: okc_line_styles_b item_style,

4197: mtl.description,
4198: mtl.serial_number_control_code
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

Line 4202: okc_line_styles_b top_style,

4198: mtl.serial_number_control_code
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

Line 4223: okc_line_styles_b style,

4219: CURSOR ib_csr (p_top_cle_id OKC_K_LINES_B.ID%TYPE) IS
4220: SELECT COUNT(inst.serial_number) no_srl
4221: FROM okc_k_lines_b ib,
4222: okc_k_lines_b f2,
4223: okc_line_styles_b style,
4224: okl_txl_itm_insts inst
4225: WHERE f2.cle_id = p_top_cle_id
4226: AND f2.lse_id = style.id
4227: AND f2.dnz_chr_id = p_chr_id

Line 4756: okc_line_styles_b lse,

4752: SELECT cle.id,
4753: DECODE (lse.lty_code, 'FREE_FORM1', 'ASSET', 'FEE', 'FEE',
4754: 'SOLD_SERVICE','SERVICE') line_type
4755: FROM okc_k_lines_b cle,
4756: okc_line_styles_b lse,
4757: okc_statuses_b sts
4758: WHERE cle.chr_id = p_khr_id
4759: AND cle.lse_id = lse.id
4760: AND cle.sts_code = sts.code

Line 7400: okc_line_styles_b sty,

7396: --down_payment_yes_no
7397: FROM
7398: okl_k_lines kle,
7399: okc_k_lines_v cle,
7400: okc_line_styles_b sty,
7401: okc_statuses_b sts
7402: WHERE cle.id = kle.id
7403: AND dnz_chr_id = p_chr_id
7404: AND cle.lse_id = sty.id

Line 8961: okc_line_styles_b sty,

8957: name,
8958: kle.residual_value
8959: FROM okc_k_lines_v cle,
8960: okl_k_lines kle,
8961: okc_line_styles_b sty,
8962: okc_statuses_b sts
8963: WHERE cle.lse_id = sty.id
8964: AND cle.dnz_chr_id = p_chr_id
8965: AND cle.id = kle.id

Line 9121: * OKC_LINE_STYLES_B lse

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
9123: * and lse.lty_code='SHARED'
9124: * AND KL.CHR_ID =KL.DNZ_CHR_ID
9125: * AND KL.DNZ_CHR_ID = ITM.DNZ_CHR_ID

Line 9167: OKC_LINE_STYLES_B lse

9163: CURSOR l_inst_csr( chrId NUMBER ) IS
9164: SELECT inst.object_id1_new
9165: FROM OKL_TXL_ITM_INSTS inst,
9166: OKL_K_LINES_FULL_V kle,
9167: OKC_LINE_STYLES_B lse
9168: WHERE inst.kle_id = kle.id
9169: AND lse.id = kle.lse_id
9170: AND lse.lty_code = 'INST_ITEM'
9171: AND kle.dnz_chr_id = chrId;

Line 9179: OKC_LINE_STYLES_B lse

9175: CURSOR l_shipto_csr( chrId NUMBER ) IS
9176: SELECT inv.shipping_address_id1
9177: FROM OKL_SUPP_INVOICE_DTLS inv,
9178: OKL_K_LINES_FULL_V kle,
9179: OKC_LINE_STYLES_B lse
9180: WHERE inv.cle_id = kle.id
9181: AND lse.id = kle.lse_id
9182: AND lse.lty_code = 'ITEM'
9183: AND kle.dnz_chr_id = chrId;

Line 10231: OKC_LINE_STYLES_B cls

10227: OKL_K_HEADERS khr,
10228: OKL_K_LINES kle,
10229: OKC_K_LINES_B cle,
10230: OKL_TRX_QUOTES_B qte,
10231: OKC_LINE_STYLES_B cls
10232: WHERE cle.id = kle.id
10233: AND chr.id = p_contract_id
10234: AND chr.id = cle.chr_id
10235: AND chr.id = cle.dnz_chr_id

Line 10768: p_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE) IS

10764: ) IS
10765:
10766: --Bug#3931587
10767: CURSOR pmnt_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
10768: p_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE) IS
10769: SELECT COUNT(1)
10770: FROM okc_rules_b rule,
10771: okc_rule_groups_b rgp,
10772: okc_k_lines_b line,

Line 10773: okc_line_styles_b style,

10769: SELECT COUNT(1)
10770: FROM okc_rules_b rule,
10771: okc_rule_groups_b rgp,
10772: okc_k_lines_b line,
10773: okc_line_styles_b style,
10774: okl_strm_type_b strm
10775: WHERE rgp.dnz_chr_id = p_chr_id
10776: AND rgp.cle_id IS NOT NULL
10777: AND rgp.cle_id = line.id

Line 10860: OKC_LINE_STYLES_B ls,

10856: kle.residual_grnty_amount,
10857: kle.start_date,
10858: kle.end_date
10859: FROM OKL_K_LINES_FULL_V kle,
10860: OKC_LINE_STYLES_B ls,
10861: OKC_STATUSES_B sts
10862: WHERE kle.lse_id = ls.id
10863: AND ls.lty_code = ltycode
10864: AND kle.dnz_chr_id = chrid

Line 11137: okc_line_styles_b lseb,

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,
11140: okc_line_styles_b lseb_asst
11141: WHERE kle.id = cleb.id

Line 11140: okc_line_styles_b lseb_asst

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
11143: AND clet.LANGUAGE = USERENV('LANG')
11144: AND cleb.cle_id = cleb_asst.id

Line 11626: okc_line_styles_b fa_lse,

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,
11629: okl_txd_assets_v txd,
11630: okc_statuses_b sts

Line 12395: okc_line_styles_b lse,

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
12399: AND cle.lse_id = lse.id