[Home] [Help]
439: -- ENERGY
440: cursor c_get_mc_adj(c_asset_id number) is
441: select nvl(sum(decode(aj.adjustment_type, 'RESERVE',decode(aj.debit_credit_flag, 'DR', -1, 1),
442: 'EXPENSE',decode(aj.debit_credit_flag, 'CR', -1, 1))* aj.adjustment_amount), 0)
443: from fa_mc_adjustments aj
444: where aj.asset_id = c_asset_id
445: and aj.book_type_code = h_book_type_code
446: and aj.period_counter_created = h_period_counter
447: and aj.adjustment_type in ('RESERVE', 'EXPENSE')
751: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
752: decode(adj.debit_credit_flag,
753: 'DR',adj.adjustment_amount,
754: 'CR', -1 * adj.adjustment_amount)))
755: from fa_mc_adjustments adj,
756: fa_transaction_headers th1,
757: fa_transaction_headers th2
758: where adj.transaction_header_id = th1.transaction_header_id
759: and adj.asset_id = h_group_asset_id
814: select sum(decode(adj.adjustment_type,'EXPENSE',
815: decode(adj.debit_credit_flag,
816: 'DR',adj.adjustment_amount,
817: 'CR', -1 * adj.adjustment_amount)))
818: from fa_mc_adjustments adj,
819: fa_transaction_headers th1,
820: fa_transaction_headers th2
821: where adj.transaction_header_id = th1.transaction_header_id
822: and adj.asset_id = h_group_asset_id
833: select sum(decode(adj.adjustment_type,'EXPENSE',
834: decode(adj.debit_credit_flag,
835: 'DR',adj.adjustment_amount,
836: 'CR', -1 * adj.adjustment_amount)))
837: from fa_mc_adjustments adj,
838: fa_transaction_headers th
839: where adj.book_type_code = h_book_type_code
840: and adj.asset_id = h_member_asset_id
841: and adj.set_of_books_id = p_set_of_books_id
878: , decode(adj.debit_credit_flag, 'DR',adj.adjustment_amount
879: , 'CR', -1 * adj.adjustment_amount))
880: )
881: from fa_track_members tm
882: , fa_mc_adjustments adj
883: , fa_transaction_headers th1
884: , fa_transaction_headers th2
885: where tm.group_asset_id = P_group_asset_id
886: and tm.period_counter = P_period_counter
925: and aj.adjustment_amount <> 0;
926:
927: cursor c_mc_adj_count(c_asset_id number) is
928: select count(1)
929: from fa_mc_adjustments aj
930: where aj.asset_id = c_asset_id
931: and aj.book_type_code = h_book_type_code
932: and aj.period_counter_created = h_period_counter
933: and aj.adjustment_type in ('RESERVE', 'EXPENSE')
3299: 'DR',adj.adjustment_amount,
3300: 'CR', -1 * adj.adjustment_amount)))
3301: from fa_transaction_headers th2,
3302: fa_transaction_headers th1,
3303: fa_mc_adjustments adj
3304: where adj.transaction_header_id = th1.transaction_header_id
3305: and adj.asset_id = p_group_asset_id
3306: and adj.book_type_code = p_book_type_code
3307: and adj.period_counter_adjusted = p_period_counter
4086: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
4087: decode(adj.debit_credit_flag,
4088: 'DR',adj.adjustment_amount,
4089: 'CR', -1 * adj.adjustment_amount)))
4090: from fa_mc_adjustments adj,
4091: fa_transaction_headers th1,
4092: fa_transaction_headers th2
4093: where adj.transaction_header_id = th1.transaction_header_id
4094: and adj.asset_id = h_group_asset_id
4107: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
4108: decode(adj.debit_credit_flag,
4109: 'DR',adj.adjustment_amount,
4110: 'CR', -1 * adj.adjustment_amount)))
4111: from fa_mc_adjustments adj
4112: where adj.book_type_code = h_book_type_code
4113: and adj.asset_id = h_member_asset_id
4114: and adj.set_of_books_id = h_set_of_books_id
4115: and adj.period_counter_adjusted = h_period_counter;
4269: 'CR',adj.adjustment_amount,
4270: 'DR', -1 * adj.adjustment_amount))),0)
4271: from fa_transaction_headers th2,
4272: fa_transaction_headers th1,
4273: fa_mc_adjustments adj
4274: where adj.transaction_header_id = th1.transaction_header_id
4275: and adj.asset_id = h_group_asset_id
4276: and adj.book_type_code = h_book_type_code
4277: and adj.period_counter_adjusted = h_period_counter
4297: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4298: decode(adj.debit_credit_flag,
4299: 'CR',adj.adjustment_amount,
4300: 'DR', -1 * adj.adjustment_amount))),0)
4301: from fa_mc_adjustments adj
4302: where adj.book_type_code = h_book_type_code
4303: and adj.asset_id = h_member_asset_id
4304: and adj.set_of_books_id = h_set_of_books_id
4305: and adj.period_counter_adjusted = h_period_counter
6395: cursor FA_ADJ_RESERVE_MRC is
6396: select sum(decode(adj.debit_credit_flag,
6397: 'DR',adj.adjustment_amount,
6398: 'CR', -1 * adj.adjustment_amount))
6399: from fa_mc_adjustments adj
6400: where adj.book_type_code = h_book_type_code
6401: and adj.asset_id = h_member_asset_id
6402: and adj.adjustment_type = 'RESERVE'
6403: and adj.source_type_code = 'ADJUSTMENT'
8902: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
8903: decode(adj.debit_credit_flag,
8904: 'DR',adj.adjustment_amount,
8905: 'CR', -1 * adj.adjustment_amount)))
8906: from fa_mc_adjustments adj
8907: where adj.asset_id = h_group_asset_id
8908: and adj.book_type_code = h_book_type_code
8909: and adj.period_counter_adjusted = p_period_counter
8910: and set_of_books_id = h_set_of_books_id;
10776: cursor FA_ADJ_RESERVE_MRC is
10777: select sum(decode(adj.debit_credit_flag,
10778: 'DR',adj.adjustment_amount,
10779: 'CR', -1 * adj.adjustment_amount))
10780: from fa_mc_adjustments adj
10781: where adj.book_type_code = h_book_type_code
10782: and adj.asset_id = h_member_asset_id
10783: and adj.adjustment_type = 'RESERVE'
10784: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
11783: decode(adj.debit_credit_flag,
11784: 'DR',adj.adjustment_amount,
11785: 'CR', -1 * adj.adjustment_amount))) as mem_unpln_exp,
11786: th2.asset_id member_asset_id
11787: from fa_mc_adjustments adj,
11788: fa_mc_adjustments adj_mem,
11789: fa_transaction_headers th1,
11790: fa_transaction_headers th2
11791: where adj.transaction_header_id = th1.transaction_header_id
11784: 'DR',adj.adjustment_amount,
11785: 'CR', -1 * adj.adjustment_amount))) as mem_unpln_exp,
11786: th2.asset_id member_asset_id
11787: from fa_mc_adjustments adj,
11788: fa_mc_adjustments adj_mem,
11789: fa_transaction_headers th1,
11790: fa_transaction_headers th2
11791: where adj.transaction_header_id = th1.transaction_header_id
11792: and adj.asset_id = p_group_asset_id