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_RETIREMENTS

Line 631: FROM FA_RETIREMENTS RET,

627: -- check whether the Asset is Fully Retired and Processed
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 RET.DATE_EFFECTIVE <= ucd

Line 641: FROM FA_RETIREMENTS_mrc_v RET,

637: and th.transaction_header_id = ret.transaction_header_id_in
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 RET.DATE_EFFECTIVE <= ucd