DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_BOOKS

Line 477: FA_BOOKS BOOKS,

473: FA_DEPRN_DETAIL DD,
474: FA_ASSET_HISTORY AH,
475: FA_TRANSACTION_HEADERS TH,
476: FA_TRANSACTION_HEADERS TH_RT,
477: FA_BOOKS BOOKS,
478: FA_DISTRIBUTION_HISTORY DH,
479: FA_CATEGORY_BOOKS CB
480: WHERE
481: CB.BOOK_TYPE_CODE = book AND

Line 495: from fa_books oldbk

491: ) OR
492: ( AH.ASSET_TYPE = 'CAPITALIZED' AND
493: BOOKS.GROUP_ASSET_ID is not null
494: and exists (select 1
495: from fa_books oldbk
496: , fa_transaction_headers oldth
497: , fa_deprn_periods dp
498: where oldbk.transaction_header_id_out = books.transaction_header_id_in
499: and oldbk.transaction_header_id_out = oldth.transaction_header_id