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 726: 'Inserting into FA_MC_BOOKS_RATES',

722: BEGIN
723:
724: if (g_print_debug) then
725: fa_debug_pkg.add('convert_assets',
726: 'Inserting into FA_MC_BOOKS_RATES',
727: 'start');
728: end if;
729:
730: INSERT INTO fa_mc_books_rates

Line 730: INSERT INTO fa_mc_books_rates

726: 'Inserting into FA_MC_BOOKS_RATES',
727: 'start');
728: end if;
729:
730: INSERT INTO fa_mc_books_rates
731: (set_of_books_id,
732: asset_id,
733: book_type_code,
734: transaction_header_id,

Line 778: fa_mc_books mcbk,

774: mcbk.last_update_date,
775: mcbk.last_update_login,
776: 'Y'
777: FROM
778: fa_mc_books mcbk,
779: fa_books bk,
780: fa_mc_conversion_rates cr
781:
782: WHERE

Line 797: 'Insered into FA_MC_BOOKS_RATES',

793: mcbk.book_type_code = bk.book_type_code;
794:
795: if (g_print_debug) then
796: fa_debug_pkg.add('convert_assets',
797: 'Insered into FA_MC_BOOKS_RATES',
798: 'success');
799: end if;
800:
801:

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

1672: convert_order is L, only the last DEPRN in a prior fiscal year is
1673: converted.
1674: The rows in fa_deprn_summary are fetched one at a time and ordered by
1675: asset_id and period_counter. The deprn_amount column for pc is
1676: calculated using a ratio of cost in fa_mc_books * cost in fa_books/
1677: deprn_amount in primary currency. deprn_reserve and ytd_deprn for the
1678: first period_counter in the current year are also calulated the same way.
1679: For subsequent period counters the deprn_amount for current period is
1680: added to deprn_reserve of previous period. This is necessary to round

Line 1815: fa_mc_books mcbk,

1811: ds.deprn_reserve
1812: FROM
1813: fa_deprn_summary ds,
1814: fa_deprn_periods dp,
1815: fa_mc_books mcbk,
1816: fa_books bk,
1817: fa_mc_conversion_rates cr
1818: WHERE
1819: ds.asset_id = mcbk.asset_id AND

Line 1972: fa_mc_books mcbk,

1968: 'Y'
1969: FROM
1970: fa_deprn_summary ds,
1971: fa_deprn_periods dp,
1972: fa_mc_books mcbk,
1973: fa_books bk,
1974: fa_mc_conversion_rates cr
1975: WHERE
1976: ds.asset_id = mcbk.asset_id AND

Line 2245: fa_mc_books mcbk,

2241: 'Y'
2242: FROM
2243: fa_deprn_summary ds,
2244: fa_deprn_periods dp,
2245: fa_mc_books mcbk,
2246: fa_books bk,
2247: fa_mc_conversion_rates cr
2248: WHERE
2249: cr.book_type_code = p_book_type_code AND

Line 2363: index(mcbk fa_mc_books_u1)

2359: index(dd fa_deprn_detail_n1)
2360: index(dh fa_distribution_history_u1)
2361: index(dp fa_deprn_periods_u3)
2362: index(bk fa_books_n1)
2363: index(mcbk fa_mc_books_u1)
2364: index(ah fa_asset_history_n2) */
2365: dd.book_type_code,
2366: dd.asset_id,
2367: dd.distribution_id,

Line 2429: fa_mc_books mcbk,

2425: fa_mc_deprn_summary ds,
2426: fa_deprn_detail dd,
2427: fa_deprn_periods dp,
2428: fa_books bk,
2429: fa_mc_books mcbk,
2430: fa_distribution_history dh,
2431: fa_asset_history ah,
2432: fa_mc_conversion_rates cr
2433: WHERE