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_ACTIVATE_IB_PVT dependencies on OKC_STATUSES_B

Line 1951: okc_statuses_b sts -- 4698117

1947: Cursor ib_line_csr(p_chrv_id IN Number) is
1948: SELECT cle.id,
1949: cle.cle_id
1950: from okc_k_lines_b cle,
1951: okc_statuses_b sts -- 4698117
1952: where cle.lse_id = G_IB_LINE_LTY_ID
1953: and cle.dnz_chr_id = p_chrv_id
1954: and cle.sts_code = sts.code
1955: and sts.ste_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 2242: from OKC_STATUSES_B sts

2238: and inst_cle_lse.id = inst_cle.lse_id
2239: and inst_cle_lse.lty_code = 'FREE_FORM2'
2240: and inst_cle.cle_id = p_fin_ast_cle_id
2241: AND not exists (select '1'
2242: from OKC_STATUSES_B sts
2243: Where sts.code = cle.sts_code
2244: --Bug#2522268
2245: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'))
2246: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'))

Line 2248: from OKC_STATUSES_B sts2

2244: --Bug#2522268
2245: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'))
2246: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'))
2247: AND not exists (select '1'
2248: from OKC_STATUSES_B sts2
2249: Where sts2.code = inst_cle.sts_code
2250: --Bug#2522268
2251: --And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
2252: And sts2.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));

Line 2476: okc_statuses_b stsb,

2472: cleb_ib.id cleb_ib_id
2473: From okc_k_items cim_ib,
2474: okc_k_lines_b cleb_ib,
2475: okc_line_styles_b lseb_ib,
2476: okc_statuses_b stsb,
2477: okl_txl_itm_insts iti,
2478: okl_trx_assets trx,
2479: okl_trx_types_tl ttyt
2480: where iti.kle_id = cleb_ib.id

Line 2955: okc_statuses_b inst_sts

2951: SELECT ib_cle.id,
2952: ib_cle.cle_id
2953: from okc_k_lines_b ib_cle,
2954: okc_k_lines_b inst_cle,
2955: okc_statuses_b inst_sts
2956: where ib_cle.lse_id = G_IB_LINE_LTY_ID
2957: and ib_cle.dnz_chr_id = p_chrv_id
2958: AND inst_sts.code = ib_cle.sts_code
2959: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')

Line 2994: okc_statuses_b inst_sts,

2990: orig_ib_cle.orig_system_id1 rbk_ib_cle_id
2991: FROM okc_k_lines_b orig_ib_cle,
2992: okc_k_lines_b orig_inst_cle,
2993: okc_k_lines_b rbk_inst_cle,
2994: okc_statuses_b inst_sts,
2995: --Bug# 8766336
2996: okc_statuses_b rbk_inst_sts
2997: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
2998: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id

Line 2996: okc_statuses_b rbk_inst_sts

2992: okc_k_lines_b orig_inst_cle,
2993: okc_k_lines_b rbk_inst_cle,
2994: okc_statuses_b inst_sts,
2995: --Bug# 8766336
2996: okc_statuses_b rbk_inst_sts
2997: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
2998: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
2999: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID
3000: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 3025: okc_statuses_b inst_sts

3021: orig_ib_cim.object1_id1 instance_id
3022: FROM okc_k_items orig_ib_cim,
3023: okc_k_lines_b orig_ib_cle,
3024: okc_k_lines_b orig_inst_cle,
3025: okc_statuses_b inst_sts
3026: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3027: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
3028: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID
3029: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 3040: okc_statuses_b rbk_inst_sts

3036: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
3037: AND NOT EXISTS (
3038: SELECT 1
3039: FROM okc_k_lines_b rbk_inst_cle,
3040: okc_statuses_b rbk_inst_sts
3041: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
3042: AND rbk_inst_cle.lse_id = G_INST_LINE_LTY_ID
3043: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id
3044: AND rbk_inst_cle.cle_id = p_rbk_fin_ast_cle_id

Line 3063: okc_statuses_b inst_sts,

3059: FROM okc_k_lines_b orig_ib_cle,
3060: okc_k_lines_b orig_inst_cle,
3061: okc_k_lines_b rbk_inst_cle,
3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,
3064: okc_k_items ib_cim,
3065: --Bug# 8766336
3066: okc_statuses_b rbk_inst_sts
3067: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id

Line 3066: okc_statuses_b rbk_inst_sts

3062: okc_k_lines_b rbk_ib_cle,
3063: okc_statuses_b inst_sts,
3064: okc_k_items ib_cim,
3065: --Bug# 8766336
3066: okc_statuses_b rbk_inst_sts
3067: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3068: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
3069: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID
3070: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 3119: okc_statuses_b inst_sts

3115: FROM csi_item_instances csi_item,
3116: okc_k_items ib_cim,
3117: okc_k_lines_b ib_cle,
3118: okc_k_lines_b inst_cle,
3119: okc_statuses_b inst_sts
3120: WHERE ib_cim.cle_id = ib_cle.id
3121: AND ib_cim.dnz_chr_id = p_chr_id
3122: AND inst_cle.cle_id = p_fin_ast_cle_id
3123: AND inst_cle.lse_id = G_INST_LINE_LTY_ID