DBA Data[Home] [Help]

APPS.FA_MASSCHG_PKG dependencies on FA_MASS_CHANGES

Line 173: from fa_mass_changes mch

169: mch.from_deprn_limit_amount,
170: mch.to_deprn_limit_amount,
171: mch.from_depreciate_flag,
172: mch.to_depreciate_flag
173: from fa_mass_changes mch
174: where mch.mass_change_id = p_mass_change_id;
175:
176: -- uom
177: cursor c_assets_uom is

Line 182: fa_mass_changes mch,

178: select ad.asset_number,
179: bk.asset_id
180: from fa_additions_b ad,
181: fa_books bk,
182: fa_mass_changes mch,
183: fa_methods me
184: where mch.mass_change_id = p_mass_change_id
185: and bk.transaction_header_id_out is null
186: and bk.book_type_code = mch.book_type_code

Line 232: fa_mass_changes mch,

228: bk.date_placed_in_service,
229: bk.group_asset_id
230: from fa_additions_b ad,
231: fa_books bk,
232: fa_mass_changes mch,
233: fa_methods mt --Bug 8928436
234: where ad.asset_number >=
235: nvl(mch.from_asset_number,
236: ad.asset_number)

Line 321: fa_mass_changes mch

317: bk.date_placed_in_service,
318: bk.group_asset_id
319: from fa_additions_b ad,
320: fa_books bk,
321: fa_mass_changes mch
322: where ad.asset_number >=
323: nvl(mch.from_asset_number,
324: ad.asset_number)
325: and ad.asset_number <=