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

Line 344: FROM fa_distribution_history

340: ERROR_FOUND EXCEPTION;
341:
342: CURSOR C1 IS
343: SELECT distribution_id, units_assigned
344: FROM fa_distribution_history
345: WHERE book_type_code = h_dist_book AND
346: asset_id = h_asset_id AND /* Bug 8237945 ... Since this is called only in Period of Addition,
347: and in Period of addition we always have to take
348: Distributions at the time of additions into consideration .*/

Line 372: /* Bug 8281792 ... We need to pass h_dist_book for book_type_code, since we can have a situation where we are using Tax Book and fa_distribution_history does not contain units. Also rewritten the query using EXISTS cluase*/

368: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
369:
370: h_msg_name := 'FA_SHARED_DATA_ERR_DH';
371: /* Bug 8237945 ... Since this is called only in Period of Addition, and in Period of addition we always have to take Distributions at the time of additions into consideration . Commented dh.date_ineffective is null condition*/
372: /* Bug 8281792 ... We need to pass h_dist_book for book_type_code, since we can have a situation where we are using Tax Book and fa_distribution_history does not contain units. Also rewritten the query using EXISTS cluase*/
373: SELECT nvl(SUM(dh.units_assigned),0), COUNT(*)
374: INTO h_total_units, h_dist_count
375: FROM fa_distribution_history dh
376: WHERE dh.book_type_code = h_dist_book AND

Line 375: FROM fa_distribution_history dh

371: /* Bug 8237945 ... Since this is called only in Period of Addition, and in Period of addition we always have to take Distributions at the time of additions into consideration . Commented dh.date_ineffective is null condition*/
372: /* Bug 8281792 ... We need to pass h_dist_book for book_type_code, since we can have a situation where we are using Tax Book and fa_distribution_history does not contain units. Also rewritten the query using EXISTS cluase*/
373: SELECT nvl(SUM(dh.units_assigned),0), COUNT(*)
374: INTO h_total_units, h_dist_count
375: FROM fa_distribution_history dh
376: WHERE dh.book_type_code = h_dist_book AND
377: dh.asset_id = h_asset_id AND
378: exists( SELECT 'X' FROM FA_TRANSACTION_HEADERS th
379: WHERE asset_id = h_asset_id and