DBA Data[Home] [Help]

APPS.FARX_MCR dependencies on FA_ADDITIONS_B

Line 107: fa_additions_b gad1,

103: mc.to_deprn_limit,
104: mc.from_deprn_limit_amount,
105: mc.to_deprn_limit_amount -- Bug 6964615 end
106: FROM fa_mass_changes mc,
107: fa_additions_b gad1,
108: fa_additions_b gad2
109: WHERE mass_change_id = X_Mass_Change_Id
110: AND mc.from_group_asset_id = gad1.asset_id(+)
111: AND mc.to_group_asset_id = gad2.asset_id(+);

Line 108: fa_additions_b gad2

104: mc.from_deprn_limit_amount,
105: mc.to_deprn_limit_amount -- Bug 6964615 end
106: FROM fa_mass_changes mc,
107: fa_additions_b gad1,
108: fa_additions_b gad2
109: WHERE mass_change_id = X_Mass_Change_Id
110: AND mc.from_group_asset_id = gad1.asset_id(+)
111: AND mc.to_group_asset_id = gad2.asset_id(+);
112:

Line 162: fa_additions_b gad1,

158: bk2.allowed_deprn_limit_amount -- Bug 6964615 end
159: FROM fa_books bk1,
160: fa_books bk2,
161: fa_additions ad,
162: fa_additions_b gad1,
163: fa_additions_b gad2,
164: fa_transaction_headers th
165: WHERE th.mass_transaction_id = mc_rec.mass_change_id
166: AND th.member_transaction_header_id is null -- exclude the spawned adjustments on groups

Line 163: fa_additions_b gad2,

159: FROM fa_books bk1,
160: fa_books bk2,
161: fa_additions ad,
162: fa_additions_b gad1,
163: fa_additions_b gad2,
164: fa_transaction_headers th
165: WHERE th.mass_transaction_id = mc_rec.mass_change_id
166: AND th.member_transaction_header_id is null -- exclude the spawned adjustments on groups
167: AND ad.asset_id = th.asset_id