DBA Data[Home] [Help]

APPS.CSE_ASSET_WIP_PKG dependencies on FA_ADDITIONS

Line 79: FROM fa_additions faa,

75: c_asset_id IN NUMBER)
76: IS
77: SELECT fab.cost,
78: faa.current_units
79: FROM fa_additions faa,
80: fa_books fab
81: WHERE fab.book_type_code = c_book_type_code
82: AND fab.asset_id = c_asset_id
83: AND faa.asset_id = fab.asset_id ;

Line 241: fa_additions faa

237: faa.description,
238: faa.asset_category_id,
239: faa.asset_key_ccid
240: FROM fa_books fab ,
241: fa_additions faa
242: WHERE fab.book_type_code = p_book_type_code
243: AND fab.asset_id = p_asset_id
244: AND faa.asset_id = fab.asset_id
245: AND fab.date_ineffective IS NULL ;