DBA Data[Home] [Help]

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