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_TRANSACTION_HEADERS

Line 276: fa_transaction_headers th ,

272: l_period_counter
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

Line 304: fa_transaction_headers th ,

300: INTO p_asset_cost
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

Line 332: fa_transaction_headers th ,

328: INTO p_asset_cost
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

Line 1155: FROM fa_books_mrc_v bk, fa_transaction_headers th

1151: SELECT bk.cost,
1152: bk.period_counter_fully_retired
1153: INTO l_hist_cost_retirement,
1154: l_period_counter_fully_retired
1155: FROM fa_books_mrc_v bk, fa_transaction_headers th
1156: WHERE bk.book_type_code = p_hist_book_type_code
1157: AND bk.asset_id = p_asset_id
1158: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1159: FROM fa_books bk1

Line 1178: FROM fa_books_mrc_v bk, fa_transaction_headers th

1174: SELECT bk.cost,
1175: bk.date_placed_in_service
1176: INTO l_adj_cost_retirement,
1177: l_date_placed_in_service
1178: FROM fa_books_mrc_v bk, fa_transaction_headers th
1179: WHERE bk.book_type_code = p_adj_book_type_code
1180: AND bk.asset_id = p_asset_id
1181: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1182: FROM fa_books bk1

Line 1200: FROM fa_books bk, fa_transaction_headers th

1196: SELECT bk.cost,
1197: bk.period_counter_fully_retired
1198: INTO l_hist_cost_retirement,
1199: l_period_counter_fully_retired
1200: FROM fa_books bk, fa_transaction_headers th
1201: WHERE bk.book_type_code = p_hist_book_type_code
1202: AND bk.asset_id = p_asset_id
1203: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1204: FROM fa_books bk1

Line 1223: FROM fa_books bk, fa_transaction_headers th

1219: SELECT bk.cost,
1220: bk.date_placed_in_service
1221: INTO l_adj_cost_retirement,
1222: l_date_placed_in_service
1223: FROM fa_books bk, fa_transaction_headers th
1224: WHERE bk.book_type_code = p_adj_book_type_code
1225: AND bk.asset_id = p_asset_id
1226: AND bk.period_counter_fully_retired = (SELECT max(bk1.period_counter_fully_retired)
1227: FROM fa_books bk1

Line 1587: l_book_type_code_old fa_transaction_headers.book_type_code%type;

1583: l_remain_reval_coefficient NUMBER;
1584:
1585: -- Bug 4956193. Variables added to add logic to support multiple Adjustments in same period.
1586:
1587: l_book_type_code_old fa_transaction_headers.book_type_code%type;
1588: l_asset_id_old fa_transaction_headers.asset_id%type;
1589: l_period_counter_old fa_deprn_periods.period_counter%type;
1590: l_transaction_type_code_old fa_transaction_headers.transaction_type_code%type;
1591: l_adj_already_calculated_flag varchar2(1);

Line 1588: l_asset_id_old fa_transaction_headers.asset_id%type;

1584:
1585: -- Bug 4956193. Variables added to add logic to support multiple Adjustments in same period.
1586:
1587: l_book_type_code_old fa_transaction_headers.book_type_code%type;
1588: l_asset_id_old fa_transaction_headers.asset_id%type;
1589: l_period_counter_old fa_deprn_periods.period_counter%type;
1590: l_transaction_type_code_old fa_transaction_headers.transaction_type_code%type;
1591: l_adj_already_calculated_flag varchar2(1);
1592:

Line 1590: l_transaction_type_code_old fa_transaction_headers.transaction_type_code%type;

1586:
1587: l_book_type_code_old fa_transaction_headers.book_type_code%type;
1588: l_asset_id_old fa_transaction_headers.asset_id%type;
1589: l_period_counter_old fa_deprn_periods.period_counter%type;
1590: l_transaction_type_code_old fa_transaction_headers.transaction_type_code%type;
1591: l_adj_already_calculated_flag varchar2(1);
1592:
1593: -- Create ref cursors for bug 3101070
1594: Type report_row IS RECORD

Line 1596: asset_id fa_transaction_headers.asset_id%type,

1592:
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,

Line 1599: book_type_code fa_transaction_headers.book_type_code%type,

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,
1602: asset_type fa_asset_history.asset_type%type,
1603: units fa_asset_history.units%type

Line 1600: transaction_type_code fa_transaction_headers.transaction_type_code%type,

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,
1602: asset_type fa_asset_history.asset_type%type,
1603: units fa_asset_history.units%type
1604: );

Line 1601: transaction_header_id fa_transaction_headers.transaction_header_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,
1602: asset_type fa_asset_history.asset_type%type,
1603: units fa_asset_history.units%type
1604: );
1605:

Line 1656: FROM fa_transaction_headers th,

1652: th.transaction_type_code,
1653: th.transaction_header_id,
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

Line 1712: FROM fa_transaction_headers th,

1708: th.transaction_type_code,
1709: th.transaction_header_id,
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

Line 2042: FROM fa_transaction_headers th,

2038: AND ret.asset_id = asset_txns_rec.asset_id
2039: AND ret.transaction_header_id_in = asset_txns_rec.transaction_header_id
2040: AND ret.status = 'DELETED'
2041: AND EXISTS (SELECT th.transaction_header_id
2042: FROM fa_transaction_headers th,
2043: fa_deprn_periods dp
2044: WHERE dp.book_type_code = asset_txns_rec.book_type_code
2045: AND dp.period_counter between p_period_counter_from and p_period_counter_to
2046: AND th.book_type_code = dp.book_type_code

Line 2114: FROM fa_transaction_headers th,

2110: AND ret.asset_id = asset_txns_rec.asset_id
2111: AND ret.transaction_header_id_out = asset_txns_rec.transaction_header_id
2112: AND ret.status = 'DELETED'
2113: AND EXISTS (SELECT th.transaction_header_id
2114: FROM fa_transaction_headers th,
2115: fa_deprn_periods dp
2116: WHERE dp.book_type_code = asset_txns_rec.book_type_code
2117: AND dp.period_counter between p_period_counter_from and p_period_counter_to
2118: AND th.book_type_code = dp.book_type_code

Line 2282: -- BUG 4856193. Logic has been added to avoid looping throguh all the rows in FA_TRANSACTION_HEADERS for

2278: END IF;
2279:
2280: IF asset_txns_rec.transaction_type_code in ('ADJUSTMENT', 'CIP ADJUSTMENT') THEN
2281: -----------------------------------------------------------------------------------------------------------
2282: -- BUG 4856193. Logic has been added to avoid looping throguh all the rows in FA_TRANSACTION_HEADERS for
2283: -- multiple Adjustments. An asset can have multiple adjustments for the same period and book.
2284: -- The function get_adjust_amount already returns the summary of all the adjustments for a
2285: -- given period. So no need to summarize again for each adjustment row.
2286: -----------------------------------------------------------------------------------------------------------