DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_BOOKS

Line 500: FA_BOOKS BOOKS,

496: FA_DEPRN_DETAIL DD,
497: FA_ASSET_HISTORY AH,
498: FA_TRANSACTION_HEADERS TH,
499: FA_TRANSACTION_HEADERS TH_RT,
500: FA_BOOKS BOOKS,
501: FA_DISTRIBUTION_HISTORY DH,
502: FA_CATEGORY_BOOKS CB
503: WHERE
504: CB.BOOK_TYPE_CODE = book AND

Line 518: from fa_books oldbk

514: ) OR
515: ( AH.ASSET_TYPE = 'CAPITALIZED' AND
516: BOOKS.GROUP_ASSET_ID is not null
517: and exists (select 1
518: from fa_books oldbk
519: , fa_transaction_headers oldth
520: , fa_deprn_periods dp
521: where oldbk.transaction_header_id_out = books.transaction_header_id_in
522: and oldbk.transaction_header_id_out = oldth.transaction_header_id