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 2449: okc_statuses_b stsb,

2445: cleb_ib.id cleb_ib_id
2446: From okc_k_items cim_ib,
2447: okc_k_lines_b cleb_ib,
2448: okc_line_styles_b lseb_ib,
2449: okc_statuses_b stsb,
2450: okl_txl_itm_insts iti,
2451: okl_trx_assets trx,
2452: okl_trx_types_tl ttyt
2453: where iti.kle_id = cleb_ib.id

Line 2928: okc_statuses_b inst_sts

2924: SELECT ib_cle.id,
2925: ib_cle.cle_id
2926: from okc_k_lines_b ib_cle,
2927: okc_k_lines_b inst_cle,
2928: okc_statuses_b inst_sts
2929: where ib_cle.lse_id = G_IB_LINE_LTY_ID
2930: and ib_cle.dnz_chr_id = p_chrv_id
2931: AND inst_sts.code = ib_cle.sts_code
2932: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')

Line 2967: okc_statuses_b inst_sts

2963: orig_ib_cle.orig_system_id1 rbk_ib_cle_id
2964: FROM okc_k_lines_b orig_ib_cle,
2965: okc_k_lines_b orig_inst_cle,
2966: okc_k_lines_b rbk_inst_cle,
2967: okc_statuses_b inst_sts
2968: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
2969: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
2970: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID
2971: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 2993: okc_statuses_b inst_sts

2989: orig_ib_cim.object1_id1 instance_id
2990: FROM okc_k_items orig_ib_cim,
2991: okc_k_lines_b orig_ib_cle,
2992: okc_k_lines_b orig_inst_cle,
2993: okc_statuses_b inst_sts
2994: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
2995: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
2996: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID
2997: AND orig_ib_cle.cle_id = orig_inst_cle.id

Line 3008: okc_statuses_b rbk_inst_sts

3004: AND inst_sts.ste_code NOT IN ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')
3005: AND NOT EXISTS (
3006: SELECT 1
3007: FROM okc_k_lines_b rbk_inst_cle,
3008: okc_statuses_b rbk_inst_sts
3009: WHERE rbk_inst_cle.orig_system_id1 = orig_inst_cle.id
3010: AND rbk_inst_cle.lse_id = G_INST_LINE_LTY_ID
3011: AND rbk_inst_cle.dnz_chr_id = p_rbk_chr_id
3012: AND rbk_inst_cle.cle_id = p_rbk_fin_ast_cle_id

Line 3031: okc_statuses_b inst_sts,

3027: FROM okc_k_lines_b orig_ib_cle,
3028: okc_k_lines_b orig_inst_cle,
3029: okc_k_lines_b rbk_inst_cle,
3030: okc_k_lines_b rbk_ib_cle,
3031: okc_statuses_b inst_sts,
3032: okc_k_items ib_cim
3033: WHERE orig_inst_cle.dnz_chr_id = p_orig_chr_id
3034: AND orig_inst_cle.cle_id = p_orig_fin_ast_cle_id
3035: AND orig_inst_cle.lse_id = G_INST_LINE_LTY_ID

Line 3082: okc_statuses_b inst_sts

3078: FROM csi_item_instances csi_item,
3079: okc_k_items ib_cim,
3080: okc_k_lines_b ib_cle,
3081: okc_k_lines_b inst_cle,
3082: okc_statuses_b inst_sts
3083: WHERE ib_cim.cle_id = ib_cle.id
3084: AND ib_cim.dnz_chr_id = p_chr_id
3085: AND inst_cle.cle_id = p_fin_ast_cle_id
3086: AND inst_cle.lse_id = G_INST_LINE_LTY_ID