APPS.FA_MC_UPG2_PKG dependencies on FA_MC_BOOKS

Line 17: converted and insert them into fa_mc_books. All amount columns will be

13:
14: l_count number;
15: /* ************************************************************************
16: This procedure will select all the rows in fa_books for each asset being
17: converted and insert them into fa_mc_books. All amount columns will be
18: converted either with the exchange rate or a derived rate of
19: cost/primary_cur_cost based on the conversion basis of R or C.
20: The converted amounts will also be rounded using the precision and
21: minimum accountable unti of the reporting currency

Line 32: INSERT INTO fa_mc_books(

28: 'Converting FA_BOOKS records',
29: 'start');
30: end if;
31:
32: INSERT INTO fa_mc_books(
33: set_of_books_id,
34: asset_id,
35: book_type_code,
36: transaction_header_id_in,

Line 787: 'Inserting into FA_MC_BOOKS_RATES',

783: BEGIN
784:
785: if (g_print_debug) then
786: fa_debug_pkg.add('convert_assets',
787: 'Inserting into FA_MC_BOOKS_RATES',
788: 'start');
789: end if;
790:
791: INSERT INTO fa_mc_books_rates

Line 791: INSERT INTO fa_mc_books_rates

787: 'Inserting into FA_MC_BOOKS_RATES',
788: 'start');
789: end if;
790:
791: INSERT INTO fa_mc_books_rates
792: (set_of_books_id,
793: asset_id,
794: book_type_code,
795: transaction_header_id,

Line 839: fa_mc_books mcbk,

835: mcbk.last_update_date,
836: mcbk.last_update_login,
837: 'Y'
838: FROM
839: fa_mc_books mcbk,
840: fa_books bk,
841: fa_mc_conversion_rates cr
842:
843: WHERE

Line 858: 'Insered into FA_MC_BOOKS_RATES',

854: mcbk.book_type_code = bk.book_type_code;
855:
856: if (g_print_debug) then
857: fa_debug_pkg.add('convert_assets',
858: 'Insered into FA_MC_BOOKS_RATES',
859: 'success');
860: end if;
861:
862:

Line 1767: calculated using a ratio of cost in fa_mc_books * cost in fa_books/

1763: convert_order is L, only the last DEPRN in a prior fiscal year is
1764: converted.
1765: The rows in fa_deprn_summary are fetched one at a time and ordered by
1766: asset_id and period_counter. The deprn_amount column for pc is
1767: calculated using a ratio of cost in fa_mc_books * cost in fa_books/
1768: deprn_amount in primary currency. deprn_reserve and ytd_deprn for the
1769: first period_counter in the current year are also calulated the same way.
1770: For subsequent period counters the deprn_amount for current period is
1771: added to deprn_reserve of previous period. This is necessary to round

Line 1908: fa_mc_books mcbk,

1904: ds.deprn_override_flag
1905: FROM
1906: fa_deprn_summary ds,
1907: fa_deprn_periods dp,
1908: fa_mc_books mcbk,
1909: fa_books bk,
1910: fa_mc_conversion_rates cr
1911: WHERE
1912: ds.asset_id = mcbk.asset_id AND

Line 2067: fa_mc_books mcbk,

2063: ds.deprn_override_flag
2064: FROM
2065: fa_deprn_summary ds,
2066: fa_deprn_periods dp,
2067: fa_mc_books mcbk,
2068: fa_books bk,
2069: fa_mc_conversion_rates cr
2070: WHERE
2071: ds.asset_id = mcbk.asset_id AND

Line 2345: fa_mc_books mcbk,

2341: ds.deprn_override_flag
2342: FROM
2343: fa_deprn_summary ds,
2344: fa_deprn_periods dp,
2345: fa_mc_books mcbk,
2346: fa_books bk,
2347: fa_mc_conversion_rates cr
2348: WHERE
2349: cr.book_type_code = p_book_type_code AND

Line 2469: index(mcbk fa_mc_books_u1)

2465: index(dd fa_deprn_detail_n1)
2466: index(dh fa_distribution_history_u1)
2467: index(dp fa_deprn_periods_u3)
2468: index(bk fa_books_n1)
2469: index(mcbk fa_mc_books_u1)
2470: index(ah fa_asset_history_n2) */
2471: dd.book_type_code,
2472: dd.asset_id,
2473: dd.distribution_id,

Line 2541: fa_mc_books mcbk,

2537: fa_mc_deprn_summary ds,
2538: fa_deprn_detail dd,
2539: fa_deprn_periods dp,
2540: fa_books bk,
2541: fa_mc_books mcbk,
2542: fa_distribution_history dh,
2543: fa_asset_history ah,
2544: fa_mc_conversion_rates cr
2545: WHERE