DBA Data[Home] [Help]

APPS.FARX_INV_MISS_PKG dependencies on FA_ADDITIONS

Line 54: fa_additions ad,

50: ad.asset_key_ccid
51: FROM fa_books bk,
52: fa_distribution_history dh,
53: fa_inventory inv,
54: fa_additions ad,
55: fa_book_controls_sec bc --Bug#3503643
56: WHERE ad.inventorial = 'YES'
57: AND ad.asset_id = bk.asset_id
58: AND bk.date_ineffective is null

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)