APPS.FARX_MCP dependencies on FA_ADDITIONS_B

Line 109: fa_additions_b gad1,

105: mc.to_deprn_limit,
106: mc.from_deprn_limit_amount,
107: mc.to_deprn_limit_amount
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
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 141: fa_additions_b gad,

137: bk.allowed_deprn_limit,
138: bk.allowed_deprn_limit_amount
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 237: fa_additions_b gad,

233: bk.allowed_deprn_limit,
234: bk.allowed_deprn_limit_amount
235: FROM fa_books bk,
236: fa_additions ad,
237: fa_additions_b gad,
238: fa_mass_changes mch
239: WHERE mch.mass_change_id = mc_rec.mass_change_id
240: AND ad.asset_type = nvl(mch.asset_type, ad.asset_type)
241: AND ad.asset_type <> 'CIP'

Line 808: FA_ADDITIONS_B ad

804: production_capacity,
805: unit_of_measure,
806: ad.asset_number
807: FROM FA_BOOKS bk,
808: FA_ADDITIONS_B ad
809: WHERE bk.asset_id = a_tbl(a_index).asset_id
810: AND bk.book_type_code = h_book_type_code
811: AND bk.date_ineffective IS NULL
812: AND bk.group_asset_id = ad.asset_id(+);