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_RETIREMENTS

Line 1677: FA_MC_RETIREMENTS RET,

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
1681: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1701: FA_MC_RETIREMENTS RET,

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
1705: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 1731: FA_MC_RETIREMENTS RET,

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
1735: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN

Line 1765: FA_MC_RETIREMENTS RET,

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
1769: and TH.MEMBER_TRANSACTION_HEADER_ID = BK3.TRANSACTION_HEADER_ID_IN

Line 1875: FA_MC_RETIREMENTS RET,

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
1879: and TH.TRANSACTION_HEADER_ID = RET.TRANSACTION_HEADER_ID_IN(+)

Line 4180: from FA_MC_RETIREMENTS ret,

4176: cursor C_LTD_PROCEEDS_M (
4177: p_period_end_date date
4178: ) is
4179: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
4180: from FA_MC_RETIREMENTS ret,
4181: FA_TRANSACTION_HEADERS th
4182: where th.asset_id = p_asset_id
4183: and th.book_type_code = p_book_type_code
4184: and ret.status in ('PROCESSED','PENDING')

Line 4194: from FA_MC_RETIREMENTS ret,

4190: cursor GP_LTD_PROCEEDS_M (
4191: p_period_end_date date
4192: ) is
4193: select nvl(sum(ret.nbv_retired),0) ldt_proceeds
4194: from FA_MC_RETIREMENTS ret,
4195: FA_TRANSACTION_HEADERS th
4196: where th.asset_id = p_asset_id
4197: and th.book_type_code = p_book_type_code
4198: and ret.status in ('PROCESSED','PENDING')

Line 4238: from FA_MC_RETIREMENTS ret,

4234: p_fy_start_date date,
4235: p_period_end_date date
4236: ) is
4237: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
4238: from FA_MC_RETIREMENTS ret,
4239: FA_TRANSACTION_HEADERS th
4240: where th.asset_id = p_asset_id
4241: and th.book_type_code = p_book_type_code
4242: and ret.status in ('PROCESSED','PENDING')

Line 4254: from FA_MC_RETIREMENTS ret,

4250: p_fy_start_date date,
4251: p_period_end_date date
4252: ) is
4253: select nvl(sum(ret.nbv_retired),0) ytd_proceeds
4254: from FA_MC_RETIREMENTS ret,
4255: FA_TRANSACTION_HEADERS th
4256: where th.asset_id = p_asset_id
4257: and th.book_type_code = p_book_type_code
4258: and ret.status in ('PROCESSED','PENDING')

Line 4461: from FA_MC_RETIREMENTS ret,

4457: cursor C_LTD_RETIRED_COST_M (
4458: p_period_end_date date
4459: ) is
4460: select nvl(sum(ret.cost_retired),0)
4461: from FA_MC_RETIREMENTS ret,
4462: FA_TRANSACTION_HEADERS th
4463: where th.asset_id = p_asset_id
4464: and th.book_type_code = p_book_type_code
4465: and ret.status in ('PROCESSED','PENDING')

Line 4474: from FA_MC_RETIREMENTS ret,

4470: cursor GP_LTD_RETIRED_COST_M (
4471: p_period_end_date date
4472: ) is
4473: select nvl(sum(ret.cost_retired),0)
4474: from FA_MC_RETIREMENTS ret,
4475: FA_TRANSACTION_HEADERS th
4476: where th.asset_id = p_asset_id
4477: and th.book_type_code = p_book_type_code
4478: and ret.status in ('PROCESSED','PENDING')

Line 4518: from FA_MC_RETIREMENTS ret,

4514: p_fy_start_date date,
4515: p_period_end_date date
4516: ) is
4517: select nvl(sum(ret.cost_retired),0)
4518: from FA_MC_RETIREMENTS ret,
4519: FA_TRANSACTION_HEADERS th
4520: where th.asset_id = p_asset_id
4521: and th.book_type_code = p_book_type_code
4522: and ret.status in ('PROCESSED','PENDING')

Line 4533: from FA_MC_RETIREMENTS ret,

4529: p_fy_start_date date,
4530: p_period_end_date date
4531: ) is
4532: select nvl(sum(ret.cost_retired),0)
4533: from FA_MC_RETIREMENTS ret,
4534: FA_TRANSACTION_HEADERS th
4535: where th.asset_id = p_asset_id
4536: and th.book_type_code = p_book_type_code
4537: and ret.status in ('PROCESSED','PENDING')

Line 4684: from FA_MC_RETIREMENTS RET

4680:
4681: -- MRC
4682: cursor C_GET_MEM_PROCEEDS_M is
4683: select nvl(RET.NBV_RETIRED,0),recognize_gain_loss
4684: from FA_MC_RETIREMENTS RET
4685: where RET.TRANSACTION_HEADER_ID_IN = p_member_transaction_header_id
4686: and ret.set_of_books_id = p_set_of_books_id;
4687:
4688: -- Get reduction_rate of member asset