APPS.IGIRX_IMP_IAC_REP dependencies on FA_ADDITIONS

Line 421: Fa_Additions ad,

417: nvl(ii.NBV_Hist * (dh.units_Assigned/ad.current_units) ,0) NBV_Hist,
418: nvl(ii.NBV_MHCA * (dh.units_Assigned/ad.current_units) ,0) NBV_MHCA
419: FROM Igi_Imp_Iac_Interface ii,
420: Fa_Distribution_History dh,
421: Fa_Additions ad,
422: igi_imp_iac_controls ct
423: WHERE
424: ii.book_type_code=p_book_type_code AND
425: ii.CATEGORY_ID=NVL(P_CATEGORY_ID,ii.CATEGORY_ID) AND

Line 499: fa_additions ad

495: ad.serial_number ,
496: bk.date_placed_in_service ,
497: bk.deprn_method_code
498: FROM fa_books bk,
499: fa_additions ad
500: WHERE ad.asset_id=p_asset_id AND
501: ad.asset_id = bk.asset_id AND
502: bk.transaction_header_id_out is NULL AND
503: bk.book_type_code = p_book_type_code ;