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_ADJUSTMENTS

Line 215: -- So allocated amount will be inserted/updated into FA_ADJUSTMENTS or FA_DEPRN_SUMMARY/DETAIL

211: if nvl(P_mode,'DEPRECIATION') = 'UNPLANNED' or
212: nvl(P_mode,'DEPRECIATION') = 'GROUP ADJUSTMENT' then
213:
214: -- This is a case when this program is called from Group Adjustments.
215: -- So allocated amount will be inserted/updated into FA_ADJUSTMENTS or FA_DEPRN_SUMMARY/DETAIL
216: -- or FA_BOOKS following P_mode
217:
218: if not ins_dd_adj(P_book_type_Code => P_book_type_code,
219: P_group_asset_id => P_group_asset_id,

Line 433: from fa_adjustments aj

429: -- select nvl(sum(decode(aj.adjustment_type, 'RESERVE', decode(aj.debit_credit_flag, 'DR', -1, 1) * aj.adjustment_amount,
430: -- 'EXPENSE', )), 0)
431: select nvl(sum(decode(aj.adjustment_type, 'RESERVE',decode(aj.debit_credit_flag, 'DR', -1, 1),
432: 'EXPENSE',decode(aj.debit_credit_flag, 'CR', -1, 1))* aj.adjustment_amount), 0)
433: from fa_adjustments aj
434: where aj.asset_id = c_asset_id
435: and aj.book_type_code = h_book_type_code
436: and aj.period_counter_created = h_period_counter
437: and aj.adjustment_type in ('RESERVE', 'EXPENSE');

Line 725: --* Cursor for FA_ADJUSTMENTS

721: where book_type_code = h_book_type_code
722: and period_counter = p_period_counter
723: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);
724:
725: --* Cursor for FA_ADJUSTMENTS
726: cursor FA_ADJ_EXPENSE(p_member_asset_id number) is
727: select sum(decode(adj.adjustment_type,'EXPENSE',
728: decode(adj.debit_credit_flag,
729: 'DR',adj.adjustment_amount,

Line 737: fa_adjustments adj

733: 'DR',adj.adjustment_amount,
734: 'CR', -1 * adj.adjustment_amount)))
735: from fa_transaction_headers th1,
736: fa_transaction_headers th2,
737: fa_adjustments adj
738: where adj.transaction_header_id = th1.transaction_header_id
739: and adj.asset_id = h_group_asset_id
740: and adj.book_type_code = h_book_type_code
741: and adj.period_counter_adjusted = h_period_counter

Line 776: --* Cursor for FA_ADJUSTMENTS for unplanned depreciation

772: and period_counter = P_period_counter
773: and fiscal_year = P_fiscal_year
774: and (nvl(fully_reserved_flag,'N') = 'Y' or nvl(override_flag,'N') = 'Y');
775:
776: --* Cursor for FA_ADJUSTMENTS for unplanned depreciation
777: cursor FA_ADJ_UNPLANNED is
778: select /*+ ORDERED Index(TH2 FA_TRANSACTION_HEADERS_N1)
779: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
780: INDEX(ADJ FA_ADJUSTMENTS_U1)*/

Line 780: INDEX(ADJ FA_ADJUSTMENTS_U1)*/

776: --* Cursor for FA_ADJUSTMENTS for unplanned depreciation
777: cursor FA_ADJ_UNPLANNED is
778: select /*+ ORDERED Index(TH2 FA_TRANSACTION_HEADERS_N1)
779: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
780: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
781: sum(decode(adj.adjustment_type,'EXPENSE',
782: decode(adj.debit_credit_flag,
783: 'DR',adj.adjustment_amount,
784: 'CR', -1 * adj.adjustment_amount)))

Line 787: fa_adjustments adj

783: 'DR',adj.adjustment_amount,
784: 'CR', -1 * adj.adjustment_amount)))
785: from fa_transaction_headers th2,
786: fa_transaction_headers th1,
787: fa_adjustments adj
788: where adj.transaction_header_id = th1.transaction_header_id
789: and adj.asset_id = h_group_asset_id
790: and adj.book_type_code = h_book_type_code
791: and adj.period_counter_adjusted = h_period_counter

Line 803: from fa_adjustments adj,

799: select sum(decode(adj.adjustment_type,'EXPENSE',
800: decode(adj.debit_credit_flag,
801: 'DR',adj.adjustment_amount,
802: 'CR', -1 * adj.adjustment_amount)))
803: from fa_adjustments adj,
804: fa_transaction_headers th
805: where adj.book_type_code = h_book_type_code
806: and adj.asset_id = h_unplanned_member_asset
807: and adj.period_counter_adjusted = h_period_counter

Line 856: , fa_adjustments adj

852: , decode(adj.debit_credit_flag, 'DR',adj.adjustment_amount
853: , 'CR', -1 * adj.adjustment_amount))
854: )
855: from fa_track_members tm
856: , fa_adjustments adj
857: , fa_transaction_headers th1
858: , fa_transaction_headers th2
859: where tm.group_asset_id = P_group_asset_id
860: and tm.period_counter = P_period_counter

Line 920: from fa_adjustments aj

916:
917: --bug 11927088
918: cursor c_adj_count(c_asset_id number) is
919: select count(1)
920: from fa_adjustments aj
921: where aj.asset_id = c_asset_id
922: and aj.book_type_code = h_book_type_code
923: and aj.period_counter_created = h_period_counter
924: and aj.adjustment_type in ('RESERVE', 'EXPENSE')

Line 3265: --* Cursor for FA_ADJUSTMENTS

3261: where book_type_code = P_book_type_code
3262: and period_counter = p_per_counter
3263: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);
3264:
3265: --* Cursor for FA_ADJUSTMENTS
3266: cursor FA_ADJ_EXPENSE(p_member_asset_id number) is
3267: select /*+ ORDERED
3268: Index(TH2 FA_TRANSACTION_HEADERS_N1)
3269: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)

Line 3270: INDEX(ADJ FA_ADJUSTMENTS_U1)*/

3266: cursor FA_ADJ_EXPENSE(p_member_asset_id number) is
3267: select /*+ ORDERED
3268: Index(TH2 FA_TRANSACTION_HEADERS_N1)
3269: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
3270: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
3271: sum(decode(adj.adjustment_type,'EXPENSE',
3272: decode(adj.debit_credit_flag,
3273: 'DR',adj.adjustment_amount,
3274: 'CR', -1 * adj.adjustment_amount))),

Line 3281: fa_adjustments adj

3277: 'DR',adj.adjustment_amount,
3278: 'CR', -1 * adj.adjustment_amount)))
3279: from fa_transaction_headers th2,
3280: fa_transaction_headers th1,
3281: fa_adjustments adj
3282: where adj.transaction_header_id = th1.transaction_header_id
3283: and adj.asset_id = p_group_asset_id
3284: and adj.book_type_code = p_book_type_code
3285: and adj.period_counter_adjusted = p_period_counter

Line 3290: --* Cursor for FA_ADJUSTMENTS

3286: and th1.asset_id = adj.asset_id
3287: and th1.member_transaction_header_id = th2.transaction_header_id
3288: and th2.asset_id = nvl(p_member_asset_id,th2.asset_id);
3289:
3290: --* Cursor for FA_ADJUSTMENTS
3291: cursor FA_ADJ_EXPENSE_MRC (p_member_asset_id number) is
3292: select
3293: sum(decode(adj.adjustment_type,'EXPENSE',
3294: decode(adj.debit_credit_flag,

Line 4045: --* Cursor for FA_ADJUSTMENTS

4041: and fiscal_year = h_fiscal_year
4042: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);
4043:
4044: --* For ADJUSTMENT table
4045: --* Cursor for FA_ADJUSTMENTS
4046: cursor FA_ADJ_EXPENSE is
4047: select sum(decode(adj.adjustment_type,'EXPENSE',
4048: decode(adj.debit_credit_flag,
4049: 'DR',adj.adjustment_amount,

Line 4055: from fa_adjustments adj,

4051: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
4052: decode(adj.debit_credit_flag,
4053: 'DR',adj.adjustment_amount,
4054: 'CR', -1 * adj.adjustment_amount)))
4055: from fa_adjustments adj,
4056: fa_transaction_headers th1,
4057: fa_transaction_headers th2
4058: where adj.transaction_header_id = th1.transaction_header_id
4059: and adj.asset_id = h_group_asset_id

Line 4075: from fa_adjustments adj

4071: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
4072: decode(adj.debit_credit_flag,
4073: 'DR',adj.adjustment_amount,
4074: 'CR', -1 * adj.adjustment_amount)))
4075: from fa_adjustments adj
4076: where adj.book_type_code = h_book_type_code
4077: and adj.asset_id = h_member_asset_id
4078: and adj.period_counter_adjusted = h_period_counter;
4079:

Line 4080: --* Cursor for FA_ADJUSTMENTS

4076: where adj.book_type_code = h_book_type_code
4077: and adj.asset_id = h_member_asset_id
4078: and adj.period_counter_adjusted = h_period_counter;
4079:
4080: --* Cursor for FA_ADJUSTMENTS
4081: cursor FA_ADJ_EXPENSE_MRC is
4082: select sum(decode(adj.adjustment_type,'EXPENSE',
4083: decode(adj.debit_credit_flag,
4084: 'DR',adj.adjustment_amount,

Line 4164: --* Cursor for FA_ADJUSTMENTS (Reserve Adjustments)

4160: and old_bk.asset_id = new_bk.asset_id
4161: and old_bk.transaction_header_id_out = new_bk.transaction_header_id_in
4162: and old_bk.set_of_books_id = h_set_of_books_id;
4163:
4164: --* Cursor for FA_ADJUSTMENTS (Reserve Adjustments)
4165: /*
4166: cursor FA_ADJ_RESERVE is
4167: select sum(decode(adj.adjustment_type,'RESERVE',
4168: decode(adj.debit_credit_flag,

Line 4183: from fa_adjustments adj,

4179: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4180: decode(adj.debit_credit_flag,
4181: 'CR',adj.adjustment_amount,
4182: 'DR', -1 * adj.adjustment_amount))),0)
4183: from fa_adjustments adj,
4184: fa_transaction_headers th1,
4185: fa_transaction_headers th2
4186: where adj.transaction_header_id = th1.transaction_header_id
4187: and adj.asset_id = h_group_asset_id

Line 4214: from fa_adjustments adj,

4210: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4211: decode(adj.debit_credit_flag,
4212: 'CR',adj.adjustment_amount,
4213: 'DR', -1 * adj.adjustment_amount))),0)
4214: from fa_adjustments adj,
4215: fa_transaction_headers th1
4216: where adj.transaction_header_id = th1.transaction_header_id
4217: and adj.asset_id = h_member_asset_id
4218: and adj.book_type_code = h_book_type_code

Line 4243: from fa_adjustments adj

4239: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4240: decode(adj.debit_credit_flag,
4241: 'CR',adj.adjustment_amount,
4242: 'DR', -1 * adj.adjustment_amount))),0)
4243: from fa_adjustments adj
4244: where adj.book_type_code = h_book_type_code
4245: and adj.asset_id = h_member_asset_id
4246: and adj.period_counter_adjusted = h_period_counter
4247: and nvl(adj.track_member_flag, 'N') = 'N'; -- ENERGY

Line 4249: --* Cursor for FA_ADJUSTMENTS

4245: and adj.asset_id = h_member_asset_id
4246: and adj.period_counter_adjusted = h_period_counter
4247: and nvl(adj.track_member_flag, 'N') = 'N'; -- ENERGY
4248:
4249: --* Cursor for FA_ADJUSTMENTS
4250: cursor FA_ADJ_RESERVE_MRC is
4251: select /*+ ORDERED
4252: Index(TH2 FA_TRANSACTION_HEADERS_N1)
4253: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)

Line 4254: INDEX(ADJ FA_ADJUSTMENTS_U1)*/

4250: cursor FA_ADJ_RESERVE_MRC is
4251: select /*+ ORDERED
4252: Index(TH2 FA_TRANSACTION_HEADERS_N1)
4253: INDEX(TH1 FA_TRANSACTION_HEADERS_N7)
4254: INDEX(ADJ FA_ADJUSTMENTS_U1)*/
4255: sum(decode(adj.adjustment_type,'RESERVE',
4256: decode(adj.debit_credit_flag,
4257: 'CR',adj.adjustment_amount,
4258: 'DR', -1 * adj.adjustment_amount))),

Line 5163: -- Check FA_ADJUSTMENTS table if there is any depreciation expense during this period.

5159: fa_debug_pkg.add(l_calling_fn, 'h_net_proceeds', h_net_proceeds, p_log_level_rec => p_log_level_rec);
5160: end if;
5161:
5162: if p_group_rule_in.event_type = 'AFTER_DEPRN' and member.fully_reserved_flag is null then
5163: -- Check FA_ADJUSTMENTS table if there is any depreciation expense during this period.
5164:
5165: fa_rule_in.current_total_rsv := member.temp_deprn_reserve + nvl(h_rsv_adjustment,0);
5166: fa_rule_in.current_rsv := member.temp_deprn_reserve + nvl(h_rsv_adjustment,0)
5167: - (member.temp_bonus_deprn_reserve + nvl(h_bonus_rsv_adjustment,0));

Line 6379: from fa_adjustments adj

6375: cursor FA_ADJ_RESERVE is
6376: select sum(decode(adj.debit_credit_flag,
6377: 'DR',adj.adjustment_amount,
6378: 'CR', -1 * adj.adjustment_amount))
6379: from fa_adjustments adj
6380: where adj.book_type_code = h_book_type_code
6381: and adj.asset_id = h_member_asset_id
6382: and adj.adjustment_type = 'RESERVE'
6383: and adj.source_type_code = 'ADJUSTMENT'

Line 8892: from fa_adjustments adj

8888: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
8889: decode(adj.debit_credit_flag,
8890: 'DR',adj.adjustment_amount,
8891: 'CR', -1 * adj.adjustment_amount)))
8892: from fa_adjustments adj
8893: where adj.asset_id = h_group_asset_id
8894: and adj.book_type_code = h_book_type_code
8895: and adj.period_counter_adjusted = p_period_counter;
8896:

Line 10759: from fa_adjustments adj

10755: cursor FA_ADJ_RESERVE is
10756: select sum(decode(adj.debit_credit_flag,
10757: 'DR',adj.adjustment_amount,
10758: 'CR', -1 * adj.adjustment_amount))
10759: from fa_adjustments adj
10760: where adj.book_type_code = h_book_type_code
10761: and adj.asset_id = h_member_asset_id
10762: and adj.adjustment_type = 'RESERVE'
10763: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY

Line 11759: from fa_adjustments adj,

11755: decode(adj.debit_credit_flag,
11756: 'DR',adj.adjustment_amount,
11757: 'CR', -1 * adj.adjustment_amount))) as mem_unpln_exp,
11758: th2.asset_id member_asset_id
11759: from fa_adjustments adj,
11760: fa_adjustments adj_mem,
11761: fa_transaction_headers th1,
11762: fa_transaction_headers th2
11763: where adj.transaction_header_id = th1.transaction_header_id

Line 11760: fa_adjustments adj_mem,

11756: 'DR',adj.adjustment_amount,
11757: 'CR', -1 * adj.adjustment_amount))) as mem_unpln_exp,
11758: th2.asset_id member_asset_id
11759: from fa_adjustments adj,
11760: fa_adjustments adj_mem,
11761: fa_transaction_headers th1,
11762: fa_transaction_headers th2
11763: where adj.transaction_header_id = th1.transaction_header_id
11764: and adj.asset_id = p_group_asset_id