APPS.FA_RX_GROUP dependencies on FA_MC_BOOKS

Line 573: FROM fa_mc_books bk,

569: -- MRC
570: else
571: SELECT SUM(bk.cost - bk_old.cost)
572: INTO l_group_reclass_cost_in_out
573: FROM fa_mc_books bk,
574: fa_mc_books bk_old,
575: fa_transaction_headers fth,
576: fa_mc_book_controls bc,
577: fa_book_controls bc1,

Line 574: fa_mc_books bk_old,

570: else
571: SELECT SUM(bk.cost - bk_old.cost)
572: INTO l_group_reclass_cost_in_out
573: FROM fa_mc_books bk,
574: fa_mc_books bk_old,
575: fa_transaction_headers fth,
576: fa_mc_book_controls bc,
577: fa_book_controls bc1,
578: fa_mc_deprn_periods dp

Line 1005: fa_mc_books bk,

1001: -- MRC
1002: else
1003: x_sql_stmt := ' FROM
1004: fa_additions ad,
1005: fa_mc_books bk,
1006: fa_categories_b cat,
1007: fa_deprn_basis_rules br,
1008: fa_methods met,
1009: fa_mc_deprn_periods dp,

Line 1016: FROM fa_mc_books bk_pre,

1012: bk_pre.group_asset_id,
1013: bk_pre.cost,
1014: bk_pre.cip_cost,
1015: ds_pre.deprn_reserve
1016: FROM fa_mc_books bk_pre,
1017: fa_mc_deprn_summary ds_pre,
1018: fa_mc_deprn_periods dp_pre,
1019: fa_additions ad_pre
1020: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''

Line 1321: fa_mc_books bkm

1317: fa_mc_book_controls bc,
1318: fa_book_controls bc1,
1319: fa_fiscal_year fy,
1320: fa_transaction_headers thm,
1321: fa_mc_books bkm
1322: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1323: AND adj.asset_id = bkm.asset_id
1324: AND bkm.transaction_header_id_in = thm.transaction_header_id
1325: AND adj.book_type_code = ''' || p_info_rec.book_type_code || '''

Line 1406: fa_mc_books bkm

1402: FROM fa_mc_retirements ret,
1403: fa_mc_book_controls bc,
1404: fa_fiscal_year fy,
1405: fa_transaction_headers thm,
1406: fa_mc_books bkm
1407: WHERE bkm.group_asset_id = ' || p_group_asset_id || '
1408: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''
1409: AND fy.fiscal_year = ' || p_info_rec.fiscal_year || '
1410: AND fy.fiscal_year_name = bc.fiscal_year_name

Line 1718: fa_mc_books bkm

1714: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1715: INTO l_group_reclass_out
1716: FROM fa_mc_adjustments adj,
1717: fa_transaction_headers thg,
1718: fa_mc_books bkm
1719: WHERE adj.asset_id = p_group_rec.asset_id
1720: AND adj.book_type_code = p_info_rec.book_type_code
1721: AND thg.transaction_header_id = adj.transaction_header_id
1722: AND adj.period_counter_created

Line 1776: fa_mc_books bkm

1772: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1773: INTO l_group_reclass_in
1774: FROM fa_mc_adjustments adj,
1775: fa_transaction_headers thg,
1776: fa_mc_books bkm
1777: WHERE adj.asset_id = p_group_rec.asset_id
1778: AND adj.book_type_code = p_info_rec.book_type_code
1779: AND thg.transaction_header_id = adj.transaction_header_id
1780: AND adj.period_counter_created