DBA Data[Home] [Help]

APPS.FA_XML_REPORT_PKG dependencies on FA_ADDITIONS_B

Line 319: ,FA_ADDITIONS_B AD

315: ,AD.ASSET_NUMBER
316: ,IMP.IMPAIRMENT_ID
317: FROM FA_IMPAIRMENTS IMP
318: ,FA_CASH_GEN_UNITS CGU
319: ,FA_ADDITIONS_B AD
320: WHERE IMP.CASH_GENERATING_UNIT_ID = CGU.CASH_GENERATING_UNIT_ID(+)
321: AND IMP.GOODWILL_ASSET_ID = AD.ASSET_ID(+)
322: AND IMP.BOOK_TYPE_CODE = p_book_type_code
323: AND IMP.PERIOD_COUNTER_IMPAIRED = p_period_counter

Line 340: ,FA_ADDITIONS_B AD

336: ,AD.ASSET_NUMBER
337: ,IMP.IMPAIRMENT_ID
338: FROM FA_MC_IMPAIRMENTS IMP
339: ,FA_CASH_GEN_UNITS CGU
340: ,FA_ADDITIONS_B AD
341: WHERE IMP.CASH_GENERATING_UNIT_ID = CGU.CASH_GENERATING_UNIT_ID(+)
342: AND IMP.GOODWILL_ASSET_ID = AD.ASSET_ID(+)
343: AND IMP.BOOK_TYPE_CODE = p_book_type_code
344: AND IMP.PERIOD_COUNTER_IMPAIRED = p_period_counter

Line 463: ,FA_ADDITIONS_B AD

459: ITF.split3_loss_amount
460: ,ITF.NET_SELLING_PRICE NET_SELLING_PRICE
461: ,ITF.VALUE_IN_USE VALUE_IN_USE
462: FROM '||l_reporting_suffix||' ITF
463: ,FA_ADDITIONS_B AD
464: WHERE ITF.ASSET_ID = AD.ASSET_ID
465: AND ITF.BOOK_TYPE_CODE = '''||p_book_type_code||'''
466: AND NVL(ITF.cash_generating_unit_id,-99) = '''||r_CGU_id||'''
467: AND ITF.REQUEST_ID = nvl( '''||p_request_id||''', ITF.REQUEST_ID)

Line 734: from fa_additions_b ad

730: ,bk.cost as cost
731: ,bk.cost - ds.deprn_reserve - ds.impairment_reserve as net_book_value
732: ,ds.impairment_reserve as accumulated_impairment
733: ,ds.ytd_impairment as ytd_impairment
734: from fa_additions_b ad
735: ,'||l_fa_books_tb_name||' bk
736: ,'||l_fa_dpr_sum_tb_name||' ds
737: where bk.book_type_code = '''||p_book_type_code||'''
738: and ds.book_type_code = bk.book_type_code