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_STATUSES_B

Line 334: OKC_STATUSES_B fa_sts

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
338: AND fa_cle.lse_id = fa_lse.id

Line 346: OKC_STATUSES_B fa_sts2

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
350: AND fa_sts2.ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED')

Line 358: OKC_STATUSES_B fa_sts

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
362: AND fa_cle.lse_id = fa_lse.id

Line 374: OKC_STATUSES_B fa_sts2

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
378: AND fa_sts2.ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED')

Line 390: OKC_STATUSES_B fa_sts,

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
394: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id

Line 1538: OKC_STATUSES_B e

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
1540: AND a.ID = b.ID
1541: AND b.LANGUAGE = USERENV('LANG')
1542: AND c.lty_code ='FREE_FORM1'

Line 1560: l_ste_code OKC_STATUSES_B.STE_CODE%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;
1564: l_global_total_periods NUMBER;

Line 3844: OKC_STATUSES_B sts

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
3848: AND sts.code = kle.sts_code

Line 4083: okc_statuses_b sts

4079: FROM okc_rules_b rule,
4080: okc_rule_groups_b rgp,
4081: okc_k_lines_b line,
4082: okc_line_styles_v style,
4083: okc_statuses_b sts
4084: WHERE rgp.id = rule.rgp_id
4085: AND rgp.rgd_code = 'LALEVL'
4086: AND rgp.dnz_chr_id = p_chr_id
4087: AND rgp.cle_id = line.id

Line 4297: okc_statuses_b sts

4293: CURSOR ib_line_csr(p_chr_id NUMBER) IS
4294: SELECT cle.id,
4295: cle.cle_id
4296: FROM okc_k_lines_b cle,
4297: okc_statuses_b sts
4298: WHERE cle.lse_id = G_IB_LINE_LTY_ID
4299: AND cle.dnz_chr_id = p_chr_id
4300: AND cle.sts_code = sts.code
4301: AND sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 4757: okc_statuses_b sts

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
4761: AND sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 5357: okc_statuses_b okcsts1

5353: AND CLEB.ID =kleId
5354: and exists
5355: ( SELECT '1'
5356: FROM okc_k_lines_b cleb1,
5357: okc_statuses_b okcsts1
5358: WHERE cleb1.dnz_chr_id = cleb.chr_id
5359: AND cleb1.cle_id = cleb.id
5360: AND okcsts1.code = cleb1.sts_code
5361: AND okcsts1.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line 6237: okc_statuses_b okcsts

6233: CURSOR l_fn_top_fee_ln_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6234: SELECT kle.id, kle.amount, cleb.name
6235: FROM okc_k_lines_v cleb,
6236: okl_k_lines kle,
6237: okc_statuses_b okcsts
6238: WHERE cleb.dnz_chr_id = chrID
6239: AND cleb.chr_id = chrID
6240: AND kle.ID = cleb.ID
6241: AND kle.fee_type = 'FINANCED'

Line 6256: okc_statuses_b okcsts

6252: SELECT kle.id, kle.amount, cleb.end_date
6253: ,cleb.start_date -- added for bug 5115701
6254: FROM okc_k_lines_b cleb,
6255: okl_k_lines kle,
6256: okc_statuses_b okcsts
6257: WHERE cleb.dnz_chr_id = chrID
6258: AND kle.ID = cleb.ID
6259: AND cleb.CLE_ID = feeTopLine
6260: AND okcsts.code = cleb.sts_code

Line 6555: FROM okc_statuses_b okcsts

6551: AND kle.fee_type = 'ROLLOVER'
6552: AND TRUNC(khr.start_date) > SYSDATE
6553: AND NOT EXISTS (
6554: SELECT 'Y'
6555: FROM okc_statuses_b okcsts
6556: WHERE okcsts.code = cleb.sts_code
6557: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
6558:
6559: BEGIN

Line 6638: OKC_STATUSES_B sts

6634: kle.id,
6635: kle.name
6636: FROM OKL_K_LINES_FULL_V kle,
6637: OKC_LINE_STYLES_V ls,
6638: OKC_STATUSES_B sts
6639: WHERE kle.lse_id = ls.id
6640: AND ls.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE')
6641: AND kle.dnz_chr_id = chrid
6642: AND sts.code = kle.sts_code

Line 7141: okc_statuses_b sts

7137: fin_ast_cle.orig_system_id1 orig_fin_ast_cle_id,
7138: fin_ast_cle.name asset_number
7139: FROM okc_k_lines_b model_cle,
7140: okc_k_lines_v fin_ast_cle,
7141: okc_statuses_b sts
7142: WHERE fin_ast_cle.chr_id = p_chr_id
7143: AND fin_ast_cle.dnz_chr_id = p_chr_id
7144: AND fin_ast_cle.lse_id = 33 -- Financial Asset Line
7145: AND model_cle.dnz_chr_id = p_chr_id

Line 7157: okc_statuses_b sts,

7153: ) IS
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

Line 7190: okc_statuses_b inst_sts

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
7192: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
7193: AND orig_inst_cle.lse_id = 43
7194: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 7205: okc_statuses_b rbk_inst_sts

7201: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
7202: AND NOT EXISTS (
7203: SELECT 1
7204: FROM okc_k_lines_b rbk_inst_cle,
7205: okc_statuses_b rbk_inst_sts
7206: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
7207: AND rbk_inst_cle.lse_id = 43
7208: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id
7209: AND rbk_inst_cle.cle_id = p_rbk_fin_ast_cle_id

Line 7218: okc_statuses_b sts,

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
7222: AND svc_cle.id = svc_item.cle_id

Line 7235: okc_statuses_b sts,

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
7239: WHERE svc_item.object1_id1 = TO_CHAR(cc.counter_id)

Line 7401: okc_statuses_b sts

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
7405: AND sty.lty_code = 'FREE_FORM1'

Line 7710: okc_statuses_b sts

7706: line.line_number,
7707: line.amount
7708: FROM okl_k_lines_full_v line,
7709: okc_line_styles_v style,
7710: okc_statuses_b sts
7711: WHERE line.lse_id = style.id
7712: AND style.lty_code = p_lty_code
7713: AND sts.code = line.sts_code
7714: AND sts.ste_code NOT IN ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 7826: OKC_STATUSES_B sts

7822: kle.id,
7823: ls.name line_style
7824: FROM OKL_K_LINES_FULL_V kle,
7825: OKC_LINE_STYLES_v ls,
7826: OKC_STATUSES_B sts
7827: WHERE kle.lse_id = ls.id
7828: AND ls.lty_code = ltycode
7829: AND kle.dnz_chr_id = chrid
7830: AND sts.code = kle.sts_code

Line 7847: OKC_STATUSES_B sts

7843: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
7844: SELECT kle.id
7845: FROM OKL_K_LINES_FULL_V kle,
7846: OKC_LINE_STYLES_v ls,
7847: OKC_STATUSES_B sts
7848: WHERE kle.lse_id = ls.id
7849: AND ls.lty_code = ltycode
7850: AND kle.dnz_chr_id = chrid
7851: AND sts.code = kle.sts_code

Line 8962: okc_statuses_b sts

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
8966: AND lty_code = 'FREE_FORM1'

Line 10612: okc_statuses_b sts

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
10614: AND line.lse_id = style.id
10615: AND line.sts_code = sts.code
10616: AND line.id = item.cle_id

Line 10630: okc_statuses_b sts

10626: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
10627: SELECT id,
10628: NVL(capital_amount,0) capital_amount
10629: FROM okl_k_lines_full_v line,
10630: okc_statuses_b sts
10631: WHERE line.cle_id = p_cle_id
10632: AND line.sts_code = sts.code
10633: --Bug# 4959361: Include Terminated lines when fetching sub-line amount
10634: --AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');

Line 10861: OKC_STATUSES_B sts

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
10865: AND sts.code = kle.sts_code

Line 11020: okc_statuses_b sts

11016: SELECT line.id,
11017: line.name
11018: FROM okl_k_lines_full_v line,
11019: okc_line_styles_v style,
11020: okc_statuses_b sts
11021: WHERE line. dnz_chr_id = p_chr_id
11022: AND line.lse_id = style.id
11023: AND style.lty_code = 'FREE_FORM1'
11024: AND line.sts_code = sts.code

Line 11630: okc_statuses_b sts

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
11631: WHERE cim.cle_id = fa.id
11632: AND cim.dnz_chr_id = p_chr_id
11633: AND fa.lse_id = fa_lse.id
11634: AND txd.tal_id = txl.id

Line 12109: okc_statuses_b sts,

12105: txl.depreciation_cost new_cost
12106: from okl_trx_assets trx,
12107: okl_txl_assets_b txl,
12108: okc_k_lines_b cleb,
12109: okc_statuses_b sts,
12110: fa_books fab,
12111: fa_additions fa
12112: where trx.id = txl.tas_id
12113: and trx.tsu_code = 'ENTERED'

Line 12381: okc_statuses_b sts

12377: CURSOR l_fin_ast_cle_csr (p_chr_id IN NUMBER) IS
12378: SELECT cle.id,
12379: cle.orig_system_id1
12380: FROM okc_k_lines_b cle,
12381: okc_statuses_b sts
12382: WHERE cle.chr_id = p_chr_id
12383: AND cle.lse_id = 33 --Financial Asset Line
12384: and sts.code = cle.sts_code
12385: and sts.ste_code NOT IN ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');

Line 12396: okc_statuses_b sts

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
12400: AND lse.lty_code = p_lty_code