DBA Data[Home] [Help]

APPS.FA_MASSADD_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 2286: fa_category_book_defaults cbd

2282: mad.description,
2283: mad.fixed_assets_units,
2284: mad.units_to_adjust
2285: from fa_mass_additions mad,
2286: fa_category_book_defaults cbd
2287: where mad.book_type_code = p_book_type_code
2288: and mad.posting_status = 'POST'
2289: and mad.add_to_asset_id is null
2290: and mad.merge_parent_mass_additions_id is null

Line 2316: fa_category_book_defaults cbd

2312: mad.description,
2313: mad.fixed_assets_units,
2314: mad.units_to_adjust
2315: from fa_mass_additions mad,
2316: fa_category_book_defaults cbd
2317: where mad.book_type_code = p_book_type_code
2318: and mad.posting_status = 'POST'
2319: and mad.add_to_asset_id is null
2320: and mad.merge_parent_mass_additions_id is null

Line 2480: from fa_category_book_defaults cbd

2476:
2477: update fa_mass_additions mad
2478: set group_asset_id =
2479: (select cbd.group_asset_id
2480: from fa_category_book_defaults cbd
2481: where mad.asset_category_id = cbd.category_id
2482: and mad.book_type_code = p_book_type_code
2483: and cbd.book_type_code = p_book_type_code
2484: and mad.date_placed_in_service between

Line 2519: from fa_category_book_defaults cbd

2515:
2516: update fa_mass_additions mad
2517: set group_asset_id =
2518: (select cbd.group_asset_id
2519: from fa_category_book_defaults cbd
2520: where mad.asset_category_id = cbd.category_id
2521: and mad.book_type_code = p_book_type_code
2522: and cbd.book_type_code = p_book_type_code
2523: and mad.date_placed_in_service between