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_RX_SHARED_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 501: FA_DISTRIBUTION_HISTORY DH,

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
504: CB.BOOK_TYPE_CODE = book AND
505: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 621: FA_DISTRIBUTION_HISTORY DH,

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
624: CB.BOOK_TYPE_CODE = book AND
625: CB.CATEGORY_ID = AH.CATEGORY_ID

Line 1746: fa_distribution_history dh

1742: CURSOR c_location (c_asset_id NUMBER, c_to_date DATE, c_book_type_code VARCHAR2) IS
1743: select
1744: distinct dh.location_id, dh.code_combination_id
1745: from
1746: fa_distribution_history dh
1747: where
1748: dh.asset_id = c_asset_id and
1749: dh.book_type_code = c_book_type_code and
1750: dh.date_effective <= c_to_date and