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

Line 653: from FA_BOOKS bk

649: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then
650:
651: select bk.deprn_method_code, bk.salvage_value, bk.cost -- bug 6378955 (added salvage value)
652: into l_old_method_code, l_old_salvage_value, l_old_cost -- l_old_cost added for Japan overlapped
653: from FA_BOOKS bk
654: where bk.asset_id = g_rule_in.asset_id
655: and bk.book_type_code = g_rule_in.book_type_code
656: and bk.transaction_header_id_out is null;
657:

Line 741: from FA_BOOKS bk

737: else
738: -- Restructured this else part for bug 6780736
739: select bk.deprn_method_code
740: into l_old_method_code
741: from FA_BOOKS bk
742: where bk.asset_id = g_rule_in.asset_id
743: and bk.book_type_code = g_rule_in.book_type_code
744: and bk.transaction_header_id_out is null;
745:

Line 852: FROM fa_books

848: end if;
849:
850: SELECT rate_in_use, deprn_method_code -- Added deprn_method_code for bug fix 6780736
851: INTO l_rate_in_use, l_old_method_code
852: FROM fa_books
853: WHERE asset_id = g_rule_in.asset_id
854: AND book_type_code = g_rule_in.book_type_code
855: AND date_ineffective is null;
856:

Line 859: fa_debug_pkg.add('faxcdb', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec);

855: AND date_ineffective is null;
856:
857: if p_log_level_rec.statement_level then
858: fa_debug_pkg.add('faxcdb', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate, p_log_level_rec);
859: fa_debug_pkg.add('faxcdb', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec);
860: fa_debug_pkg.add('faxcdb', '+++ FA_Books.deprn_method : ', l_old_method_code, p_log_level_rec);
861: end if;
862:
863: -- Added if clause for bug fix 6780736

Line 860: fa_debug_pkg.add('faxcdb', '+++ FA_Books.deprn_method : ', l_old_method_code, p_log_level_rec);

856:
857: if p_log_level_rec.statement_level then
858: fa_debug_pkg.add('faxcdb', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate, p_log_level_rec);
859: fa_debug_pkg.add('faxcdb', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec);
860: fa_debug_pkg.add('faxcdb', '+++ FA_Books.deprn_method : ', l_old_method_code, p_log_level_rec);
861: end if;
862:
863: -- Added if clause for bug fix 6780736
864: if g_rule_in.method_code <> l_old_method_code then

Line 946: from fa_books bks,

942: l_book_type_code := g_rule_in.book_type_code;
943:
944: select count(*)
945: into l_last_trx_count
946: from fa_books bks,
947: fa_deprn_periods dp
948: where bks.asset_id = l_asset_id
949: and bks.book_type_code = l_book_type_code
950: and bks.date_ineffective is null

Line 1432: from FA_BOOKS BK1,

1428: sum((BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0))
1429: change_in_cost_to_reduce,
1430: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1431: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1432: from FA_BOOKS BK1,
1433: FA_BOOKS BK2,
1434: FA_RETIREMENTS RET,
1435: FA_TRANSACTION_HEADERS TH
1436: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1433: FA_BOOKS BK2,

1429: change_in_cost_to_reduce,
1430: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1431: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK2.REDUCTION_RATE,0)) net_proceeds_to_reduce
1432: from FA_BOOKS BK1,
1433: FA_BOOKS BK2,
1434: FA_RETIREMENTS RET,
1435: FA_TRANSACTION_HEADERS TH
1436: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1437: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1452: from FA_BOOKS BK1,

1448: t_end_date date)
1449: is
1450: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1451: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1452: from FA_BOOKS BK1,
1453: FA_BOOKS BK2,
1454: FA_RETIREMENTS RET,
1455: FA_TRANSACTION_HEADERS TH
1456: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1453: FA_BOOKS BK2,

1449: is
1450: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1451: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1452: from FA_BOOKS BK1,
1453: FA_BOOKS BK2,
1454: FA_RETIREMENTS RET,
1455: FA_TRANSACTION_HEADERS TH
1456: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1457: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1478: from FA_BOOKS BK1,

1474: sum((BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0))
1475: change_in_cost_to_reduce,
1476: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1477: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1478: from FA_BOOKS BK1,
1479: FA_BOOKS BK2,
1480: FA_BOOKS BK3,
1481: FA_RETIREMENTS RET,
1482: FA_TRANSACTION_HEADERS TH

Line 1479: FA_BOOKS BK2,

1475: change_in_cost_to_reduce,
1476: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1477: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1478: from FA_BOOKS BK1,
1479: FA_BOOKS BK2,
1480: FA_BOOKS BK3,
1481: FA_RETIREMENTS RET,
1482: FA_TRANSACTION_HEADERS TH
1483: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1480: FA_BOOKS BK3,

1476: sum(nvl(RET.NBV_RETIRED,0)) net_proceeds,
1477: sum((nvl(RET.NBV_RETIRED,0))*nvl(BK3.REDUCTION_RATE,0)) net_proceeds_to_reduce
1478: from FA_BOOKS BK1,
1479: FA_BOOKS BK2,
1480: FA_BOOKS BK3,
1481: FA_RETIREMENTS RET,
1482: FA_TRANSACTION_HEADERS TH
1483: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1484: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1493: from FA_BOOKS BK4

1489: and TH.TRANSACTION_DATE_ENTERED >= t_start_date
1490: and TH.TRANSACTION_DATE_ENTERED <= t_end_date
1491: and nvl(BK3.REDUCTION_RATE,0) >0
1492: and exists (select BK3.ASSET_ID
1493: from FA_BOOKS BK4
1494: where BK3.ASSET_ID = BK4.ASSET_ID and
1495: BK4.BOOK_TYPE_CODE = p_book_type_code and
1496: BK4.GROUP_ASSET_ID = p_asset_id and
1497: BK4. DATE_INEFFECTIVE is null);

Line 1506: from FA_BOOKS BK1,

1502: t_end_date date)
1503: is
1504: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1505: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1506: from FA_BOOKS BK1,
1507: FA_BOOKS BK2,
1508: FA_BOOKS BK3,
1509: FA_RETIREMENTS RET,
1510: FA_TRANSACTION_HEADERS TH

Line 1507: FA_BOOKS BK2,

1503: is
1504: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1505: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1506: from FA_BOOKS BK1,
1507: FA_BOOKS BK2,
1508: FA_BOOKS BK3,
1509: FA_RETIREMENTS RET,
1510: FA_TRANSACTION_HEADERS TH
1511: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 1508: FA_BOOKS BK3,

1504: select sum(BK2.COST - nvl(BK1.COST,0)+nvl(RET.COST_RETIRED,0)) total_change_in_cost,
1505: sum(nvl(RET.NBV_RETIRED,0)) total_net_proceeds
1506: from FA_BOOKS BK1,
1507: FA_BOOKS BK2,
1508: FA_BOOKS BK3,
1509: FA_RETIREMENTS RET,
1510: FA_TRANSACTION_HEADERS TH
1511: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
1512: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 1520: from FA_BOOKS BK4

1516: and BK2.BOOK_TYPE_CODE = p_book_type_code
1517: and TH.TRANSACTION_DATE_ENTERED >= t_start_date
1518: and TH.TRANSACTION_DATE_ENTERED <= t_end_date
1519: and exists (select BK3.ASSET_ID
1520: from FA_BOOKS BK4
1521: where BK3.ASSET_ID = BK4.ASSET_ID and
1522: BK4.BOOK_TYPE_CODE = p_book_type_code and
1523: BK4.GROUP_ASSET_ID = p_asset_id and
1524: BK4. DATE_INEFFECTIVE is null);

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 1642: from FA_BOOKS

1638: -- Query member's reduction rate in this transaction
1639: cursor C_REDUCTION_RATE (l_transaction_header_id number)
1640: is
1641: select nvl(REDUCTION_RATE,0)
1642: from FA_BOOKS
1643: where TRANSACTION_HEADER_ID_IN = l_transaction_header_id;
1644:
1645: -- For MRC
1646: cursor C_REDUCTION_RATE_M (l_transaction_header_id number)

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 2450: from FA_BOOKS BK1,

2446: -- Get Recoverable cost for Member and Standalone asset
2447: cursor C_GET_REC_COST is
2448: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2449: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2450: from FA_BOOKS BK1,
2451: FA_BOOKS BK2,
2452: FA_TRANSACTION_HEADERS TH
2453: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2454: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2451: FA_BOOKS BK2,

2447: cursor C_GET_REC_COST is
2448: select sum(BK2.RECOVERABLE_COST -nvl(BK1.RECOVERABLE_COST,0)) recoverable_cost,
2449: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0)) salvage_value
2450: from FA_BOOKS BK1,
2451: FA_BOOKS BK2,
2452: FA_TRANSACTION_HEADERS TH
2453: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2454: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2455: and TH.ASSET_ID = p_asset_id

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 2482: from FA_BOOKS BK1,

2478: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) recoverable_cost,
2479: decode(BK3.SALVAGE_TYPE,
2480: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2481: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2482: from FA_BOOKS BK1,
2483: FA_BOOKS BK2,
2484: FA_BOOKS BK3,
2485: FA_TRANSACTION_HEADERS TH,
2486: FA_CALENDAR_PERIODS CP

Line 2483: FA_BOOKS BK2,

2479: decode(BK3.SALVAGE_TYPE,
2480: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2481: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2482: from FA_BOOKS BK1,
2483: FA_BOOKS BK2,
2484: FA_BOOKS BK3,
2485: FA_TRANSACTION_HEADERS TH,
2486: FA_CALENDAR_PERIODS CP
2487: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)

Line 2484: FA_BOOKS BK3,

2480: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),
2481: sum(BK2.SALVAGE_VALUE -nvl(BK1.SALVAGE_VALUE,0))) salvage_value
2482: from FA_BOOKS BK1,
2483: FA_BOOKS BK2,
2484: FA_BOOKS BK3,
2485: FA_TRANSACTION_HEADERS TH,
2486: FA_CALENDAR_PERIODS CP
2487: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2488: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN

Line 2497: from FA_BOOKS BK4

2493: and CP.END_DATE <= l_fy_end_date
2494: and CP.END_DATE >= l_fy_start_date
2495: and CP.PERIOD_NUM = p_period_num
2496: and exists (select TH.ASSET_ID
2497: from FA_BOOKS BK4
2498: where TH.ASSET_ID = BK4.ASSET_ID and
2499: BK4.BOOK_TYPE_CODE = p_book_type_code and
2500: BK4.GROUP_ASSET_ID = p_asset_id and
2501: BK4. DATE_INEFFECTIVE is null)

Line 2504: from FA_BOOKS BK,

2500: BK4.GROUP_ASSET_ID = p_asset_id and
2501: BK4. DATE_INEFFECTIVE is null)
2502: and BK3.TRANSACTION_HEADER_ID_IN=
2503: (select max(BK.TRANSACTION_HEADER_ID_IN)
2504: from FA_BOOKS BK,
2505: FA_TRANSACTION_HEADERS TH,
2506: FA_CALENDAR_PERIODS CP
2507: where BK.ASSET_ID= p_asset_id
2508: and BK.BOOK_TYPE_CODE = p_book_type_code

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 2612: from FA_BOOKS BK

2608:
2609: cursor C_LAST_AMOUNT is
2610: select BK.RECOVERABLE_COST,
2611: BK.SALVAGE_VALUE
2612: from FA_BOOKS BK
2613: where BK.ASSET_ID = p_asset_id
2614: and BK.BOOK_TYPE_CODE = p_book_type_code
2615: and BK.TRANSACTION_HEADER_ID_OUT is null;
2616:

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 2913: from fa_books_summary bs

2909:
2910: CURSOR c_get_bs_amounts(c_period_counter number) IS
2911: select bs.recoverable_cost
2912: , bs.salvage_value
2913: from fa_books_summary bs
2914: where bs.asset_id = p_asset_id
2915: and bs.book_type_code = p_book_type_code
2916: and bs.period_counter = c_period_counter;
2917:

Line 2921: from fa_books_summary_mrc_v bs

2917:
2918: CURSOR c_get_mc_bs_amounts(c_period_counter number) IS
2919: select bs.recoverable_cost
2920: , bs.salvage_value
2921: from fa_books_summary_mrc_v bs
2922: where bs.asset_id = p_asset_id
2923: and bs.book_type_code = p_book_type_code
2924: and bs.period_counter = c_period_counter;
2925:

Line 2979: -- eop/eofy amounts are available in FA_BOOKS_SUMMARY table.

2975: l_period_counter := p_period_counter;
2976: end if;
2977:
2978: --
2979: -- eop/eofy amounts are available in FA_BOOKS_SUMMARY table.
2980: --
2981:
2982: if (p_mrc_sob_type_code = 'R') then
2983: FOR i in 1..2 LOOP

Line 4253: from FA_BOOKS BK

4249:
4250: -- Get reduction_rate of member asset
4251: cursor C_GET_REDUCITON_RATE is
4252: select BK.REDUCTION_RATE
4253: from FA_BOOKS BK
4254: where BK.TRANSACTION_HEADER_ID_IN = p_member_transaction_header_id;
4255:
4256: -- MRC
4257: cursor C_GET_REDUCITON_RATE_M is

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: