DBA Data[Home] [Help]

APPS.FARX_INV_MISS_PKG dependencies on FA_BOOK_CONTROLS_SEC

Line 55: fa_book_controls_sec bc --Bug#3503643

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
59: AND bk.period_counter_fully_retired is null

Line 264: fa_book_controls_sec bc

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)
267: or ( inv1.asset_number is null
268: and inv1.tag_number = ad.tag_number)