DBA Data[Home] [Help]

APPS.FARX_INV_MISS_PKG dependencies on FA_ADDITIONS_B

Line 262: fa_additions_b ad,

258: and nvl(nvl(inv.asset_number, inv.tag_number), inv.serial_number) in
259: (select nvl(nvl(inv1.asset_number, inv1.tag_number), inv1.serial_number)
260: -- End Bug# 7377673
261: from fa_inv_interface inv1,
262: fa_additions_b ad,
263: fa_books bks,
264: fa_book_controls_sec bc
265: -- Bug# 7377673
266: where ( (inv1.asset_number = ad.asset_number)

Line 284: from fa_additions_b ad

280: -- End Bug# 7377673
281: from fa_inv_interface inv2
282: where not exists
283: (select 'x'
284: from fa_additions_b ad
285: -- Bug# 7377673
286: where ( ad.asset_number = inv2.asset_number
287: or ad.tag_number = inv2.tag_number
288: -- or ad.serial_number = inv2.serial_number /* Bug 9570207 */