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_TRACK_MEMBER_PVT dependencies on FA_ADDITIONS_B

Line 382: fa_additions_b ad

378: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
379: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
380: from fa_books bk,
381: fa_deprn_summary ds,
382: fa_additions_b ad
383: where bk.group_asset_id = h_group_asset_id
384: and bk.book_type_code = h_book_type_code
385: and bk.date_ineffective is null
386: and bk.depreciate_flag = 'YES'

Line 438: fa_additions_b ad

434: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
435: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
436: from fa_mc_books bk,
437: fa_mc_deprn_summary ds,
438: fa_additions_b ad
439: where bk.group_asset_id = h_group_asset_id
440: and bk.book_type_code = h_book_type_code
441: and bk.date_ineffective is null
442: and bk.depreciate_flag = 'YES'

Line 464: fa_additions_b ad

460: select sum(bk.cost),
461: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
462: sum(bk.recoverable_cost)
463: from fa_books bk,
464: fa_additions_b ad
465: where bk.group_asset_id = h_group_asset_id
466: and bk.date_ineffective is null
467: and bk.depreciate_flag = 'YES'
468: and bk.book_type_code = h_book_type_code

Line 477: fa_additions_b ad

473: select sum(bk.cost),
474: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
475: sum(bk.recoverable_cost)
476: from fa_mc_books bk,
477: fa_additions_b ad
478: where bk.group_asset_id = h_group_asset_id
479: and bk.date_ineffective is null
480: and bk.book_type_code = h_book_type_code
481: and bk.set_of_books_id = h_set_of_books_id

Line 492: fa_additions_b ad

488: select sum(bk.cost),
489: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
490: sum(bk.recoverable_cost)
491: from fa_books bk,
492: fa_additions_b ad
493: where bk.group_asset_id = h_group_asset_id
494: and bk.date_ineffective is null
495: and bk.period_counter_fully_retired is null
496: and bk.book_type_code = h_book_type_code

Line 506: fa_additions_b ad

502: select sum(bk.cost),
503: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
504: sum(bk.recoverable_cost)
505: from fa_mc_books bk,
506: fa_additions_b ad
507: where bk.group_asset_id = h_group_asset_id
508: and bk.date_ineffective is null
509: and bk.period_counter_fully_retired is null
510: and bk.book_type_code = h_book_type_code

Line 522: fa_additions_b ad

518: select sum(bk.cost),
519: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
520: sum(bk.recoverable_cost)
521: from fa_books bk,
522: fa_additions_b ad
523: where bk.group_asset_id = h_group_asset_id
524: and bk.date_ineffective is null
525: and bk.period_counter_fully_reserved is null
526: and bk.book_type_code = h_book_type_code

Line 536: fa_additions_b ad

532: select sum(bk.cost),
533: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
534: sum(bk.recoverable_cost)
535: from fa_mc_books bk,
536: fa_additions_b ad
537: where bk.group_asset_id = h_group_asset_id
538: and bk.date_ineffective is null
539: and bk.period_counter_fully_reserved is null
540: and bk.book_type_code = h_book_type_code

Line 552: fa_additions_b ad

548: select sum(bk.cost),
549: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
550: sum(bk.recoverable_cost)
551: from fa_books bk,
552: fa_additions_b ad
553: where bk.group_asset_id = h_group_asset_id
554: and bk.date_ineffective is null
555: and bk.period_counter_fully_retired is null
556: and bk.period_counter_fully_reserved is null

Line 567: fa_additions_b ad

563: select sum(bk.cost),
564: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
565: sum(bk.recoverable_cost)
566: from fa_mc_books bk,
567: fa_additions_b ad
568: where bk.group_asset_id = h_group_asset_id
569: and bk.date_ineffective is null
570: and bk.period_counter_fully_retired is null
571: and bk.period_counter_fully_reserved is null

Line 607: fa_additions_b ad

603: from fa_track_members tr,
604: fa_books bk,
605: fa_deprn_summary ds,
606: fa_deprn_periods dp,
607: fa_additions_b ad
608: where tr.group_asset_id = h_group_asset_id
609: and tr.period_counter = h_period_counter
610: and tr.fiscal_year = h_fiscal_year
611: and nvl(tr.set_of_books_id,-99) = nvl(h_set_of_books_id,-99)

Line 642: fa_additions_b ad

638: from fa_track_members tr,
639: fa_mc_books bk,
640: fa_mc_deprn_summary ds,
641: fa_mc_deprn_periods dp,
642: fa_additions_b ad
643: where tr.group_asset_id = h_group_asset_id
644: and tr.period_counter = h_period_counter
645: and tr.fiscal_year = h_fiscal_year
646: and nvl(tr.set_of_books_id,-99) = nvl(h_set_of_books_id,-99)

Line 4157: fa_additions_b ad

4153:
4154: cursor GET_TRANS_ASSET_TYPE is
4155: select ad.asset_type
4156: from fa_transaction_headers th,
4157: fa_additions_b ad
4158: where th.transaction_header_id = p_group_rule_in.adj_transaction_header_id
4159: and ad.asset_id = th.asset_id;
4160:
4161: cursor GET_NEW_BOOKS is

Line 4557: from fa_additions_b

4553: end if;
4554:
4555: -- Get Asset type
4556: select asset_type into x_asset_type
4557: from fa_additions_b
4558: where asset_id = l_track_member.member_asset_id;
4559:
4560: fa_rule_in.asset_type := x_asset_type;
4561: if nvl(h_asset_id,-99) <> l_track_member.member_asset_id then

Line 4735: from fa_additions_b

4731: fa_rule_in.asset_id := l_track_member.member_asset_id;
4732:
4733: -- Get Asset type
4734: select asset_type into x_asset_type
4735: from fa_additions_b
4736: where asset_id = h_member_asset_id;
4737:
4738: -- get reserve/expense adjustments
4739: if p_group_rule_in.mrc_sob_type_code <> 'R' then

Line 4942: from fa_additions_b

4938: fa_rule_in.group_asset_id := h_group_asset_id;
4939:
4940: -- Get Asset type
4941: select asset_type into x_asset_type
4942: from fa_additions_b
4943: where asset_id = member.member_asset_id;
4944:
4945: fa_rule_in.asset_type := x_asset_type;
4946: fa_rule_in.cost := member.cost;

Line 5167: from fa_additions_b

5163: fa_rule_in.group_asset_id := h_group_asset_id;
5164:
5165: -- Get Asset type
5166: select asset_type into x_asset_type
5167: from fa_additions_b
5168: where asset_id = member.member_asset_id;
5169:
5170: fa_rule_in.asset_type := x_asset_type;
5171: fa_rule_in.cost := member.cost;

Line 5904: fa_additions_b ad

5900: -- cursor to get all members at the specified period
5901: cursor ALL_MEMBERS(h_date date) is
5902: select bk.asset_id
5903: from fa_books bk,
5904: fa_additions_b ad
5905: where bk.book_type_code = h_book_type_code
5906: and bk.group_asset_id = h_group_asset_id
5907: and bk.date_placed_in_service <= h_date
5908: and bk.depreciate_flag = 'YES'

Line 5918: fa_additions_b ad

5914:
5915: cursor ALL_MEMBERS_MRC(h_date date) is
5916: select bk.asset_id
5917: from fa_mc_books bk,
5918: fa_additions_b ad
5919: where bk.book_type_code = h_book_type_code
5920: and bk.group_asset_id = h_group_asset_id
5921: and bk.set_of_books_id = h_set_of_books_id
5922: and bk.date_placed_in_service <= h_date

Line 5951: fa_additions_b ad

5947: from fa_books bk,
5948: fa_deprn_periods dp,
5949: fa_deprn_periods dp1,
5950: fa_deprn_summary ds,
5951: fa_additions_b ad
5952: where dp.book_type_code = h_book_type_code
5953: and dp.period_counter = h_loop_period_counter
5954: and bk.book_type_code = dp.book_type_code
5955: and bk.asset_id = p_member_asset_id

Line 6000: fa_additions_b ad

5996: from fa_mc_books bk,
5997: fa_mc_deprn_periods dp,
5998: fa_mc_deprn_periods dp1,
5999: fa_mc_deprn_summary ds,
6000: fa_additions_b ad
6001: where dp.book_type_code = h_book_type_code
6002: and dp.period_counter = h_loop_period_counter
6003: and dp.set_of_books_id = h_set_of_books_id
6004: and bk.book_type_code = dp.book_type_code

Line 6053: fa_additions_b ad

6049: dp.fiscal_year
6050: from fa_books bk,
6051: fa_deprn_periods dp,
6052: fa_deprn_summary ds,
6053: fa_additions_b ad
6054: where dp.book_type_code = h_book_type_code
6055: and dp.period_counter = h_loop_period_counter
6056: and bk.book_type_code = dp.book_type_code
6057: and bk.asset_id = p_member_asset_id

Line 6091: fa_additions_b ad

6087: dp.fiscal_year
6088: from fa_mc_books bk,
6089: fa_mc_deprn_periods dp,
6090: fa_mc_deprn_summary ds,
6091: fa_additions_b ad
6092: where dp.book_type_code = h_book_type_code
6093: and dp.period_counter = h_loop_period_counter
6094: and dp.set_of_books_id = h_set_of_books_id
6095: and bk.book_type_code = dp.book_type_code

Line 7040: fa_additions_b ad

7036: -- cursor to get all members at the specified period
7037: cursor ALL_MEMBERS_AT_AMORT(p_fiscal_year number,p_period_num number) is
7038: select distinct bk.asset_id member_asset_id, ad.asset_number
7039: from fa_books bk,
7040: fa_additions_b ad
7041: where bk.book_type_code = h_book_type_code
7042: and bk.group_asset_id = h_group_asset_id
7043: and bk.depreciate_flag = 'YES'
7044: and exists

Line 7064: fa_additions_b ad

7060:
7061: cursor ALL_MEMBERS_AT_AMORT_MRC(p_fiscal_year number,p_period_num number) is
7062: select distinct bk.asset_id member_asset_id, ad.asset_number
7063: from fa_books_mrc_v bk,
7064: fa_additions_b ad
7065: where bk.book_type_code = h_book_type_code
7066: and bk.group_asset_id = h_group_asset_id
7067: and bk.depreciate_flag = 'YES'
7068: and exists

Line 7394: from fa_additions_b

7390:
7391: -- Get Asset type
7392: select ASSET_TYPE
7393: into fa_rule_in.asset_type
7394: from fa_additions_b
7395: where asset_id = h_member_asset_id;
7396:
7397: --* Set fa_rule_in to call deprn basis rule function
7398: fa_rule_in.asset_id := h_member_asset_id;

Line 7634: from fa_additions_b

7630:
7631: -- Get Asset type
7632: select ASSET_TYPE
7633: into fa_rule_in.asset_type
7634: from fa_additions_b
7635: where asset_id = h_member_asset_id;
7636:
7637: --* Set fa_rule_in to call deprn basis rule function
7638: fa_rule_in.asset_id := h_member_asset_id;

Line 8342: FA_ADDITIONS_B AD

8338: --* Cursor to populate member assets exist at the period
8339: cursor GET_MEMBER_ASSETS(p_fiscal_year number,p_period_num number) is
8340: select distinct BK.ASSET_ID, AD.asset_number
8341: from FA_BOOKS BK,
8342: FA_ADDITIONS_B AD
8343: where BK.book_type_code = h_book_type_code
8344: and BK.group_asset_id = h_group_asset_id
8345: and exists
8346: (select TH1.TRANSACTION_HEADER_ID

Line 8366: FA_ADDITIONS_B AD

8362:
8363: cursor GET_MEMBER_ASSETS_MRC (p_fiscal_year number,p_period_num number) is
8364: select distinct BK.ASSET_ID, AD.asset_number
8365: from FA_BOOKS_MRC_V BK,
8366: FA_ADDITIONS_B AD
8367: where BK.book_type_code = h_book_type_code
8368: and BK.group_asset_id = h_group_asset_id
8369: and exists
8370: (select TH1.TRANSACTION_HEADER_ID

Line 9609: from fa_additions_b

9605:
9606: -- Get Asset type
9607: select ASSET_TYPE
9608: into fa_rule_in.asset_type
9609: from fa_additions_b
9610: where asset_id = h_member_asset_id;
9611:
9612: -- Get eofy, eop amounts
9613: if not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP

Line 10044: from fa_additions_b

10040:
10041: -- Get Asset type
10042: select ASSET_TYPE
10043: into fa_rule_in.asset_type
10044: from fa_additions_b
10045: where asset_id = h_member_asset_id;
10046:
10047: -- Get eofy, eop amounts
10048: if not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP