DBA Data[Home] [Help]

APPS.FARX_INV_MISS_PKG dependencies on FA_LOOKUPS

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))