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_ASSET_TRACE_PKG dependencies on FA_TRANSACTION_HEADERS

Line 426: from fa_transaction_headers

422:
423: BEGIN
424: select count(1)
425: into l_check_reval
426: from fa_transaction_headers
427: where transaction_type_code = 'REVALUATION'
428: and asset_id = g_asset_id
429: and book_type_code = g_book;
430:

Line 439: l_options_tbl(l_idx).l_tbl := 'FA_TRANSACTION_HEADERS';

435: l_idx:= l_idx+ 1;
436: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';
437: l_options_tbl(l_idx).l_gen_select := 'Y';
438: l_idx:= l_idx+ 1;
439: l_options_tbl(l_idx).l_tbl := 'FA_TRANSACTION_HEADERS';
440: l_options_tbl(l_idx).l_gen_select := 'Y';
441: l_options_tbl(l_idx).l_lcs := 'BOOK_TYPE_CODE,TRANSACTION_HEADER_ID';
442: l_options_tbl(l_idx).l_leading_cols := fafsc('BOOK_TYPE_CODE')||fafsc('TRANSACTION_HEADER_ID');
443: l_options_tbl(l_idx).l_order_by := 'TRANSACTION_HEADER_ID';

Line 449: l_options_tbl(l_idx).l_add_clause := ' FROM FA_TRANSACTION_HEADERS Where asset_id = '||g_asset_id

445: l_options_tbl(l_idx).l_num_cols := 2;
446: l_options_tbl(l_idx).l_col_order := 'TRANSACTION_TYPE_CODE,TRANSACTION_DATE_ENTERED,DATE_EFFECTIVE,AMORTIZATION_START_DATE'
447: ||',CALLING_INTERFACE,MASS_REFERENCE_ID,TRANSACTION_NAME,TRANSACTION_SUBTYPE,TRANSACTION_KEY,SOURCE_TRANSACTION_HEADER_ID'
448: ||',MASS_TRANSACTION_ID,INVOICE_TRANSACTION_ID';
449: l_options_tbl(l_idx).l_add_clause := ' FROM FA_TRANSACTION_HEADERS Where asset_id = '||g_asset_id
450: ||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||') ';
451: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(1) FROM FA_TRANSACTION_HEADERS'
452: ||' WHERE asset_id = '||g_asset_id||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||')';
453: l_idx:= l_idx+ 1;

Line 451: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(1) FROM FA_TRANSACTION_HEADERS'

447: ||',CALLING_INTERFACE,MASS_REFERENCE_ID,TRANSACTION_NAME,TRANSACTION_SUBTYPE,TRANSACTION_KEY,SOURCE_TRANSACTION_HEADER_ID'
448: ||',MASS_TRANSACTION_ID,INVOICE_TRANSACTION_ID';
449: l_options_tbl(l_idx).l_add_clause := ' FROM FA_TRANSACTION_HEADERS Where asset_id = '||g_asset_id
450: ||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||') ';
451: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(1) FROM FA_TRANSACTION_HEADERS'
452: ||' WHERE asset_id = '||g_asset_id||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||')';
453: l_idx:= l_idx+ 1;
454: l_options_tbl(l_idx).l_tbl := 'FA_ASSET_HISTORY';
455: l_options_tbl(l_idx).l_gen_select := 'Y';

Line 499: ||' and mass_reval_id in (select mass_transaction_id from fa_transaction_headers where transaction_type_code = ''REVALUATION'''

495: l_options_tbl(l_idx).l_lcs := 'MASS_REVAL_ID';
496: l_options_tbl(l_idx).l_leading_cols := fafsc('MASS_REVAL_ID');
497: l_options_tbl(l_idx).l_lc_header := fparse_header('MASS_REVAL_ID');
498: l_options_tbl(l_idx).l_add_clause := ' FROM FA_MASS_REVALUATIONS where book_type_code = '||''''||g_book||''''
499: ||' and mass_reval_id in (select mass_transaction_id from fa_transaction_headers where transaction_type_code = ''REVALUATION'''
500: ||' and asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||')';
501: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
502: l_idx:= l_idx+ 1;
503: l_options_tbl(l_idx).l_tbl := 'FA_MASS_REVALUATIONS_RULES';

Line 509: ||' and mass_reval_id in (select mass_transaction_id from fa_transaction_headers where transaction_type_code = ''REVALUATION'''

505: l_options_tbl(l_idx).l_lcs := 'MASS_REVAL_ID';
506: l_options_tbl(l_idx).l_leading_cols := fafsc('MASS_REVAL_ID');
507: l_options_tbl(l_idx).l_lc_header := fparse_header('MASS_REVAL_ID');
508: l_options_tbl(l_idx).l_add_clause := ' FROM FA_MASS_REVALUATIONS_RULES where asset_id = '||g_asset_id
509: ||' and mass_reval_id in (select mass_transaction_id from fa_transaction_headers where transaction_type_code = ''REVALUATION'''
510: ||' and asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||')';
511: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
512: end if;
513: l_idx:= l_idx+ 1;

Line 1312: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev

1308: l_calling_fn varchar2(80) := 'fa_asset_trace_pkg.get_event_list';
1309:
1310: Cursor get_events IS
1311: select ev.event_id, en.entity_code
1312: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1313: where th.book_type_code = g_book
1314: and th.asset_id = g_asset_id
1315: and en.application_id = l_appid
1316: and en.ledger_id = g_sob_id

Line 1323: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev

1319: and ev.application_id = l_appid
1320: and ev.entity_id = en.entity_id
1321: union
1322: select ev.event_id, en.entity_code
1323: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1324: where th.book_type_code = g_book
1325: and th.asset_id = g_asset_id
1326: and en.application_id = l_appid
1327: and en.ledger_id = g_sob_id