eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_TRANSFER_PVT dependencies on FA_TRANSACTION_HEADERS

Line 669: from fa_transaction_headers trx

665: /* Check if the current prior period transfer overlaps the previous one */
666: begin
667: select max(trx.transaction_header_id)
668: into prev_trx_id
669: from fa_transaction_headers trx
670: where trx.book_type_code = p_asset_hdr_rec.book_type_code
671: and trx.asset_id = p_asset_hdr_rec.asset_id
672: and trx.transaction_type_code = 'TRANSFER'
673: and trx.transaction_header_id < p_trans_rec.transaction_header_id

Line 676: from fa_transaction_headers trx2,

672: and trx.transaction_type_code = 'TRANSFER'
673: and trx.transaction_header_id < p_trans_rec.transaction_header_id
674: and exists
675: (select 1
676: from fa_transaction_headers trx2,
677: fa_deprn_periods dp_trx,
678: fa_deprn_periods dp_eff
679: where trx2.transaction_header_id=trx.transaction_header_id
680: and trx2.transaction_date_entered between dp_trx.calendar_period_open_date

Line 704: from fa_transaction_headers trx,

700: select dp1.period_counter
701: ,dp2.period_counter
702: into prev_from_ctr_trx
703: ,prev_from_ctr_eff
704: from fa_transaction_headers trx,
705: fa_deprn_periods dp1,
706: fa_deprn_periods dp2
707: where trx.transaction_header_id=prev_trx_id
708: and dp1.book_type_code = trx.book_type_code

Line 740: fa_transaction_headers th

736: h_trx_type
737: from fa_deprn_periods dp1,
738: fa_deprn_periods dp2,
739: fa_deprn_periods dp3,
740: fa_transaction_headers th
741: where dp1.book_type_code = p_asset_hdr_rec.book_type_code
742: and dp2.book_type_code = dp1.book_type_code
743: and dp3.book_type_code = dp1.book_type_code
744: and dp1.period_counter = from_per_ctr