APPS.FA_XML_REPORT_PKG dependencies on FA_BOOKS

Line 572: l_fa_books_tb_name varchar2(30);

568: l_sob_name varchar2(30);
569: --l_period_counter number(15);
570: l_reporting_flag varchar2(1);
571: l_reporting_suffix varchar2(10);
572: l_fa_books_tb_name varchar2(30);
573: l_fa_dpr_sum_tb_name varchar2(30);
574: l_orig_set_of_books_id number(15);
575: l_orig_currency_context varchar2(15);
576:

Line 612: l_fa_books_tb_name := 'fa_mc_books';

608: raise FND_API.G_EXC_UNEXPECTED_ERROR;
609: end if;
610:
611: if l_reporting_flag = 'R' then
612: l_fa_books_tb_name := 'fa_mc_books';
613: l_fa_dpr_sum_tb_name := 'fa_mc_deprn_summary';
614: else
615: l_fa_books_tb_name := 'fa_books';
616: l_fa_dpr_sum_tb_name := 'fa_deprn_summary';

Line 615: l_fa_books_tb_name := 'fa_books';

611: if l_reporting_flag = 'R' then
612: l_fa_books_tb_name := 'fa_mc_books';
613: l_fa_dpr_sum_tb_name := 'fa_mc_deprn_summary';
614: else
615: l_fa_books_tb_name := 'fa_books';
616: l_fa_dpr_sum_tb_name := 'fa_deprn_summary';
617: end if;
618:
619:

Line 661: from fa_books bk

657: where cgu.book_type_code = p_book_type_code
658: and cgu.cash_generating_unit_id = nvl(p_cash_gen_unit_id, cgu.cash_generating_unit_id)
659: and cgu.cash_generating_unit_id
660: in (select bk.cash_generating_unit_id
661: from fa_books bk
662: where bk.book_type_code = p_book_type_code
663: and bk.transaction_header_id_out is null
664: and bk.asset_id = nvl(p_asset_id, bk.asset_id)
665: );

Line 735: ,'||l_fa_books_tb_name||' bk

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
739: and bk.asset_id = ad.asset_id