[Home] [Help]
31: ad.asset_category_id ,
32: ad.asset_type ,
33: ad.current_units ,
34: bc.set_of_books_id
35: from fa_transaction_headers th,
36: fa_deprn_periods dp,
37: fa_books bk,
38: fa_category_books cb,
39: fa_additions_b ad,
256: end if;
257:
258: -- Bug 6811554 : To be used in FAEVUPGB.pls
259: -- for creating the events in U/U status
260: update fa_transaction_headers
261: set event_id = -2
262: where transaction_header_id = l_adj.transaction_header_id
263: and asset_id = l_adj.asset_id
264: and book_type_code = l_adj.book_type_code;
347: ad.asset_category_id ,
348: ad.asset_type ,
349: ad.current_units ,
350: mcbc.set_of_books_id
351: from fa_transaction_headers th,
352: fa_mc_deprn_periods dp,
353: fa_mc_books bk,
354: fa_additions_b ad,
355: fa_category_books cb,
803: ds.reval_reserve,
804: ds.production,
805: ds.ytd_production,
806: ds.ltd_production
807: from fa_transaction_headers th,
808: fa_books bks,
809: fa_additions_b ad,
810: fa_book_controls bc,
811: fa_category_books cb,
884: ds.reval_reserve,
885: ds.production,
886: ds.ytd_production,
887: ds.ltd_production
888: from fa_transaction_headers th,
889: fa_mc_books bks,
890: fa_additions_b ad,
891: fa_book_controls bc,
892: fa_category_books cb,
1196: p_log_level_rec => l_log_level_rec
1197: );
1198:
1199: -- Bug 6811554 : To be used in FAEVUPGB.pls
1200: update fa_transaction_headers
1201: set event_id = -2
1202: where transaction_header_id = l_trans_rec.transaction_header_id
1203: and asset_id = l_asset_hdr_rec.asset_id
1204: and book_type_code = l_asset_hdr_rec.book_type_code;
1259: p_log_level_rec => l_log_level_rec
1260: );
1261:
1262: -- Bug 6811554 : To be used in FAEVUPGB.pls
1263: update fa_transaction_headers
1264: set event_id = -2
1265: where transaction_header_id = l_trans_rec.transaction_header_id
1266: and asset_id = l_asset_hdr_rec.asset_id
1267: and book_type_code = l_asset_hdr_rec.book_type_code;
1749: adj.source_type_code,
1750: adj.adjustment_type,
1751: adj.debit_credit_flag,
1752: adj.code_combination_id
1753: from fa_transaction_headers th,
1754: fa_book_controls bc,
1755: fa_deprn_periods dp,
1756: fa_adjustments adj,
1757: fa_asset_invoices ai,
1789: adj.source_type_code,
1790: adj.adjustment_type,
1791: adj.debit_credit_flag,
1792: adj.code_combination_id
1793: from fa_transaction_headers th,
1794: fa_book_controls bc,
1795: fa_deprn_periods dp,
1796: fa_adjustments adj,
1797: fa_distribution_history dh,