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 410: fa_additions_b ad

406: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
407: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
408: from fa_books bk,
409: fa_deprn_summary ds,
410: fa_additions_b ad
411: where bk.group_asset_id = h_group_asset_id
412: and bk.book_type_code = h_book_type_code
413: and bk.date_ineffective is null
414: and bk.depreciate_flag = 'YES'

Line 467: fa_additions_b ad

463: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
464: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
465: from fa_mc_books bk,
466: fa_mc_deprn_summary ds,
467: fa_additions_b ad
468: where bk.group_asset_id = h_group_asset_id
469: and bk.book_type_code = h_book_type_code
470: and bk.date_ineffective is null
471: and bk.depreciate_flag = 'YES'

Line 493: fa_additions_b ad

489: select sum(bk.cost),
490: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
491: sum(bk.recoverable_cost)
492: from fa_books bk,
493: fa_additions_b ad
494: where bk.group_asset_id = h_group_asset_id
495: and bk.date_ineffective is null
496: and bk.depreciate_flag = 'YES'
497: 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.book_type_code = h_book_type_code
510: and bk.set_of_books_id = p_set_of_books_id

Line 521: fa_additions_b ad

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

Line 535: fa_additions_b ad

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

Line 551: fa_additions_b ad

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

Line 565: fa_additions_b ad

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

Line 581: fa_additions_b ad

577: select sum(bk.cost),
578: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
579: sum(bk.recoverable_cost)
580: from fa_books bk,
581: fa_additions_b ad
582: where bk.group_asset_id = h_group_asset_id
583: and bk.date_ineffective is null
584: and bk.period_counter_fully_retired is null
585: and bk.period_counter_fully_reserved is null

Line 596: fa_additions_b ad

592: select sum(bk.cost),
593: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
594: sum(bk.recoverable_cost)
595: from fa_mc_books bk,
596: fa_additions_b ad
597: where bk.group_asset_id = h_group_asset_id
598: and bk.date_ineffective is null
599: and bk.period_counter_fully_retired is null
600: and bk.period_counter_fully_reserved is null

Line 636: fa_additions_b ad

632: from fa_track_members tr,
633: fa_books bk,
634: fa_deprn_summary ds,
635: fa_deprn_periods dp,
636: fa_additions_b ad
637: where tr.group_asset_id = h_group_asset_id
638: and tr.period_counter = h_period_counter
639: and tr.fiscal_year = h_fiscal_year
640: and nvl(tr.set_of_books_id,-99) = nvl(p_set_of_books_id,-99)

Line 671: fa_additions_b ad

667: from fa_track_members tr,
668: fa_mc_books bk,
669: fa_mc_deprn_summary ds,
670: fa_mc_deprn_periods dp,
671: fa_additions_b ad
672: where tr.group_asset_id = h_group_asset_id
673: and tr.period_counter = h_period_counter
674: and tr.fiscal_year = h_fiscal_year
675: and nvl(tr.set_of_books_id,-99) = nvl(p_set_of_books_id,-99)

Line 4311: fa_additions_b ad

4307:
4308: cursor GET_TRANS_ASSET_TYPE is
4309: select ad.asset_type
4310: from fa_transaction_headers th,
4311: fa_additions_b ad
4312: where th.transaction_header_id = p_group_rule_in.adj_transaction_header_id
4313: and ad.asset_id = th.asset_id;
4314:
4315: cursor GET_NEW_BOOKS is

Line 4713: from fa_additions_b

4709: end if;
4710:
4711: -- Get Asset type
4712: select asset_type into x_asset_type
4713: from fa_additions_b
4714: where asset_id = l_track_member.member_asset_id;
4715:
4716: fa_rule_in.asset_type := x_asset_type;
4717: if nvl(h_asset_id,-99) <> l_track_member.member_asset_id then

Line 4897: from fa_additions_b

4893: fa_rule_in.asset_id := l_track_member.member_asset_id;
4894:
4895: -- Get Asset type
4896: select asset_type into x_asset_type
4897: from fa_additions_b
4898: where asset_id = h_member_asset_id;
4899:
4900: -- get reserve/expense adjustments
4901: if p_group_rule_in.mrc_sob_type_code <> 'R' then

Line 5103: from fa_additions_b

5099: fa_rule_in.group_asset_id := h_group_asset_id;
5100:
5101: -- Get Asset type
5102: select asset_type into x_asset_type
5103: from fa_additions_b
5104: where asset_id = member.member_asset_id;
5105:
5106: fa_rule_in.asset_type := x_asset_type;
5107: fa_rule_in.cost := member.cost;

Line 5325: from fa_additions_b

5321: fa_rule_in.group_asset_id := h_group_asset_id;
5322:
5323: -- Get Asset type
5324: select asset_type into x_asset_type
5325: from fa_additions_b
5326: where asset_id = member.member_asset_id;
5327:
5328: fa_rule_in.asset_type := x_asset_type;
5329: fa_rule_in.cost := member.cost;

Line 6065: fa_additions_b ad

6061: -- cursor to get all members at the specified period
6062: cursor ALL_MEMBERS(h_date date) is
6063: select bk.asset_id
6064: from fa_books bk,
6065: fa_additions_b ad
6066: where bk.book_type_code = h_book_type_code
6067: and bk.group_asset_id = h_group_asset_id
6068: and bk.date_placed_in_service <= h_date
6069: and bk.depreciate_flag = 'YES'

Line 6079: fa_additions_b ad

6075:
6076: cursor ALL_MEMBERS_MRC(h_date date) is
6077: select bk.asset_id
6078: from fa_mc_books bk,
6079: fa_additions_b ad
6080: where bk.book_type_code = h_book_type_code
6081: and bk.group_asset_id = h_group_asset_id
6082: and bk.set_of_books_id = p_set_of_books_id
6083: and bk.date_placed_in_service <= h_date

Line 6112: fa_additions_b ad

6108: from fa_books bk,
6109: fa_deprn_periods dp,
6110: fa_deprn_periods dp1,
6111: fa_deprn_summary ds,
6112: fa_additions_b ad
6113: where dp.book_type_code = h_book_type_code
6114: and dp.period_counter = h_loop_period_counter
6115: and bk.book_type_code = dp.book_type_code
6116: and bk.asset_id = p_member_asset_id

Line 6161: fa_additions_b ad

6157: from fa_mc_books bk,
6158: fa_mc_deprn_periods dp,
6159: fa_mc_deprn_periods dp1,
6160: fa_mc_deprn_summary ds,
6161: fa_additions_b ad
6162: where dp.book_type_code = h_book_type_code
6163: and dp.period_counter = h_loop_period_counter
6164: and dp.set_of_books_id = p_set_of_books_id
6165: and bk.book_type_code = dp.book_type_code

Line 6215: fa_additions_b ad

6211: dp.fiscal_year
6212: from fa_books bk,
6213: fa_deprn_periods dp,
6214: fa_deprn_summary ds,
6215: fa_additions_b ad
6216: where dp.book_type_code = h_book_type_code
6217: and dp.period_counter = h_loop_period_counter
6218: and bk.book_type_code = dp.book_type_code
6219: and bk.asset_id = p_member_asset_id

Line 6253: fa_additions_b ad

6249: dp.fiscal_year
6250: from fa_mc_books bk,
6251: fa_mc_deprn_periods dp,
6252: fa_mc_deprn_summary ds,
6253: fa_additions_b ad
6254: where dp.book_type_code = h_book_type_code
6255: and dp.period_counter = h_loop_period_counter
6256: and dp.set_of_books_id = p_set_of_books_id
6257: and bk.book_type_code = dp.book_type_code

Line 7212: fa_additions_b ad

7208: -- cursor to get all members at the specified period
7209: cursor ALL_MEMBERS_AT_AMORT(p_fiscal_year number,p_period_num number) is
7210: select distinct bk.asset_id member_asset_id, ad.asset_number
7211: from fa_books bk,
7212: fa_additions_b ad
7213: where bk.book_type_code = h_book_type_code
7214: and bk.group_asset_id = h_group_asset_id
7215: and bk.depreciate_flag = 'YES'
7216: and exists

Line 7236: fa_additions_b ad

7232:
7233: cursor ALL_MEMBERS_AT_AMORT_MRC(p_fiscal_year number,p_period_num number) is
7234: select distinct bk.asset_id member_asset_id, ad.asset_number
7235: from fa_mc_books bk,
7236: fa_additions_b ad
7237: where bk.book_type_code = h_book_type_code
7238: and bk.group_asset_id = h_group_asset_id
7239: and bk.depreciate_flag = 'YES'
7240: and bk.set_of_books_id = h_set_of_books_id

Line 7571: from fa_additions_b

7567:
7568: -- Get Asset type
7569: select ASSET_TYPE
7570: into fa_rule_in.asset_type
7571: from fa_additions_b
7572: where asset_id = h_member_asset_id;
7573:
7574: --* Set fa_rule_in to call deprn basis rule function
7575: fa_rule_in.asset_id := h_member_asset_id;

Line 7814: from fa_additions_b

7810:
7811: -- Get Asset type
7812: select ASSET_TYPE
7813: into fa_rule_in.asset_type
7814: from fa_additions_b
7815: where asset_id = h_member_asset_id;
7816:
7817: --* Set fa_rule_in to call deprn basis rule function
7818: fa_rule_in.asset_id := h_member_asset_id;

Line 8581: FA_ADDITIONS_B AD,

8577: select distinct BK.ASSET_ID, AD.asset_number,
8578: bk_max.transaction_header_id_in as max_trx_id_in_this_group,
8579: bk_other_max.transaction_header_id_in as max_trx_id_in_other_group
8580: from FA_BOOKS BK,
8581: FA_ADDITIONS_B AD,
8582: (
8583: select distinct bk_in.asset_id, bk_in.book_type_code,
8584: first_value(bk_in.transaction_header_id_in)
8585: over (partition by bk_in.asset_id, bk_in.book_type_code

Line 8661: FA_ADDITIONS_B AD,

8657: select distinct BK.ASSET_ID, AD.asset_number,
8658: bk_max.transaction_header_id_in as max_trx_id_in_this_group,
8659: bk_other_max.transaction_header_id_in as max_trx_id_in_other_group
8660: from FA_MC_BOOKS BK,
8661: FA_ADDITIONS_B AD,
8662: (
8663: select distinct bk_in.asset_id, bk_in.book_type_code,
8664: first_value(bk_in.transaction_header_id_in)
8665: over (partition by bk_in.asset_id, bk_in.book_type_code

Line 9917: from fa_additions_b

9913:
9914: -- Get Asset type
9915: select ASSET_TYPE
9916: into fa_rule_in.asset_type
9917: from fa_additions_b
9918: where asset_id = h_member_asset_id;
9919:
9920: -- Get eofy, eop amounts
9921: if not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP

Line 10367: from fa_additions_b

10363:
10364: -- Get Asset type
10365: select ASSET_TYPE
10366: into fa_rule_in.asset_type
10367: from fa_additions_b
10368: where asset_id = h_member_asset_id;
10369:
10370: -- Get eofy, eop amounts
10371: if not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP