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: (
331: SELECT 1
332: FROM OKC_K_LINES_B fa_cle,
333: OKC_LINE_STYLES_B fa_lse,
334: OKC_STATUSES_B fa_sts,
335: OKC_K_ITEMS fa_cim,
336: FA_ADDITIONS_B FAB
337: WHERE fa_cim.cle_id = fa_cle.id
338: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id

Line 1548: OKC_STATUSES_B e

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

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

Line 4166: OKC_STATUSES_B sts

4162: SELECT kle.id,
4163: kle.name
4164: FROM OKC_K_LINES_V kle,
4165: OKC_LINE_STYLES_B ls,
4166: OKC_STATUSES_B sts
4167: WHERE kle.lse_id = ls.id
4168: AND ls.lty_code = ltycode
4169: AND kle.dnz_chr_id = chrid
4170: AND sts.code = kle.sts_code

Line 4405: okc_statuses_b sts

4401: FROM okc_rules_b rule,
4402: okc_rule_groups_b rgp,
4403: okc_k_lines_b line,
4404: okc_line_styles_v style,
4405: okc_statuses_b sts
4406: WHERE rgp.id = rule.rgp_id
4407: AND rgp.rgd_code = 'LALEVL'
4408: AND rgp.dnz_chr_id = p_chr_id
4409: AND rgp.cle_id = line.id

Line 4684: okc_statuses_b sts

4680: CURSOR ib_line_csr(p_chr_id NUMBER) IS
4681: SELECT cle.id,
4682: cle.cle_id
4683: FROM okc_k_lines_b cle,
4684: okc_statuses_b sts
4685: WHERE cle.lse_id = G_IB_LINE_LTY_ID
4686: AND cle.dnz_chr_id = p_chr_id
4687: AND cle.sts_code = sts.code
4688: AND sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 5144: okc_statuses_b sts

5140: DECODE (lse.lty_code, 'FREE_FORM1', 'ASSET', 'FEE', 'FEE',
5141: 'SOLD_SERVICE','SERVICE') line_type
5142: FROM okc_k_lines_b cle,
5143: okc_line_styles_b lse,
5144: okc_statuses_b sts
5145: WHERE cle.chr_id = p_khr_id
5146: AND cle.lse_id = lse.id
5147: AND cle.sts_code = sts.code
5148: AND sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 5744: okc_statuses_b okcsts1

5740: AND CLEB.ID =kleId
5741: and exists
5742: ( SELECT '1'
5743: FROM okc_k_lines_b cleb1,
5744: okc_statuses_b okcsts1
5745: WHERE cleb1.dnz_chr_id = cleb.chr_id
5746: AND cleb1.cle_id = cleb.id
5747: AND okcsts1.code = cleb1.sts_code
5748: AND okcsts1.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line 6624: okc_statuses_b okcsts

6620: CURSOR l_fn_top_fee_ln_csr ( chrID IN OKC_K_HEADERS_B.ID%TYPE ) IS
6621: SELECT kle.id, kle.amount, cleb.name
6622: FROM okc_k_lines_v cleb,
6623: okl_k_lines kle,
6624: okc_statuses_b okcsts
6625: WHERE cleb.dnz_chr_id = chrID
6626: AND cleb.chr_id = chrID
6627: AND kle.ID = cleb.ID
6628: AND kle.fee_type = 'FINANCED'

Line 6643: okc_statuses_b okcsts

6639: SELECT kle.id, kle.amount, cleb.end_date
6640: ,cleb.start_date -- added for bug 5115701
6641: FROM okc_k_lines_b cleb,
6642: okl_k_lines kle,
6643: okc_statuses_b okcsts
6644: WHERE cleb.dnz_chr_id = chrID
6645: AND kle.ID = cleb.ID
6646: AND cleb.CLE_ID = feeTopLine
6647: AND okcsts.code = cleb.sts_code

Line 6942: FROM okc_statuses_b okcsts

6938: AND kle.fee_type = 'ROLLOVER'
6939: AND TRUNC(khr.start_date) > SYSDATE
6940: AND NOT EXISTS (
6941: SELECT 'Y'
6942: FROM okc_statuses_b okcsts
6943: WHERE okcsts.code = cleb.sts_code
6944: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
6945:
6946: BEGIN

Line 7025: OKC_STATUSES_B sts

7021: kle.id,
7022: kle.name
7023: FROM OKL_K_LINES_FULL_V kle,
7024: OKC_LINE_STYLES_V ls,
7025: OKC_STATUSES_B sts
7026: WHERE kle.lse_id = ls.id
7027: AND ls.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE')
7028: AND kle.dnz_chr_id = chrid
7029: AND sts.code = kle.sts_code

Line 7535: okc_statuses_b sts

7531: fin_ast_cle.orig_system_id1 orig_fin_ast_cle_id,
7532: fin_ast_cle.name asset_number
7533: FROM okc_k_lines_b model_cle,
7534: okc_k_lines_v fin_ast_cle,
7535: okc_statuses_b sts
7536: WHERE fin_ast_cle.chr_id = p_chr_id
7537: AND fin_ast_cle.dnz_chr_id = p_chr_id
7538: AND fin_ast_cle.lse_id = 33 -- Financial Asset Line
7539: AND model_cle.dnz_chr_id = p_chr_id

Line 7551: okc_statuses_b sts,

7547: ) IS
7548: SELECT ib_cim.object1_id1 instance_id
7549: FROM okc_k_lines_b ib_cle,
7550: okc_k_lines_b inst_cle,
7551: okc_statuses_b sts,
7552: okc_k_items ib_cim
7553: WHERE inst_cle.dnz_chr_id = p_chr_id
7554: AND inst_cle.cle_id = p_fin_ast_cle_id
7555: AND inst_cle.lse_id = 43 -- FREE_FORM2 Line

Line 7584: okc_statuses_b inst_sts

7580: SELECT orig_ib_cim.object1_id1 instance_id
7581: FROM okc_k_items orig_ib_cim,
7582: okc_k_lines_b orig_ib_cle,
7583: okc_k_lines_b orig_inst_cle,
7584: okc_statuses_b inst_sts
7585: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
7586: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
7587: AND orig_inst_cle.lse_id = 43
7588: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 7599: okc_statuses_b rbk_inst_sts

7595: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
7596: AND NOT EXISTS (
7597: SELECT 1
7598: FROM okc_k_lines_b rbk_inst_cle,
7599: okc_statuses_b rbk_inst_sts
7600: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
7601: AND rbk_inst_cle.lse_id = 43
7602: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id
7603: AND rbk_inst_cle.cle_id = p_rbk_fin_ast_cle_id

Line 7612: okc_statuses_b sts,

7608: p_jtot_object_code IN VARCHAR2) IS
7609: SELECT svc_cle.dnz_chr_id
7610: FROM okc_k_lines_b svc_cle,
7611: okc_k_items svc_item,
7612: okc_statuses_b sts,
7613: okc_k_headers_b svc_chr
7614: WHERE svc_item.object1_id1 = p_object1_id1
7615: AND svc_item.jtot_object1_code = p_jtot_object_code
7616: AND svc_cle.id = svc_item.cle_id

Line 7629: okc_statuses_b sts,

7625: p_source_object_code IN VARCHAR2) IS
7626: SELECT svc_cle.dnz_chr_id
7627: FROM okc_k_lines_b svc_cle,
7628: okc_k_items svc_item,
7629: okc_statuses_b sts,
7630: okc_k_headers_b svc_chr,
7631: cs_counter_groups csg,
7632: cs_counters cc
7633: WHERE svc_item.object1_id1 = TO_CHAR(cc.counter_id)

Line 7795: okc_statuses_b sts

7791: FROM
7792: okl_k_lines kle,
7793: okc_k_lines_v cle,
7794: okc_line_styles_b sty,
7795: okc_statuses_b sts
7796: WHERE cle.id = kle.id
7797: AND dnz_chr_id = p_chr_id
7798: AND cle.lse_id = sty.id
7799: AND sty.lty_code = 'FREE_FORM1'

Line 7843: okc_statuses_b sts

7839: SELECT kle.tradein_amount
7840: FROM okl_k_lines kle,
7841: okc_k_lines_b cle,
7842: okc_line_styles_b lse,
7843: okc_statuses_b sts
7844: WHERE cle.id = kle.id
7845: AND cle.dnz_chr_id = p_chr_id
7846: AND cle.chr_id = p_chr_id
7847: AND cle.lse_id = lse.id

Line 8127: okc_statuses_b sts

8123: line.line_number,
8124: line.amount
8125: FROM okl_k_lines_full_v line,
8126: okc_line_styles_v style,
8127: okc_statuses_b sts
8128: WHERE line.lse_id = style.id
8129: AND style.lty_code = p_lty_code
8130: AND sts.code = line.sts_code
8131: AND sts.ste_code NOT IN ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 8243: OKC_STATUSES_B sts

8239: kle.id,
8240: ls.name line_style
8241: FROM OKL_K_LINES_FULL_V kle,
8242: OKC_LINE_STYLES_v ls,
8243: OKC_STATUSES_B sts
8244: WHERE kle.lse_id = ls.id
8245: AND ls.lty_code = ltycode
8246: AND kle.dnz_chr_id = chrid
8247: AND sts.code = kle.sts_code

Line 8264: OKC_STATUSES_B sts

8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
8261: SELECT kle.id
8262: FROM OKL_K_LINES_FULL_V kle,
8263: OKC_LINE_STYLES_v ls,
8264: OKC_STATUSES_B sts
8265: WHERE kle.lse_id = ls.id
8266: AND ls.lty_code = ltycode
8267: AND kle.dnz_chr_id = chrid
8268: AND sts.code = kle.sts_code

Line 9383: okc_statuses_b sts

9379: kle.residual_value
9380: FROM okc_k_lines_v cle,
9381: okl_k_lines kle,
9382: okc_line_styles_b sty,
9383: okc_statuses_b sts
9384: WHERE cle.lse_id = sty.id
9385: AND cle.dnz_chr_id = p_chr_id
9386: AND cle.id = kle.id
9387: AND lty_code = 'FREE_FORM1'

Line 11035: okc_statuses_b sts

11031: FROM okl_k_lines_full_v line,
11032: okc_k_items item,
11033: okl_strmtyp_source_v strm,
11034: okc_line_styles_v style,
11035: okc_statuses_b sts
11036: WHERE line.dnz_chr_id = p_chr_id
11037: AND line.lse_id = style.id
11038: AND line.sts_code = sts.code
11039: AND line.id = item.cle_id

Line 11053: okc_statuses_b sts

11049: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
11050: SELECT id,
11051: NVL(capital_amount,0) capital_amount
11052: FROM okl_k_lines_full_v line,
11053: okc_statuses_b sts
11054: WHERE line.cle_id = p_cle_id
11055: AND line.sts_code = sts.code
11056: --Bug# 4959361: Include Terminated lines when fetching sub-line amount
11057: --AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');

Line 11284: OKC_STATUSES_B sts

11280: kle.start_date,
11281: kle.end_date
11282: FROM OKL_K_LINES_FULL_V kle,
11283: OKC_LINE_STYLES_B ls,
11284: OKC_STATUSES_B sts
11285: WHERE kle.lse_id = ls.id
11286: AND ls.lty_code = ltycode
11287: AND kle.dnz_chr_id = chrid
11288: AND sts.code = kle.sts_code

Line 11443: okc_statuses_b sts

11439: SELECT line.id,
11440: line.name
11441: FROM okl_k_lines_full_v line,
11442: okc_line_styles_v style,
11443: okc_statuses_b sts
11444: WHERE line. dnz_chr_id = p_chr_id
11445: AND line.lse_id = style.id
11446: AND style.lty_code = 'FREE_FORM1'
11447: AND line.sts_code = sts.code

Line 12053: okc_statuses_b sts

12049: okc_line_styles_b fa_lse,
12050: OKL_TRX_ASSETS trx,
12051: okl_txl_assets_b txl,
12052: okl_txd_assets_v txd,
12053: okc_statuses_b sts
12054: WHERE cim.cle_id = fa.id
12055: AND cim.dnz_chr_id = p_chr_id
12056: AND fa.lse_id = fa_lse.id
12057: AND txd.tal_id = txl.id

Line 12532: okc_statuses_b sts,

12528: txl.depreciation_cost new_cost
12529: from okl_trx_assets trx,
12530: okl_txl_assets_b txl,
12531: okc_k_lines_b cleb,
12532: okc_statuses_b sts,
12533: fa_books fab,
12534: fa_additions fa
12535: where trx.id = txl.tas_id
12536: and trx.tsu_code = 'ENTERED'

Line 12933: okc_statuses_b sts

12929: CURSOR l_fin_ast_cle_csr (p_chr_id IN NUMBER) IS
12930: SELECT cle.id,
12931: cle.orig_system_id1
12932: FROM okc_k_lines_b cle,
12933: okc_statuses_b sts
12934: WHERE cle.chr_id = p_chr_id
12935: AND cle.lse_id = 33 --Financial Asset Line
12936: and sts.code = cle.sts_code
12937: and sts.ste_code NOT IN ('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');

Line 12948: okc_statuses_b sts

12944: cim.object1_id2
12945: FROM okc_k_lines_b cle,
12946: okc_k_items cim,
12947: okc_line_styles_b lse,
12948: okc_statuses_b sts
12949: WHERE cle.dnz_chr_id = p_chr_id
12950: AND cle.cle_id = p_cle_id
12951: AND cle.lse_id = lse.id
12952: AND lse.lty_code = p_lty_code

Line 13516: okc_statuses_b sts,

13512: txl.in_service_date in_service_date
13513: FROM okl_trx_assets trx,
13514: okl_txl_assets_b txl,
13515: okc_k_lines_b cleb_fa,
13516: okc_statuses_b sts,
13517: okc_k_lines_b cleb_fin,
13518: okl_k_lines kle_fin
13519: WHERE trx.id = txl.tas_id
13520: AND trx.tsu_code = 'ENTERED'

Line 13758: okc_statuses_b sts

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
13760: AND cleb_rbk.dnz_chr_id = p_chr_id
13761: AND cleb_rbk.lse_id = 33
13762: AND kle_rbk.id = cleb_rbk.id

Line 13779: okc_statuses_b sts

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
13781: AND cleb_rbk.dnz_chr_id = p_chr_id
13782: AND cleb_rbk.lse_id = 52
13783: AND kle_rbk.id = cleb_rbk.id

Line 13802: okc_statuses_b sts

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,
13802: okc_statuses_b sts
13803: WHERE cleb_rbk.chr_id = p_chr_id
13804: AND cleb_rbk.dnz_chr_id = p_chr_id
13805: AND cleb_rbk.lse_id = 52
13806: AND kle_rbk.id = cleb_rbk.id

Line 13982: okc_statuses_b sts

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
13986: AND clet_rbk.id = cleb_rbk.id

Line 14000: okc_statuses_b sts

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
14003: AND cleb_rbk.lse_id = 52
14004: AND kle_rbk.id = cleb_rbk.id

Line 14020: okc_statuses_b sts

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
14022: AND cleb_rbk.dnz_chr_id = p_chr_id
14023: AND cleb_rbk.lse_id = 52
14024: AND kle_rbk.id = cleb_rbk.id

Line 14180: okc_statuses_b sts

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
14183: AND cleb.lse_id = 33
14184: AND kle.id = cleb.id