[Home] [Help]
1852:
1853: --------------------------------------------------------------------------------
1854: --Start of Comments
1855: --Procedure Name : FIXED_ASSET_ADD
1856: --Description : Calls FA additions api to create new assets for
1857: -- and split children
1858: --History :
1859: -- 28-Nov-2001 ashish.singh Created
1860: --
2083:
2084: /*
2085: select asset_key_ccid
2086: into l_asset_desc_rec.asset_key_ccid
2087: from fa_additions
2088: where asset_id = p_ast_line_rec.asset_id;
2089: */
2090: l_asset_desc_rec.current_units := p_talv_rec.current_units;
2091:
2354:
2355: --------------------------------------------------------------------------------
2356: --Start of Comments
2357: --Procedure Name : FIXED_ASSET_ADD
2358: --Description : Calls FA additions api to create new assets for
2359: -- and split children
2360: --History :
2361: -- 28-Nov-2001 ashish.singh Created
2362: --
9363: select fab.*,
9364: fa.asset_category_id,
9365: fbc.book_class,
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,
9460: txl.kle_id
9461: from okl_txl_Assets_b txl,
9462: fa_book_controls fbc,
9463: fa_category_book_defaults fcbd,
9464: fa_additions fa
9465: where fcbd.category_id = fa.asset_category_id
9466: and fcbd.book_type_code = txl.corporate_book
9467: and fa.asset_number = txl.asset_number
9468: and txl.in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,txl.in_service_date)
9567: p_book in varchar2) is
9568: select fab.*,
9569: fa.asset_category_id
9570: from fa_books fab,
9571: fa_additions fa
9572: where fab.book_type_code = p_book
9573: and fab.asset_id = fa.asset_id
9574: and fa.asset_number = p_asset_number
9575: and fab.transaction_header_id_out is null;