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

Line 422: FROM FA_DISTRIBUTION_HISTORY dh_old,

418: sum(nvl(general_fund, 0))
419: INTO
420: l_old_dist_ca,
421: l_old_dist_gf
422: FROM FA_DISTRIBUTION_HISTORY dh_old,
423: FA_DEPRN_DETAIL sumold
424: WHERE dh_old.distribution_id = sumold.distribution_id
425: AND dh_old.book_type_code = sumold.book_type_code
426: AND dh_old.asset_id = sumold.asset_id

Line 430: FROM FA_DISTRIBUTION_HISTORY dh_new

426: AND dh_old.asset_id = sumold.asset_id
427: ANd dh_old.retirement_id is not null
428: AND EXISTS
429: (SELECT 1
430: FROM FA_DISTRIBUTION_HISTORY dh_new
431: WHERE dh_new.distribution_id = p_dist_id
432: AND dh_new.asset_id = dh_old.asset_id
433: AND dh_new.transaction_header_id_in = dh_old.transaction_header_id_out
434: AND dh_new.location_id = dh_old.location_id

Line 540: FROM FA_DISTRIBUTION_HISTORY dh_old,

536: sum(nvl(general_fund, 0))
537: INTO
538: l_old_dist_ca,
539: l_old_dist_gf
540: FROM FA_DISTRIBUTION_HISTORY dh_old,
541: FA_MC_DEPRN_DETAIL sumold
542: WHERE dh_old.distribution_id = sumold.distribution_id
543: AND dh_old.book_type_code = sumold.book_type_code
544: AND dh_old.asset_id = sumold.asset_id

Line 549: FROM FA_DISTRIBUTION_HISTORY dh_new

545: ANd dh_old.retirement_id is not null
546: AND sumold.set_of_books_id = p_set_of_books_id
547: AND EXISTS
548: (SELECT 1
549: FROM FA_DISTRIBUTION_HISTORY dh_new
550: WHERE dh_new.distribution_id = p_dist_id
551: AND dh_new.asset_id = dh_old.asset_id
552: AND dh_new.transaction_header_id_in = dh_old.transaction_header_id_out
553: AND dh_new.location_id = dh_old.location_id