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

Line 775: FROM FA_DISTRIBUTION_HISTORY

771: CURSOR C1 IS
772: SELECT DISTRIBUTION_ID,
773: CODE_COMBINATION_ID,
774: UNITS_ASSIGNED
775: FROM FA_DISTRIBUTION_HISTORY
776: WHERE ASSET_ID = h_asset_id
777: AND BOOK_TYPE_CODE = h_dist_book
778: AND (
779: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

Line 862: and distribution_id in (select distribution_id from fa_distribution_history where asset_id = adj_ptr.asset_id and book_type_code = adj_ptr.book_type_code and date_ineffective is null);

858: where asset_id = adj_ptr.asset_id
859: and book_type_code = adj_ptr.book_type_code
860: and adjustment_type = 'COST'
861: and set_of_books_id = h_set_of_books_id
862: and distribution_id in (select distribution_id from fa_distribution_history where asset_id = adj_ptr.asset_id and book_type_code = adj_ptr.book_type_code and date_ineffective is null);
863:
864: select PERIOD_COUNTER_FULLY_RESERVED,cost,group_asset_id
865: into h_pd_fully_rsv,h_books_cost,h_group_asset_id
866: from fa_mc_books

Line 880: and distribution_id in (select distribution_id from fa_distribution_history where asset_id = adj_ptr.asset_id and book_type_code = adj_ptr.book_type_code and date_ineffective is null);

876: from fa_adjustments
877: where asset_id = adj_ptr.asset_id
878: and book_type_code = adj_ptr.book_type_code
879: and adjustment_type = 'COST'
880: and distribution_id in (select distribution_id from fa_distribution_history where asset_id = adj_ptr.asset_id and book_type_code = adj_ptr.book_type_code and date_ineffective is null);
881:
882: select PERIOD_COUNTER_FULLY_RESERVED, cost, group_asset_id
883: into h_pd_fully_rsv,h_books_cost,h_group_asset_id
884: from fa_books

Line 940: FROM FA_DISTRIBUTION_HISTORY

936: if (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL) then
937:
938: SELECT COUNT(*)
939: INTO h_distribution_lines
940: FROM FA_DISTRIBUTION_HISTORY
941: WHERE ASSET_ID=h_asset_id
942: AND book_type_code=h_dist_book
943: AND DATE_INEFFECTIVE IS NULL;
944:

Line 950: FROM FA_DISTRIBUTION_HISTORY

946:
947: -- the number of the newly created rows only
948: SELECT COUNT(*)
949: INTO h_distribution_lines
950: FROM FA_DISTRIBUTION_HISTORY
951: WHERE ASSET_ID=h_asset_id
952: AND book_type_code=h_dist_book
953: AND transaction_header_id_in=adj_ptr.selection_thid;
954:

Line 1340: FROM FA_DISTRIBUTION_HISTORY

1336: SELECT distribution_id,
1337: code_combination_id,
1338: units_assigned,
1339: transaction_header_id_in
1340: FROM FA_DISTRIBUTION_HISTORY
1341: WHERE asset_id = h_asset_id
1342: AND book_type_code=h_dist_book
1343: AND (
1344: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL

Line 1764: FROM FA_DISTRIBUTION_HISTORY

1760: CURSOR C1 IS
1761: SELECT DISTRIBUTION_ID,
1762: CODE_COMBINATION_ID,
1763: TRANSACTION_UNITS
1764: FROM FA_DISTRIBUTION_HISTORY
1765: WHERE ASSET_ID = h_asset_id
1766: AND BOOK_TYPE_CODE = h_dist_book
1767: AND RETIREMENT_ID = h_ret_id
1768: ORDER BY DISTRIBUTION_ID;

Line 1826: FROM FA_DISTRIBUTION_HISTORY

1822: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1823: h_mesg_name:='FA_INS_ADJ_CNT_ACTIVE';
1824: SELECT COUNT(*)
1825: INTO h_distribution_lines
1826: FROM FA_DISTRIBUTION_HISTORY
1827: WHERE ASSET_ID = h_asset_id
1828: AND book_type_code = h_dist_book
1829: AND RETIREMENT_ID = h_ret_id;
1830: