DBA Data[Home] [Help]

APPS.FA_MC_UPG2_PKG dependencies on FA_MC_CONVERSION_RATES

Line 485: fa_mc_conversion_rates cr

481: bk.terminal_gain_loss_flag,
482: bk.tracking_method
483: FROM
484: fa_books bk,
485: fa_mc_conversion_rates cr
486: WHERE
487: cr.asset_id = bk.asset_id AND
488: cr.set_of_books_id = p_rsob_id AND
489: cr.book_type_code = p_book_type_code AND

Line 742: fa_mc_conversion_rates cr

738: ai.invoice_line_number,
739: ai.po_distribution_id
740: FROM
741: fa_asset_invoices ai,
742: fa_mc_conversion_rates cr
743: WHERE
744: ai.asset_id = cr.asset_id AND
745: cr.set_of_books_id = p_rsob_id AND
746: cr.book_type_code = p_book_type_code AND

Line 841: fa_mc_conversion_rates cr

837: 'Y'
838: FROM
839: fa_mc_books mcbk,
840: fa_books bk,
841: fa_mc_conversion_rates cr
842:
843: WHERE
844: cr.status = 'S' AND
845: cr.asset_id = bk.asset_id AND

Line 1045: fa_mc_conversion_rates cr

1041: aj.source_line_id,
1042: aj.source_dest_code
1043: FROM
1044: fa_adjustments aj,
1045: fa_mc_conversion_rates cr
1046:
1047: WHERE
1048: cr.set_of_books_id = p_rsob_id AND
1049: cr.book_type_code = p_book_type_code AND

Line 1202: fa_mc_conversion_rates cr

1198: aj.source_line_id,
1199: aj.source_dest_code
1200: FROM
1201: fa_adjustments aj,
1202: fa_mc_conversion_rates cr
1203: WHERE
1204: cr.set_of_books_id = p_rsob_id AND
1205: cr.book_type_code = p_book_type_code AND
1206: cr.asset_id = aj.asset_id AND

Line 1274: fa_mc_conversion_rates cr

1270: fa_mc_adjustments maj,
1271: fa_deprn_periods dp,
1272: fa_mc_retirements mrt,
1273: fa_retirements rt,
1274: fa_mc_conversion_rates cr
1275: WHERE
1276: cr.book_type_code = p_book_type_code AND
1277: cr.set_of_books_id = p_rsob_id AND
1278: cr.status = 'S' AND

Line 1702: fa_mc_conversion_rates cr

1698: rt.reduction_rate,
1699: rt.terminal_gain_loss
1700: FROM
1701: fa_retirements rt,
1702: fa_mc_conversion_rates cr
1703: WHERE
1704: cr.set_of_books_id = p_rsob_id AND
1705: cr.book_type_code = p_book_type_code AND
1706: cr.asset_id = rt.asset_id AND

Line 1910: fa_mc_conversion_rates cr

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
1913: cr.book_type_code = p_book_type_code AND
1914: cr.set_of_books_id = p_rsob_id AND

Line 2069: fa_mc_conversion_rates cr

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
2072: ds.deprn_source_code = 'BOOKS' AND
2073: cr.book_type_code = p_book_type_code AND

Line 2347: fa_mc_conversion_rates cr

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
2350: cr.set_of_books_id = p_rsob_id AND
2351: cr.status = 'S' AND

Line 2544: fa_mc_conversion_rates cr

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
2546: cr.status = 'S' AND
2547: cr.asset_id = ds.asset_id AND
2548: cr.book_type_code = p_book_type_code AND

Line 3047: fa_mc_conversion_rates cr

3043: dd.reserve_je_line_num
3044: FROM
3045: fa_deferred_deprn dd,
3046: fa_book_controls bc,
3047: fa_mc_conversion_rates cr
3048: WHERE
3049: cr.book_type_code = p_book_type_code AND
3050: cr.set_of_books_id = p_rsob_id AND
3051: cr.status = 'S' AND