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_BOOKS_MRC_V

Line 1544: from FA_BOOKS_MRC_V BK1,

1540: sum((BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0))
1541: change_in_cost_to_reduce,
1542: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1543: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1544: from FA_BOOKS_MRC_V BK1,
1545: FA_BOOKS_MRC_V BK2,
1546: FA_RETIREMENTS_MRC_V RET,
1547: FA_TRANSACTION_HEADERS TH
1548: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1545: FA_BOOKS_MRC_V BK2,

1541: change_in_cost_to_reduce,
1542: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1543: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1544: from FA_BOOKS_MRC_V BK1,
1545: FA_BOOKS_MRC_V BK2,
1546: FA_RETIREMENTS_MRC_V RET,
1547: FA_TRANSACTION_HEADERS TH
1548: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1549: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1564: from FA_BOOKS_MRC_V BK1,

1560: t_end_date date)
1561: is
1562: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1563: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1564: from FA_BOOKS_MRC_V BK1,
1565: FA_BOOKS_MRC_V BK2,
1566: FA_RETIREMENTS_MRC_V RET,
1567: FA_TRANSACTION_HEADERS TH
1568: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1565: FA_BOOKS_MRC_V BK2,

1561: is
1562: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1563: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1564: from FA_BOOKS_MRC_V BK1,
1565: FA_BOOKS_MRC_V BK2,
1566: FA_RETIREMENTS_MRC_V RET,
1567: FA_TRANSACTION_HEADERS TH
1568: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1569: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1590: from FA_BOOKS_MRC_V BK1,

1586: sum((BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0))
1587: change_in_cost_to_reduce,
1588: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1589: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1590: from FA_BOOKS_MRC_V BK1,
1591: FA_BOOKS_MRC_V BK2,
1592: FA_BOOKS_MRC_V BK3,
1593: FA_RETIREMENTS_MRC_V RET,
1594: FA_TRANSACTION_HEADERS TH

Line 1591: FA_BOOKS_MRC_V BK2,

1587: change_in_cost_to_reduce,
1588: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1589: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1590: from FA_BOOKS_MRC_V BK1,
1591: FA_BOOKS_MRC_V BK2,
1592: FA_BOOKS_MRC_V BK3,
1593: FA_RETIREMENTS_MRC_V RET,
1594: FA_TRANSACTION_HEADERS TH
1595: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1592: FA_BOOKS_MRC_V BK3,

1588: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1589: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1590: from FA_BOOKS_MRC_V BK1,
1591: FA_BOOKS_MRC_V BK2,
1592: FA_BOOKS_MRC_V BK3,
1593: FA_RETIREMENTS_MRC_V RET,
1594: FA_TRANSACTION_HEADERS TH
1595: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1596: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1605: from FA_BOOKS_MRC_V BK4

1601: and TH.TRANSACTION_DATE_ENTERED >= t_start_date
1602: and TH.TRANSACTION_DATE_ENTERED <= t_end_date
1603: and nvl(BK3.REDUCTION_RATE,0) >0
1604: and exists (select BK3.ASSET_ID
1605: from FA_BOOKS_MRC_V BK4
1606: where BK3.ASSET_ID = BK4.ASSET_ID and
1607: BK4.BOOK_TYPE_CODE = p_book_type_code and
1608: BK4.GROUP_ASSET_ID = p_asset_id and
1609: BK4. DATE_INEFFECTIVE is null);

Line 1618: from FA_BOOKS_MRC_V BK1,

1614: t_end_date date)
1615: is
1616: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1617: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1618: from FA_BOOKS_MRC_V BK1,
1619: FA_BOOKS_MRC_V BK2,
1620: FA_BOOKS_MRC_V BK3,
1621: FA_RETIREMENTS_MRC_V RET,
1622: FA_TRANSACTION_HEADERS TH

Line 1619: FA_BOOKS_MRC_V BK2,

1615: is
1616: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1617: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1618: from FA_BOOKS_MRC_V BK1,
1619: FA_BOOKS_MRC_V BK2,
1620: FA_BOOKS_MRC_V BK3,
1621: FA_RETIREMENTS_MRC_V RET,
1622: FA_TRANSACTION_HEADERS TH
1623: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1620: FA_BOOKS_MRC_V BK3,

1616: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1617: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1618: from FA_BOOKS_MRC_V BK1,
1619: FA_BOOKS_MRC_V BK2,
1620: FA_BOOKS_MRC_V BK3,
1621: FA_RETIREMENTS_MRC_V RET,
1622: FA_TRANSACTION_HEADERS TH
1623: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1624: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1632: from FA_BOOKS_MRC_V BK4

1628: and BK2.BOOK_TYPE_CODE = p_book_type_code
1629: and TH.TRANSACTION_DATE_ENTERED >= t_start_date
1630: and TH.TRANSACTION_DATE_ENTERED <= t_end_date
1631: and exists (select BK3.ASSET_ID
1632: from FA_BOOKS_MRC_V BK4
1633: where BK3.ASSET_ID = BK4.ASSET_ID and
1634: BK4.BOOK_TYPE_CODE = p_book_type_code and
1635: BK4.GROUP_ASSET_ID = p_asset_id and
1636: BK4. DATE_INEFFECTIVE is null);

Line 1649: from FA_BOOKS_MRC_V

1645: -- For MRC
1646: cursor C_REDUCTION_RATE_M (l_transaction_header_id number)
1647: is
1648: select nvl(REDUCTION_RATE,0)
1649: from FA_BOOKS_MRC_V
1650: where TRANSACTION_HEADER_ID_IN = l_transaction_header_id;
1651:
1652: ------------------------------
1653: -- Check transaction existing

Line 2462: from FA_BOOKS_MRC_V BK1,

2458:
2459: cursor C_GET_REC_COST_MRC is
2460: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2461: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2462: from FA_BOOKS_MRC_V BK1,
2463: FA_BOOKS_MRC_V BK2,
2464: FA_TRANSACTION_HEADERS TH
2465: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2466: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2463: FA_BOOKS_MRC_V BK2,

2459: cursor C_GET_REC_COST_MRC is
2460: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2461: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2462: from FA_BOOKS_MRC_V BK1,
2463: FA_BOOKS_MRC_V BK2,
2464: FA_TRANSACTION_HEADERS TH
2465: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2466: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2467: and TH.ASSET_ID = p_asset_id

Line 2529: from FA_BOOKS_MRC_V BK1,

2525: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) recoverable_cost,
2526: decode(BK3.SALVAGE_TYPE,
2527: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2528: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2529: from FA_BOOKS_MRC_V BK1,
2530: FA_BOOKS_MRC_V BK2,
2531: FA_BOOKS_MRC_V BK3,
2532: FA_TRANSACTION_HEADERS TH,
2533: FA_CALENDAR_PERIODS CP

Line 2530: FA_BOOKS_MRC_V BK2,

2526: decode(BK3.SALVAGE_TYPE,
2527: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2528: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2529: from FA_BOOKS_MRC_V BK1,
2530: FA_BOOKS_MRC_V BK2,
2531: FA_BOOKS_MRC_V BK3,
2532: FA_TRANSACTION_HEADERS TH,
2533: FA_CALENDAR_PERIODS CP
2534: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 2531: FA_BOOKS_MRC_V BK3,

2527: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2528: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2529: from FA_BOOKS_MRC_V BK1,
2530: FA_BOOKS_MRC_V BK2,
2531: FA_BOOKS_MRC_V BK3,
2532: FA_TRANSACTION_HEADERS TH,
2533: FA_CALENDAR_PERIODS CP
2534: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2535: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2544: from FA_BOOKS_MRC_V BK4

2540: and CP.END_DATE <= l_fy_end_date
2541: and CP.END_DATE >= l_fy_start_date
2542: and CP.PERIOD_NUM = p_period_num
2543: and exists (select TH.ASSET_ID
2544: from FA_BOOKS_MRC_V BK4
2545: where TH.ASSET_ID = BK4.ASSET_ID and
2546: BK4.BOOK_TYPE_CODE = p_book_type_code and
2547: BK4.GROUP_ASSET_ID = p_asset_id and
2548: BK4. DATE_INEFFECTIVE is null)

Line 2551: from FA_BOOKS_MRC_V BK,

2547: BK4.GROUP_ASSET_ID = p_asset_id and
2548: BK4. DATE_INEFFECTIVE is null)
2549: and BK3.TRANSACTION_HEADER_ID_IN=
2550: (select max(BK.TRANSACTION_HEADER_ID_IN)
2551: from FA_BOOKS_MRC_V BK,
2552: FA_TRANSACTION_HEADERS TH,
2553: FA_CALENDAR_PERIODS CP,
2554: FA_BOOK_CONTROLS_MRC_V BC
2555: where BK.ASSET_ID= p_asset_id

Line 2620: from FA_BOOKS_MRC_V BK

2616:
2617: cursor C_LAST_AMOUNT_MRC is
2618: select BK.RECOVERABLE_COST,
2619: BK.SALVAGE_VALUE
2620: from FA_BOOKS_MRC_V BK
2621: where BK.ASSET_ID = p_asset_id
2622: and BK.BOOK_TYPE_CODE = p_book_type_code
2623: and BK.TRANSACTION_HEADER_ID_OUT is null;
2624:

Line 4259: from FA_BOOKS_MRC_V BK

4255:
4256: -- MRC
4257: cursor C_GET_REDUCITON_RATE_M is
4258: select BK.REDUCTION_RATE
4259: from FA_BOOKS_MRC_V BK
4260: where BK.TRANSACTION_HEADER_ID_IN = p_member_transaction_header_id;
4261:
4262: begin
4263: