eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_MC_BOOKS

Line 1675: from FA_MC_BOOKS BK1,

1671: sum((BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0))
1672: change_in_cost_to_reduce, -- bug#15897249
1673: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1674: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1675: from FA_MC_BOOKS BK1,
1676: FA_MC_BOOKS BK2,
1677: FA_MC_RETIREMENTS RET,
1678: FA_TRANSACTION_HEADERS TH
1679: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1676: FA_MC_BOOKS BK2,

1672: change_in_cost_to_reduce, -- bug#15897249
1673: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1674: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1675: from FA_MC_BOOKS BK1,
1676: FA_MC_BOOKS BK2,
1677: FA_MC_RETIREMENTS RET,
1678: FA_TRANSACTION_HEADERS TH
1679: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1680: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1699: from FA_MC_BOOKS BK1,

1695: t_end_date date)
1696: is
1697: select sum(BK2.COST - nvl(BK1.COST,0)) total_change_in_cost,
1698: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1699: from FA_MC_BOOKS BK1,
1700: FA_MC_BOOKS BK2,
1701: FA_MC_RETIREMENTS RET,
1702: FA_TRANSACTION_HEADERS TH
1703: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1700: FA_MC_BOOKS BK2,

1696: is
1697: select sum(BK2.COST - nvl(BK1.COST,0)) total_change_in_cost,
1698: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1699: from FA_MC_BOOKS BK1,
1700: FA_MC_BOOKS BK2,
1701: FA_MC_RETIREMENTS RET,
1702: FA_TRANSACTION_HEADERS TH
1703: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1704: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1728: from FA_MC_BOOKS BK1,

1724: sum((BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0))
1725: change_in_cost_to_reduce,
1726: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1727: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1728: from FA_MC_BOOKS BK1,
1729: FA_MC_BOOKS BK2,
1730: FA_MC_BOOKS BK3,
1731: FA_MC_RETIREMENTS RET,
1732: FA_TRANSACTION_HEADERS TH

Line 1729: FA_MC_BOOKS BK2,

1725: change_in_cost_to_reduce,
1726: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1727: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1728: from FA_MC_BOOKS BK1,
1729: FA_MC_BOOKS BK2,
1730: FA_MC_BOOKS BK3,
1731: FA_MC_RETIREMENTS RET,
1732: FA_TRANSACTION_HEADERS TH
1733: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1730: FA_MC_BOOKS BK3,

1726: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1727: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1728: from FA_MC_BOOKS BK1,
1729: FA_MC_BOOKS BK2,
1730: FA_MC_BOOKS BK3,
1731: FA_MC_RETIREMENTS RET,
1732: FA_TRANSACTION_HEADERS TH
1733: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1734: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1748: from FA_MC_BOOKS BK4

1744: and TH.TRANSACTION_DATE_ENTERED >= t_start_date
1745: and TH.TRANSACTION_DATE_ENTERED <= t_end_date
1746: and nvl(BK3.REDUCTION_RATE,0) >0
1747: and exists (select BK3.ASSET_ID
1748: from FA_MC_BOOKS BK4
1749: where BK3.ASSET_ID = BK4.ASSET_ID and
1750: BK4.BOOK_TYPE_CODE = p_book_type_code and
1751: BK4.GROUP_ASSET_ID = p_asset_id and
1752: BK4.DATE_INEFFECTIVE is null and

Line 1762: from FA_MC_BOOKS BK1,

1758: t_end_date date)
1759: is
1760: select sum(BK2.COST - nvl(BK1.COST,0)) total_change_in_cost,
1761: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1762: from FA_MC_BOOKS BK1,
1763: FA_MC_BOOKS BK2,
1764: FA_MC_BOOKS BK3,
1765: FA_MC_RETIREMENTS RET,
1766: FA_TRANSACTION_HEADERS TH

Line 1763: FA_MC_BOOKS BK2,

1759: is
1760: select sum(BK2.COST - nvl(BK1.COST,0)) total_change_in_cost,
1761: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1762: from FA_MC_BOOKS BK1,
1763: FA_MC_BOOKS BK2,
1764: FA_MC_BOOKS BK3,
1765: FA_MC_RETIREMENTS RET,
1766: FA_TRANSACTION_HEADERS TH
1767: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1764: FA_MC_BOOKS BK3,

1760: select sum(BK2.COST - nvl(BK1.COST,0)) total_change_in_cost,
1761: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1762: from FA_MC_BOOKS BK1,
1763: FA_MC_BOOKS BK2,
1764: FA_MC_BOOKS BK3,
1765: FA_MC_RETIREMENTS RET,
1766: FA_TRANSACTION_HEADERS TH
1767: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1768: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1780: from FA_MC_BOOKS BK4

1776: and ret.set_of_books_id = p_set_of_books_id
1777: and TH.TRANSACTION_DATE_ENTERED >= t_start_date
1778: and TH.TRANSACTION_DATE_ENTERED <= t_end_date
1779: and exists (select BK3.ASSET_ID
1780: from FA_MC_BOOKS BK4
1781: where BK3.ASSET_ID = BK4.ASSET_ID and
1782: BK4.BOOK_TYPE_CODE = p_book_type_code and
1783: BK4.GROUP_ASSET_ID = p_asset_id and
1784: BK4.DATE_INEFFECTIVE is null and

Line 1798: from FA_MC_BOOKS

1794: -- For MRC
1795: cursor C_REDUCTION_RATE_M (l_transaction_header_id number)
1796: is
1797: select nvl(REDUCTION_RATE,0)
1798: from FA_MC_BOOKS
1799: where TRANSACTION_HEADER_ID_IN = l_transaction_header_id
1800: and set_of_books_id = p_set_of_books_id;
1801:
1802: ------------------------------

Line 1873: from FA_MC_BOOKS BK1,

1869: (BK2.COST - nvl(BK1.COST,0)+ nvl(RET.COST_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)
1870: cur_change_in_cost_to_reduce,
1871: nvl(RET.NBV_RETIRED,0) cur_net_proceeds,
1872: nvl(RET.NBV_RETIRED,0)*nvl(BK2.REDUCTION_RATE,0) cur_net_proceeds_to_reduce
1873: from FA_MC_BOOKS BK1,
1874: FA_MC_BOOKS BK2,
1875: FA_MC_RETIREMENTS RET,
1876: FA_TRANSACTION_HEADERS TH
1877: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1874: FA_MC_BOOKS BK2,

1870: cur_change_in_cost_to_reduce,
1871: nvl(RET.NBV_RETIRED,0) cur_net_proceeds,
1872: nvl(RET.NBV_RETIRED,0)*nvl(BK2.REDUCTION_RATE,0) cur_net_proceeds_to_reduce
1873: from FA_MC_BOOKS BK1,
1874: FA_MC_BOOKS BK2,
1875: FA_MC_RETIREMENTS RET,
1876: FA_TRANSACTION_HEADERS TH
1877: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1878: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2706: from FA_MC_BOOKS BK1,

2702:
2703: cursor C_GET_REC_COST_MRC is
2704: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2705: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2706: from FA_MC_BOOKS BK1,
2707: FA_MC_BOOKS BK2,
2708: FA_TRANSACTION_HEADERS TH
2709: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2710: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2707: FA_MC_BOOKS BK2,

2703: cursor C_GET_REC_COST_MRC is
2704: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2705: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2706: from FA_MC_BOOKS BK1,
2707: FA_MC_BOOKS BK2,
2708: FA_TRANSACTION_HEADERS TH
2709: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2710: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2711: and TH.ASSET_ID = p_asset_id

Line 2775: from FA_MC_BOOKS BK1,

2771: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) recoverable_cost,
2772: decode(BK3.SALVAGE_TYPE,
2773: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2774: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2775: from FA_MC_BOOKS BK1,
2776: FA_MC_BOOKS BK2,
2777: FA_MC_BOOKS BK3,
2778: FA_TRANSACTION_HEADERS TH,
2779: FA_CALENDAR_PERIODS CP

Line 2776: FA_MC_BOOKS BK2,

2772: decode(BK3.SALVAGE_TYPE,
2773: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2774: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2775: from FA_MC_BOOKS BK1,
2776: FA_MC_BOOKS BK2,
2777: FA_MC_BOOKS BK3,
2778: FA_TRANSACTION_HEADERS TH,
2779: FA_CALENDAR_PERIODS CP
2780: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 2777: FA_MC_BOOKS BK3,

2773: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2774: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2775: from FA_MC_BOOKS BK1,
2776: FA_MC_BOOKS BK2,
2777: FA_MC_BOOKS BK3,
2778: FA_TRANSACTION_HEADERS TH,
2779: FA_CALENDAR_PERIODS CP
2780: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2781: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2793: from FA_MC_BOOKS BK4

2789: and CP.END_DATE <= fa_cache_pkg.fazcfy_record.end_date
2790: and CP.END_DATE >= fa_cache_pkg.fazcfy_record.start_date
2791: and CP.PERIOD_NUM = p_period_num
2792: and exists (select TH.ASSET_ID
2793: from FA_MC_BOOKS BK4
2794: where TH.ASSET_ID = BK4.ASSET_ID and
2795: BK4.BOOK_TYPE_CODE = p_book_type_code and
2796: BK4.GROUP_ASSET_ID = p_asset_id and
2797: BK4. DATE_INEFFECTIVE is null and

Line 2801: from FA_MC_BOOKS BK,

2797: BK4. DATE_INEFFECTIVE is null and
2798: BK4.set_of_books_id = p_set_of_books_id)
2799: and BK3.TRANSACTION_HEADER_ID_IN=
2800: (select max(BK.TRANSACTION_HEADER_ID_IN)
2801: from FA_MC_BOOKS BK,
2802: FA_TRANSACTION_HEADERS TH,
2803: FA_CALENDAR_PERIODS CP,
2804: FA_MC_BOOK_CONTROLS BC
2805: where BK.ASSET_ID= p_asset_id

Line 2865: from FA_MC_BOOKS BK

2861:
2862: cursor C_LAST_AMOUNT_MRC is
2863: select BK.RECOVERABLE_COST,
2864: BK.SALVAGE_VALUE
2865: from FA_MC_BOOKS BK
2866: where BK.ASSET_ID = p_asset_id
2867: and BK.BOOK_TYPE_CODE = p_book_type_code
2868: and BK.TRANSACTION_HEADER_ID_OUT is null
2869: and BK.set_of_books_id = p_set_of_books_id;

Line 3152: from fa_mc_books_summary bs

3148:
3149: CURSOR c_get_mc_bs_amounts(c_period_counter number) IS
3150: select bs.recoverable_cost
3151: , bs.salvage_value
3152: from fa_mc_books_summary bs
3153: where bs.asset_id = p_asset_id
3154: and bs.book_type_code = p_book_type_code
3155: and bs.period_counter = c_period_counter
3156: and bs.set_of_books_id = p_set_of_books_id;

Line 4697: from FA_MC_BOOKS BK

4693:
4694: -- MRC
4695: cursor C_GET_REDUCITON_RATE_M is
4696: select BK.REDUCTION_RATE
4697: from FA_MC_BOOKS BK
4698: where BK.TRANSACTION_HEADER_ID_IN = p_member_transaction_header_id
4699: and BK.set_of_books_id = p_set_of_books_id ;
4700:
4701: begin