APPS.FARX_INV_MISS_PKG dependencies on FA_INV_INTERFACE

Line 70: from fa_inv_interface itf

66: AND dh.date_ineffective is null
67: AND ad.asset_id not in
68: (
69: select itf.asset_id
70: from fa_inv_interface itf
71: where itf.inventory_name = inv.inventory_name
72: and itf.asset_id = ad.asset_id
73: );
74:

Line 244: from fa_inv_interface inv, fa_lookups lu1, fa_lookups lu2, fa_lookups lu3

240: inv.manufacturer_name, inv.asset_category_id, inv.units,
241: inv.location_id, lu1.meaning status,
242: lu2.meaning unit_reconcile_mth_mean,
243: lu3.meaning loc_reconcile_mth_mean
244: from fa_inv_interface inv, fa_lookups lu1, fa_lookups lu2, fa_lookups lu3
245: where nvl(inv.inventory_name,'X') = nvl(h_inventory_name,
246: nvl(inv.inventory_name,'X'))
247: and nvl(inv.asset_category_id,-9999) = nvl(h_cat_ccid,
248: nvl(inv.asset_category_id,-9999))

Line 261: from fa_inv_interface inv1,

257: -- Bug# 7377673
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

Line 281: from fa_inv_interface inv2

277: union
278: -- Bug# 7377673
279: select nvl(nvl(inv2.asset_number, inv2.tag_number), inv2.serial_number)
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