[Home] [Help]
1856:
1857: --------------------------------------------------------------------------------
1858: --Start of Comments
1859: --Procedure Name : FIXED_ASSET_ADD
1860: --Description : Calls FA additions api to create new assets for
1861: -- and split children
1862: --History :
1863: -- 28-Nov-2001 ashish.singh Created
1864: --
2087:
2088: /*
2089: select asset_key_ccid
2090: into l_asset_desc_rec.asset_key_ccid
2091: from fa_additions
2092: where asset_id = p_ast_line_rec.asset_id;
2093: */
2094: l_asset_desc_rec.current_units := p_talv_rec.current_units;
2095:
2358:
2359: --------------------------------------------------------------------------------
2360: --Start of Comments
2361: --Procedure Name : FIXED_ASSET_ADD
2362: --Description : Calls FA additions api to create new assets for
2363: -- and split children
2364: --History :
2365: -- 28-Nov-2001 ashish.singh Created
2366: --
9088: select fab.*,
9089: fa.asset_category_id,
9090: fbc.book_class,
9091: fa.asset_number
9092: from fa_additions fa,
9093: fa_books fab,
9094: fa_book_controls fbc,
9095: okc_k_items cim,
9096: okc_k_lines_b cleb,
9185: txl.kle_id
9186: from okl_txl_Assets_b txl,
9187: fa_book_controls fbc,
9188: fa_category_book_defaults fcbd,
9189: fa_additions fa
9190: where fcbd.category_id = fa.asset_category_id
9191: and fcbd.book_type_code = txl.corporate_book
9192: and fa.asset_number = txl.asset_number
9193: and txl.in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,txl.in_service_date)
9292: p_book in varchar2) is
9293: select fab.*,
9294: fa.asset_category_id
9295: from fa_books fab,
9296: fa_additions fa
9297: where fab.book_type_code = p_book
9298: and fab.asset_id = fa.asset_id
9299: and fa.asset_number = p_asset_number
9300: and fab.transaction_header_id_out is null;