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_BASIS2_PKG dependencies on FA_TRACK_MEMBERS

Line 375: from FA_TRACK_MEMBERS TRC

371: select nvl(sum(TRC.adjusted_cost),0) fully_rsv_adjusted_cost,
372: nvl(sum(TRC.salvage_value),0) fully_rsv_salvage_value,
373: nvl(sum(TRC.recoverable_cost),0) fully_rsv_recoverable_cost,
374: nvl(sum(TRC.deprn_reserve),0) fully_rsv_deprn_reserve
375: from FA_TRACK_MEMBERS TRC
376: where TRC.GROUP_ASSET_ID = px_rule_in.asset_id
377: and TRC.PERIOD_COUNTER <= p_period_counter
378: and TRC.FULLY_RESERVED_FLAG='Y'
379: and nvl(TRC.SET_OF_BOOKS_ID,-99) = nvl(h_set_of_books_id,-99) /*Bug# 6933726 Added filter conition for MRC */

Line 388: from FA_TRACK_MEMBERS TRC

384: select nvl(sum(TRC.adjusted_cost),0) fully_rsv_adjusted_cost,
385: nvl(sum(TRC.salvage_value),0) fully_rsv_salvage_value,
386: nvl(sum(TRC.recoverable_cost),0) fully_rsv_recoverable_cost,
387: nvl(sum(TRC.deprn_reserve),0) fully_rsv_deprn_reserve
388: from FA_TRACK_MEMBERS TRC
389: where TRC.GROUP_ASSET_ID = px_rule_in.asset_id
390: and TRC.PERIOD_COUNTER = p_period_counter
391: and TRC.FULLY_RESERVED_FLAG='Y'
392: and nvl(TRC.SET_OF_BOOKS_ID,-99) = nvl(h_set_of_books_id,-99) /*Bug# 6933726 Added filter conition for MRC */

Line 398: from FA_TRACK_MEMBERS TRC

394:
395: cursor MIN_TRC_PERIOD
396: is
397: select min(TRC.period_counter)
398: from FA_TRACK_MEMBERS TRC
399: where TRC.GROUP_ASSET_ID = px_rule_in.asset_id
400: and TRC.MEMBER_ASSET_ID is not null
401: and nvl(TRC.SET_OF_BOOKS_ID,-99) = nvl(h_set_of_books_id,-99); /*Bug# 6933726 Added filter conition for MRC */
402:

Line 510: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS

506: l_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value
507: l_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost
508: l_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve
509:
510: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
511: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:

Line 511: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS

507: l_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost
508: l_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve
509:
510: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
511: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS

Line 512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS

508: l_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve
509:
510: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
511: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
516: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS

Line 513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS

509:
510: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
511: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
516: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
517: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS

Line 522: l_trc_min_period_counter NUMBER :=null; -- Minimum period counter on FA_TRACK_MEMBERS

518: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
519:
520: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag
521: l_exclude_salvage_value_flag VARCHAR2(3); -- Exclude salvage value flag
522: l_trc_min_period_counter NUMBER :=null; -- Minimum period counter on FA_TRACK_MEMBERS
523: l_mem_ret_adj_cost NUMBER :=0; -- Member retirement adjusted cost
524:
525: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis2_pkg.flat_extension';
526: l_function VARCHAR2(20) := 'flat_extension';

Line 949: -- Query fully Reserved member assets info from FA_TRACK_MEMBERS

945: else -- Not use old_adjusted_cost
946:
947: if nvl(px_rule_in.used_by_adjustment,'NULL') <> 'ADJUSTMENT' then
948: --
949: -- Query fully Reserved member assets info from FA_TRACK_MEMBERS
950: --
951: open FULL_RSV_MEMBER_TRC (px_rule_in.period_counter);
952: fetch FULL_RSV_MEMBER_TRC into trc_fully_rsv_adjusted_cost,
953: trc_fully_rsv_salvage_value,

Line 959: -- Query Minimum period counter on FA_TRACK_MEMBERS

955: trc_fully_rsv_deprn_reserve;
956: close FULL_RSV_MEMBER_TRC;
957:
958: --
959: -- Query Minimum period counter on FA_TRACK_MEMBERS
960: --
961: open MIN_TRC_PERIOD;
962: fetch MIN_TRC_PERIOD into l_trc_min_period_counter;
963: