[Home] [Help]
288: , asset_hierarchy_purpose_id
289: , hierarchy_rule_set_id
290: , parent_hierarchy_id
291: , depreciation_start_date
292: from fa_asset_hierarchy
293: where asset_id is not null
294: and level_number = 0
295: start with asset_hierarchy_id = to_number(x_src_entity_value)
296: connect by prior asset_hierarchy_id = parent_hierarchy_id;
307: , iah.parent_hierarchy_id
308: , iah.hierarchy_rule_Set_id
309: from fa_additions fa
310: , fa_books fb
311: , fa_asset_hierarchy iah
312: where fa.asset_id = p_asset_id
313: and fa.asset_id = fb.asset_id
314: and fb.book_type_code = x_book_type_code
315: and fb.date_ineffective is null
332: , fb.life_in_months
333: , fb.book_type_code
334: from fa_additions fa
335: , fa_books fb
336: , fa_asset_hierarchy iah
337: where fa.asset_category_id = to_number(x_src_entity_value)
338: and fa.asset_id = fb.asset_id
339: and fb.book_type_code = x_book_type_code
340: and fb.date_ineffective is null
357: , fb.life_in_months
358: , fb.book_type_code
359: from fa_additions fa
360: , fa_books fb
361: , fa_asset_hierarchy iah
362: where fa.lease_id = to_number(x_src_entity_value)
363: and fa.asset_id = fb.asset_id
364: and fb.date_ineffective is null
365: and fb.book_type_code = x_book_type_code
379: , iah.parent_hierarchy_id
380: , iah.hierarchy_rule_Set_id
381: from fa_additions fa
382: , fa_books fb
383: , fa_asset_hierarchy iah
384: where fa.asset_id = to_number(x_src_entity_value)
385: and fa.asset_id = fb.asset_id
386: and fb.date_ineffective is null
387: and fb.book_type_code = x_book_type_code
486: fa_cua_asset_apis.g_asset_array(i).rule_set_id:= assets_attr_rec.asset_id;
487: fa_cua_asset_apis.g_asset_array(i).parent_hierarchy_id_old:= assets_rec.parent_hierarchy_id;
488: end loop;
489: -- update the asset_parent with the new parent_id
490: update fa_asset_hierarchy
491: set parent_hierarchy_id = x_parent_id_new
492: where asset_id = assets_rec.asset_id;
493: end loop;
494: elsif x_book_class = 'TAX' then