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.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_ASSET_HISTORY

Line 277: fa_asset_history ah ,

273: FROM fa_books fb ,
274: fa_calendar_periods cp ,
275: fa_deprn_periods dp ,
276: fa_transaction_headers th ,
277: fa_asset_history ah ,
278: fa_additions ad ,
279: fa_book_controls bc
280: WHERE ah.asset_id = ad.asset_id
281: AND fb.book_type_code = bc.book_type_code

Line 305: fa_asset_history ah ,

301: FROM fa_books_mrc_v fb ,
302: fa_calendar_periods cp ,
303: fa_deprn_periods_mrc_v dp ,
304: fa_transaction_headers th ,
305: fa_asset_history ah ,
306: fa_additions ad ,
307: fa_book_controls_mrc_v bc
308: WHERE ah.asset_id = ad.asset_id
309: AND fb.book_type_code = bc.book_type_code

Line 333: fa_asset_history ah ,

329: FROM fa_books fb ,
330: fa_calendar_periods cp ,
331: fa_deprn_periods dp ,
332: fa_transaction_headers th ,
333: fa_asset_history ah ,
334: fa_additions ad ,
335: fa_book_controls bc
336: WHERE ah.asset_id = ad.asset_id
337: AND fb.book_type_code = bc.book_type_code

Line 961: FROM fa_asset_history ah,

957: BEGIN
958: BEGIN
959: SELECT ah.category_id
960: INTO l_category_id
961: FROM fa_asset_history ah,
962: fa_deprn_periods dp
963: WHERE ah.asset_id = p_asset_id
964: AND dp.book_type_code = p_adj_book_type_code
965: AND dp.period_counter = p_period_counter_from

Line 1390: FROM fa_asset_history ah

1386: SELECT ah.category_id,
1387: ah.asset_type
1388: INTO p_old_category_id,
1389: l_asset_type
1390: FROM fa_asset_history ah
1391: WHERE ah.asset_id = p_asset_id
1392: AND ah.transaction_header_id_out = p_transaction_header_id;
1393: EXCEPTION WHEN OTHERS THEN
1394: p_old_category_id := 0;

Line 1597: category_id fa_asset_history.category_id%type,

1593: -- Create ref cursors for bug 3101070
1594: Type report_row IS RECORD
1595: (
1596: asset_id fa_transaction_headers.asset_id%type,
1597: category_id fa_asset_history.category_id%type,
1598: period_counter fa_deprn_periods.period_counter%type,
1599: book_type_code fa_transaction_headers.book_type_code%type,
1600: transaction_type_code fa_transaction_headers.transaction_type_code%type,
1601: transaction_header_id fa_transaction_headers.transaction_header_id%type,

Line 1602: asset_type fa_asset_history.asset_type%type,

1598: period_counter fa_deprn_periods.period_counter%type,
1599: book_type_code fa_transaction_headers.book_type_code%type,
1600: transaction_type_code fa_transaction_headers.transaction_type_code%type,
1601: transaction_header_id fa_transaction_headers.transaction_header_id%type,
1602: asset_type fa_asset_history.asset_type%type,
1603: units fa_asset_history.units%type
1604: );
1605:
1606: TYPE report_ref_cur is REF CURSOR;

Line 1603: units fa_asset_history.units%type

1599: book_type_code fa_transaction_headers.book_type_code%type,
1600: transaction_type_code fa_transaction_headers.transaction_type_code%type,
1601: transaction_header_id fa_transaction_headers.transaction_header_id%type,
1602: asset_type fa_asset_history.asset_type%type,
1603: units fa_asset_history.units%type
1604: );
1605:
1606: TYPE report_ref_cur is REF CURSOR;
1607: fetch_txns_for_rpt_period report_ref_cur;

Line 1658: fa_asset_history ah

1654: ah.asset_type,
1655: nvl (ah.units,0)
1656: FROM fa_transaction_headers th,
1657: fa_deprn_periods_mrc_v dp,
1658: fa_asset_history ah
1659: WHERE dp.book_type_code = p_corp_book
1660: AND dp.period_counter between p_period_counter_from and p_period_counter_to
1661: AND th.book_type_code = dp.book_type_code
1662: AND dp.period_open_date <= th.date_effective

Line 1694: fa_asset_history ah

1690: ah.asset_type,
1691: nvl (ah.units,0)
1692: FROM fa_books bk,
1693: fa_deprn_periods_mrc_v dp,
1694: fa_asset_history ah
1695: WHERE dp.book_type_code = p_corp_book
1696: AND bk.book_type_code = dp.book_type_code
1697: AND bk.asset_id = ah.asset_id
1698: AND dp.period_counter = p_period_counter_from

Line 1714: fa_asset_history ah

1710: ah.asset_type,
1711: nvl (ah.units,0)
1712: FROM fa_transaction_headers th,
1713: fa_deprn_periods dp,
1714: fa_asset_history ah
1715: WHERE dp.book_type_code = p_corp_book
1716: AND dp.period_counter between p_period_counter_from and p_period_counter_to
1717: AND th.book_type_code = dp.book_type_code
1718: AND dp.period_open_date <= th.date_effective

Line 1750: fa_asset_history ah

1746: ah.asset_type,
1747: nvl (ah.units,0)
1748: FROM fa_books bk,
1749: fa_deprn_periods dp,
1750: fa_asset_history ah
1751: WHERE dp.book_type_code = p_corp_book
1752: AND bk.book_type_code = dp.book_type_code
1753: AND bk.asset_id = ah.asset_id
1754: AND dp.period_counter = p_period_counter_from

Line 1928: FROM fa_asset_history ah,

1924: /* Find the category at the end of the last reporting period */
1925: BEGIN
1926: SELECT ah.category_id
1927: INTO l_current_category_id
1928: FROM fa_asset_history ah,
1929: fa_deprn_periods dp
1930: WHERE ah.asset_id = asset_txns_rec.asset_id
1931: AND dp.book_type_code = p_corp_book
1932: AND dp.period_close_date between ah.date_effective and nvl(ah.date_ineffective,dp.period_close_date)