APPS.FARX_MCP dependencies on FA_ADDITIONS

Line 109: fa_additions_b gad1,

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

Line 110: fa_additions_b gad2

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

Line 140: fa_additions ad,

136: bk.deprn_limit_type,
137: bk.allowed_deprn_limit,
138: bk.allowed_deprn_limit_amount -- Bug 6964615 end
139: FROM fa_books bk,
140: fa_additions ad,
141: fa_additions_b gad,
142: fa_mass_changes mch
143: WHERE mch.mass_change_id = mc_rec.mass_change_id
144: AND ad.asset_type = nvl(mch.asset_type, ad.asset_type)

Line 141: fa_additions_b gad,

137: bk.allowed_deprn_limit,
138: bk.allowed_deprn_limit_amount -- Bug 6964615 end
139: FROM fa_books bk,
140: fa_additions ad,
141: fa_additions_b gad,
142: fa_mass_changes mch
143: WHERE mch.mass_change_id = mc_rec.mass_change_id
144: AND ad.asset_type = nvl(mch.asset_type, ad.asset_type)
145: AND ad.asset_type <> 'CIP'

Line 704: FA_ADDITIONS_B ad

700: production_capacity,
701: unit_of_measure,
702: ad.asset_number
703: FROM FA_BOOKS bk,
704: FA_ADDITIONS_B ad
705: WHERE bk.asset_id = a_tbl(a_index).asset_id
706: AND bk.book_type_code = h_book_type_code
707: AND bk.date_ineffective IS NULL
708: AND bk.group_asset_id = ad.asset_id(+);