[Home] [Help]
198: --------------------------------------------------------------------------------------------------------
199: --Bug# 5946411 End
200: ------------------------------------------------------------------------------------------------------
201: ---------------------------------------------------------------------------
202: -- FUNCTION get_rec for: OKC_K_ITEMS_V
203: ---------------------------------------------------------------------------
204: FUNCTION get_cimv_rec (p_cle_id IN NUMBER,
205: x_no_data_found OUT NOCOPY BOOLEAN
206: ) RETURN cimv_rec_type IS
225: cim.CREATION_DATE,
226: cim.LAST_UPDATED_BY,
227: cim.LAST_UPDATE_DATE,
228: cim.LAST_UPDATE_LOGIN
229: FROM Okc_K_Items_V cim
230: where cle_id = p_cle_id;
231:
232: l_cimv_rec cimv_rec_type;
233: BEGIN
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,
1785: OKC_K_ITEMS cov_ast_cim,
1786: OKC_K_LINES_B fa_cle,
1787: OKC_K_LINES_B src_cle
1788: Where fee_kle.id = fee_cle.id
1789: and fee_kle.fee_type = 'CAPITALIZED'
1911: --CURSOR to fetch expense account id
1912: CURSOR exp_act_csr (p_kle_id IN NUMBER) IS
1913: SELECT msi.expense_account
1914: FROM MTL_SYSTEM_ITEMS msi,
1915: OKC_K_ITEMS cim,
1916: OKC_K_LINES_B mdl,
1917: OKC_K_LINES_B fal
1918: WHERE cim.object1_id1 = msi.inventory_item_id
1919: AND cim.object1_id2 = to_char(msi.organization_id)
4463: RAISE OKL_API.G_EXCEPTION_ERROR;
4464: END IF;
4465: --End Bug# 4028371
4466: End If;--if asset transaction records found
4467: End If; --if unplugged okc_k_items records for fa line
4468: End If; --fa line is found
4469: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
4470: EXCEPTION
4471: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5263: p_effective_date IN DATE) IS
5264: Select '!'
5265: from OKC_K_LINES_B cle,
5266: OKC_STATUSES_B sts,
5267: OKC_K_ITEMS cim
5268: Where cle.sts_code = sts.CODE
5269: --Bug# 2942543 : effectivity should be checked by keeping start and end date as inclusive
5270: --And nvl(sts.start_date,p_effective_date) <= p_effective_date
5271: --And nvl(sts.end_date,p_effective_date+1) > p_effective_date
6543: p_effective_date IN DATE) IS
6544: Select '!'
6545: from OKC_K_LINES_B cle,
6546: OKC_STATUSES_B sts,
6547: OKC_K_ITEMS cim
6548: Where cle.sts_code = sts.CODE
6549: --Bug# 2942543 : effectivity should be checked by keeping start and end date as inclusive
6550: --And nvl(sts.start_date,p_effective_date) <= p_effective_date
6551: --And nvl(sts.end_date,p_effective_date+1) > p_effective_date
7683: fa_books fab,
7684: --Bug# 6373605 start
7685: fa_book_controls fbc,
7686: --Bug# 6373605 end
7687: okc_k_items fa_cim,
7688: okl_trx_types_tl ttyp,
7689: okl_trx_assets trx,
7690: okl_txl_assets_b txl,
7691: okc_k_lines_b fa_cleb,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,
7878: OKC_STATUSES_B cov_ast_sts,
7879: OKC_K_ITEMS cov_ast_cim,
7880: OKC_K_LINES_B fa_cle
7881: Where fee_kle.id = fee_cle.id
7882: and fee_kle.fee_type = 'CAPITALIZED'
7883: and fee_cle.id = cov_ast_cle.cle_id
9366: fa.asset_number
9367: from fa_additions fa,
9368: fa_books fab,
9369: fa_book_controls fbc,
9370: okc_k_items cim,
9371: okc_k_lines_b cleb,
9372: okc_line_styles_b lseb
9373: where fab.asset_id = fa.asset_id
9374: and fab.transaction_header_id_out is null
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,
9619: OKC_STATUSES_B cov_ast_sts,
9620: OKC_K_ITEMS cov_ast_cim
9621: Where fee_kle.id = fee_cle.id
9622: and fee_kle.fee_type = 'CAPITALIZED'
9623: and fee_cle.dnz_chr_id = p_chr_id
9624: and fee_cle.chr_id = p_chr_id