DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_TRANSACTION_HEADERS

Line 475: FA_TRANSACTION_HEADERS TH,

471: DH.DISTRIBUTION_ID
472: FROM
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

Line 476: FA_TRANSACTION_HEADERS TH_RT,

472: FROM
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

Line 496: , fa_transaction_headers oldth

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
500: and dp.book_type_code = book

Line 1579: fa_transaction_headers th,

1575: select
1576: distinct lu.meaning
1577: from
1578: fa_lookups lu,
1579: fa_transaction_headers th,
1580: fa_retirements r
1581: where
1582: r.asset_id = c_asset_id and
1583: r.book_type_code = c_book_type_code and