APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on FA_DISTRIBUTION_HISTORY
Line 119: FROM fa_distribution_history fdh
115: AND fb.BOOK_TYPE_CODE = sec.BOOK_TYPE_CODE))
116: ----------------------------------------------------------
117: AND fav.asset_id IN
118: (SELECT DISTINCT fdh.asset_id 119: FROM fa_distribution_history fdh 120: ,fa_transaction_headers fth
121: WHERE fdh.asset_id = fth.asset_id
122: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
123: AND EXISTS