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.FARX_AL dependencies on FA_TRANSACTION_HEADERS

Line 632: fa_transaction_headers th

628: -- added this for bug 2681076
629: if(H_MRCSOBTYPE <> 'R') then
630: SELECT count(*) INTO h_is_retired
631: FROM FA_RETIREMENTS RET,
632: fa_transaction_headers th
633: WHERE RET.ASSET_ID = h_asset_id
634: and ret.book_type_code = h_book
635: AND trunc(RET.DATE_EFFECTIVE) <= ucd
636: AND RET.STATUS in ('PROCESSED','REINSTATE')

Line 642: fa_transaction_headers th

638: and th.transaction_type_code = 'FULL RETIREMENT';
639: else
640: SELECT count(*) INTO h_is_retired
641: FROM FA_RETIREMENTS_mrc_v RET,
642: fa_transaction_headers th
643: WHERE RET.ASSET_ID = h_asset_id
644: and ret.book_type_code = h_book
645: AND trunc(RET.DATE_EFFECTIVE) <= ucd
646: AND RET.STATUS in ('PROCESSED','REINSTATE')