DBA Data[Home] [Help]

APPS.FA_CUA_DERIVE_ASSET_ATTR_PKG dependencies on FA_BOOKS

Line 310: , fa_books fb

306: , fb.book_type_code
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

Line 335: , fa_books fb

331: , fa.lease_id
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

Line 360: , fa_books fb

356: , fa.lease_id
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

Line 382: , fa_books fb

378: , fb.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