[Home] [Help]
88: begin
89: -- calculate Corp's TRANSFER OUT THID
90: select transaction_header_id_out
91: into l_id_out
92: from fa_distribution_history
93: where retirement_id =
94: (select r.retirement_id
95: from fa_transaction_headers sth
96: ,fa_retirements r
167: if nvl(ret.mrc_sob_type_code,'P') <> 'R' then
168:
169: select 2 -- this has to be set to 2 to differ from 1 for a regular balance tfr; used for fagurt
170: into l_balance_tfr_in_tax
171: from fa_distribution_history
172: where asset_id = RET.asset_id
173: and transaction_header_id_out is NULL
174: and rownum = 1
175: and distribution_id =
190: else
191:
192: select 2 -- this has to be set to 2 to differ from 1 for a regular balance tfr; used for fagurt
193: into l_balance_tfr_in_tax
194: from fa_distribution_history
195: where asset_id = RET.asset_id
196: and transaction_header_id_out is NULL
197: and rownum = 1
198: and distribution_id =
520: CODE_COMBINATION_ID,
521: LOCATION_ID,
522: ASSIGNED_TO, -- bug 3519644
523: TRANSACTION_HEADER_ID_OUT
524: FROM FA_DISTRIBUTION_HISTORY dist,
525: FA_BOOK_CONTROLS bc
526: -- Bug 5149832 WHERE RETIREMENT_ID = ret.retirement_id
527: WHERE RETIREMENT_ID = nvl(l_ret_id_in_corp, ret.retirement_id)
528: AND ASSET_ID = ret.asset_id
535: c_location_id number,
536: c_assigned_to number, -- bug 3519644
537: c_th_id_out number) IS
538: SELECT DISTRIBUTION_ID
539: FROM FA_DISTRIBUTION_HISTORY dist,
540: FA_BOOK_CONTROLS bc
541: WHERE dist.TRANSACTION_HEADER_ID_IN = c_th_id_out
542: AND dist.TRANSACTION_HEADER_ID_OUT is NULL
543: AND dist.CODE_COMBINATION_ID = c_ccid
554: c_location_id number,
555: c_assigned_to number,
556: c_th_id_out number) IS
557: SELECT DISTRIBUTION_ID
558: FROM FA_DISTRIBUTION_HISTORY dist,
559: FA_BOOK_CONTROLS bc
560: WHERE
561: dist.CODE_COMBINATION_ID = c_ccid
562: AND dist.LOCATION_ID = c_location_id
587: Modified c_ret_amount cursor to handle TAX book as well */
588: CURSOR c_ret_amount (c_asset_id number) is
589: SELECT DISTRIBUTION_ID,
590: CODE_COMBINATION_ID
591: FROM FA_DISTRIBUTION_HISTORY dist,
592: FA_BOOK_CONTROLS bc
593: WHERE TRANSACTION_HEADER_ID_OUT is NULL
594: AND ASSET_ID = c_asset_id
595: AND bc.book_type_code = ret.book
1217: if (ret.units_retired is null and NOT l_unit_ret_in_corp) then
1218:
1219: SELECT count(*)
1220: INTO tot_dist_lines
1221: FROM FA_DISTRIBUTION_HISTORY dist,
1222: FA_BOOK_CONTROLS bc
1223: WHERE TRANSACTION_HEADER_ID_OUT is NULL
1224: AND ASSET_ID = RET.asset_id
1225: AND bc.book_type_code = RET.book
1228: else
1229:
1230: SELECT count(*)
1231: INTO tot_dist_lines
1232: FROM FA_DISTRIBUTION_HISTORY dist,
1233: FA_BOOK_CONTROLS bc
1234: WHERE dist.RETIREMENT_ID = nvl(l_ret_id_in_corp, ret.retirement_id)
1235: AND dist.ASSET_ID = RET.asset_id
1236: AND bc.book_type_code = RET.book
1895:
1896: else
1897: select distinct nvl(transaction_header_id_out,0)
1898: into h_id_out
1899: from fa_distribution_history
1900: where asset_id = h_asset_id
1901: and book_type_code = h_book
1902: and retirement_id = h_ret_id;
1903:
1934:
1935: begin
1936: select count(*)
1937: into l_dummy
1938: from fa_distribution_history
1939: where asset_id = h_asset_id
1940: and date_ineffective is null
1941: and transaction_header_id_in = h_id_out;
1942:
1941: and transaction_header_id_in = h_id_out;
1942:
1943: select sum(nvl(units_assigned,0))
1944: into h_cur_units
1945: from fa_distribution_history
1946: where asset_id = h_asset_id
1947: and date_ineffective is null
1948: and transaction_header_id_in = h_id_out;
1949:
2198: 'REVAL AMORT', fadd.reval_amortization)),0),
2199: nvl(faadj.source_type_code, 'DEPRECIATION'),
2200: fadp.period_counter
2201: FROM
2202: fa_distribution_history fadh,
2203: fa_deprn_detail fadd,
2204: fa_deprn_periods fadp,
2205: fa_adjustments faadj
2206: WHERE
2244: 0,
2245: nvl(faadj.source_type_code, 'DEPRECIATION'),
2246: fadp.period_counter
2247: FROM
2248: fa_distribution_history fadh,
2249: fa_deprn_periods fadp,
2250: fa_adjustments faadj
2251: WHERE
2252: fadp.period_num = h_i
2299: 'REVAL AMORT', fadd.reval_amortization)),0),
2300: nvl(faadj.source_type_code, 'DEPRECIATION'),
2301: fadp.period_counter
2302: FROM
2303: fa_distribution_history fadh,
2304: fa_deprn_detail_mrc_v fadd,
2305: fa_deprn_periods fadp,
2306: fa_adjustments_mrc_v faadj
2307: WHERE
2345: 0,
2346: nvl(faadj.source_type_code, 'DEPRECIATION'),
2347: fadp.period_counter
2348: FROM
2349: fa_distribution_history fadh,
2350: fa_deprn_periods fadp,
2351: fa_adjustments_mrc_v faadj
2352: WHERE
2353: fadp.period_num = h_i
5221:
5222: begin
5223: select distinct nvl(transaction_header_id_out,0)
5224: into h_id_out
5225: from fa_distribution_history
5226: where asset_id = h_asset_id
5227: and book_type_code = h_book
5228: and retirement_id = h_ret_id;
5229:
5238: begin
5239:
5240: select sum(nvl(units_assigned,0))
5241: into h_sum_of_part_active_units
5242: from fa_distribution_history
5243: where asset_id = h_asset_id
5244: and transaction_header_id_in = h_id_out
5245: and date_ineffective is null;
5246:
5312: begin
5313:
5314: select count(*)
5315: into l_dummy
5316: from fa_distribution_history
5317: where asset_id = h_asset_id
5318: and date_ineffective is null
5319: and transaction_header_id_in = h_id_out;
5320:
5320:
5321: /* Fix for Bug#4617352 */
5322: select sum(nvl(units_assigned,0))
5323: into h_cur_units
5324: from fa_distribution_history
5325: where asset_id = h_asset_id
5326: and date_ineffective is null
5327: and transaction_header_id_in = h_id_out;
5328: