[Home] [Help]
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
339: AND fa_cle.dnz_chr_id = chrId
4526: okl_k_lines top_kle,
4527: okc_k_lines_b item,
4528: okc_line_styles_b item_style,
4529: okc_line_styles_b top_style,
4530: okc_k_items kitem,
4531: mtl_system_items mtl
4532: WHERE top.dnz_chr_id = p_chr_id
4533: AND top.lse_id = top_style.id
4534: AND top_style.lty_code = 'FREE_FORM1'
4694: cim.object1_id1,
4695: cim.object1_id2,
4696: cim.jtot_object1_code,
4697: cim.number_of_items
4698: FROM okc_k_items_v cim
4699: WHERE cle_id = p_cle_id;
4700:
4701:
4702: CURSOR okl_iipv_csr (p_kle_id NUMBER) IS
7031:
7032: CURSOR l_fee_strm_csr (chrid OKL_K_HEADERS.KHR_ID%TYPE,
7033: lineid OKC_K_LINES_B.ID%TYPE) IS
7034: SELECT itm.object1_id1
7035: FROM okc_k_items itm
7036: WHERE cle_id = lineid
7037: AND dnz_chr_id = chrid
7038: AND jtot_object1_code = 'OKL_STRMTYP';
7039:
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
7556: AND ib_cle.dnz_chr_id = p_chr_id
7565: p_cle_id IN NUMBER) IS
7566: SELECT cim.object1_id1,
7567: cim.object1_id2,
7568: cim.number_of_items
7569: FROM okc_k_items cim
7570: WHERE cim.cle_id = p_cle_id
7571: AND cim.dnz_chr_id = p_chr_id;
7572:
7573: l_rbk_item_rec l_item_csr%ROWTYPE;
7577: p_rbk_fin_ast_cle_id IN NUMBER,
7578: p_orig_chr_id IN NUMBER,
7579: p_rbk_chr_id IN NUMBER) IS
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
7607: CURSOR check_svc_chr(p_object1_id1 IN VARCHAR2,
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
7624: p_jtot_object_code IN VARCHAR2,
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
9535: /* Bug 3825314
9536: *
9537: * Cursor l_synd_csr ( chrId NUMBER ) IS
9538: * select kl.dnz_chr_id syndId
9539: * from OKC_K_ITEMS_V ITM,
9540: * OKC_K_LINES_V KL,
9541: * OKL_K_HEADERS_FULL_V KHR,
9542: * OKC_LINE_STYLES_B lse
9543: * where KL.LSE_ID=lse.id
11028: NVL(line.capital_amount,0) capital_amount,
11029: line.start_date,
11030: strm.code strm_type
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
11060: --Bug#3877032
11061: CURSOR link_asset_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
11062: SELECT line.start_date
11063: FROM okc_k_lines_b line,
11064: okc_k_items item
11065: WHERE item.cle_id = p_line_id
11066: AND item.object1_id1 = line.id
11067: AND item.object1_id2 = '#'
11068: AND line.dnz_chr_id = p_chr_id
12043: CURSOR l_assets_txl_lines IS
12044: SELECT txl.asset_number asset_num,
12045: fa.id fa_id,
12046: txd.tax_book
12047: FROM okc_k_items cim,
12048: okc_k_lines_V fa,
12049: okc_line_styles_b fa_lse,
12050: OKL_TRX_ASSETS trx,
12051: okl_txl_assets_b txl,
12942: SELECT cle.id,
12943: cim.object1_id1,
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