DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_TRANSACTION_HEADERS

Line 498: FA_TRANSACTION_HEADERS TH,

494: DD.IMPAIRMENT_RESERVE
495: FROM
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

Line 499: FA_TRANSACTION_HEADERS TH_RT,

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

Line 519: , fa_transaction_headers oldth

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

Line 618: FA_TRANSACTION_HEADERS TH,

614: DD.IMPAIRMENT_RESERVE
615: FROM
616: FA_MC_DEPRN_DETAIL DD,
617: FA_ASSET_HISTORY AH,
618: FA_TRANSACTION_HEADERS TH,
619: FA_TRANSACTION_HEADERS TH_RT,
620: FA_MC_BOOKS BOOKS,
621: FA_DISTRIBUTION_HISTORY DH,
622: FA_CATEGORY_BOOKS CB

Line 619: FA_TRANSACTION_HEADERS TH_RT,

615: FROM
616: FA_MC_DEPRN_DETAIL DD,
617: FA_ASSET_HISTORY AH,
618: FA_TRANSACTION_HEADERS TH,
619: FA_TRANSACTION_HEADERS TH_RT,
620: FA_MC_BOOKS BOOKS,
621: FA_DISTRIBUTION_HISTORY DH,
622: FA_CATEGORY_BOOKS CB
623: WHERE

Line 639: , fa_transaction_headers oldth

635: ( AH.ASSET_TYPE = 'CAPITALIZED' AND
636: BOOKS.GROUP_ASSET_ID is not null
637: and exists (select 1
638: from fa_mc_books oldbk
639: , fa_transaction_headers oldth
640: , fa_mc_deprn_periods dp
641: where oldbk.transaction_header_id_out = books.transaction_header_id_in
642: and oldbk.transaction_header_id_out = oldth.transaction_header_id
643: and dp.book_type_code = book

Line 1731: fa_transaction_headers th,

1727: select
1728: distinct lu.meaning
1729: from
1730: fa_lookups lu,
1731: fa_transaction_headers th,
1732: fa_retirements r
1733: where
1734: r.asset_id = c_asset_id and
1735: r.book_type_code = c_book_type_code and