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 446: from fa_transaction_headers

442:
443: BEGIN
444: select count(1)
445: into l_check_reval
446: from fa_transaction_headers
447: where transaction_type_code = 'REVALUATION'
448: and asset_id = g_asset_id
449: and book_type_code = g_book;
450:

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

455: l_idx:= l_idx+ 1;
456: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';
457: l_options_tbl(l_idx).l_gen_select := 'Y';
458: l_idx:= l_idx+ 1;
459: l_options_tbl(l_idx).l_tbl := 'FA_TRANSACTION_HEADERS';
460: l_options_tbl(l_idx).l_gen_select := 'Y';
461: l_options_tbl(l_idx).l_lcs := 'BOOK_TYPE_CODE,TRANSACTION_HEADER_ID';
462: l_options_tbl(l_idx).l_leading_cols := fafsc('BOOK_TYPE_CODE')||fafsc('TRANSACTION_HEADER_ID');
463: l_options_tbl(l_idx).l_order_by := 'TRANSACTION_HEADER_ID';

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

465: l_options_tbl(l_idx).l_num_cols := 2;
466: l_options_tbl(l_idx).l_col_order := 'TRANSACTION_TYPE_CODE,TRANSACTION_DATE_ENTERED,DATE_EFFECTIVE,AMORTIZATION_START_DATE'
467: ||',CALLING_INTERFACE,MASS_REFERENCE_ID,TRANSACTION_NAME,TRANSACTION_SUBTYPE,TRANSACTION_KEY,SOURCE_TRANSACTION_HEADER_ID'
468: ||',MASS_TRANSACTION_ID,INVOICE_TRANSACTION_ID';
469: l_options_tbl(l_idx).l_add_clause := ' FROM FA_TRANSACTION_HEADERS Where asset_id = '||g_asset_id
470: ||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||') ';
471: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(1) FROM FA_TRANSACTION_HEADERS'
472: ||' WHERE asset_id = '||g_asset_id||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||')';
473: l_idx:= l_idx+ 1;

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

467: ||',CALLING_INTERFACE,MASS_REFERENCE_ID,TRANSACTION_NAME,TRANSACTION_SUBTYPE,TRANSACTION_KEY,SOURCE_TRANSACTION_HEADER_ID'
468: ||',MASS_TRANSACTION_ID,INVOICE_TRANSACTION_ID';
469: l_options_tbl(l_idx).l_add_clause := ' FROM FA_TRANSACTION_HEADERS Where asset_id = '||g_asset_id
470: ||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||') ';
471: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(1) FROM FA_TRANSACTION_HEADERS'
472: ||' WHERE asset_id = '||g_asset_id||' and book_type_code in ('||''''||g_source_book||''''||','||''''||g_book||''''||')';
473: l_idx:= l_idx+ 1;
474: l_options_tbl(l_idx).l_tbl := 'FA_ASSET_HISTORY';
475: l_options_tbl(l_idx).l_gen_select := 'Y';

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

515: l_options_tbl(l_idx).l_lcs := 'MASS_REVAL_ID';
516: l_options_tbl(l_idx).l_leading_cols := fafsc('MASS_REVAL_ID');
517: l_options_tbl(l_idx).l_lc_header := fparse_header('MASS_REVAL_ID');
518: l_options_tbl(l_idx).l_add_clause := ' FROM FA_MASS_REVALUATIONS where book_type_code = '||''''||g_book||''''
519: ||' and mass_reval_id in (select mass_transaction_id from fa_transaction_headers where transaction_type_code = ''REVALUATION'''
520: ||' and asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||')';
521: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
522: l_idx:= l_idx+ 1;
523: l_options_tbl(l_idx).l_tbl := 'FA_MASS_REVALUATIONS_RULES';

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

525: l_options_tbl(l_idx).l_lcs := 'MASS_REVAL_ID';
526: l_options_tbl(l_idx).l_leading_cols := fafsc('MASS_REVAL_ID');
527: l_options_tbl(l_idx).l_lc_header := fparse_header('MASS_REVAL_ID');
528: l_options_tbl(l_idx).l_add_clause := ' FROM FA_MASS_REVALUATIONS_RULES where asset_id = '||g_asset_id
529: ||' and mass_reval_id in (select mass_transaction_id from fa_transaction_headers where transaction_type_code = ''REVALUATION'''
530: ||' and asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||')';
531: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
532: end if;
533: l_idx:= l_idx+ 1;

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

1349:
1350: /* 1- trx 2/3- dist-related 4- inter-asset 5- deprn */
1351:
1352: l_event_list := l_event_list|| 'select ev.event_id
1353: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1354: where th.book_type_code = '||'''' || g_book || ''''||
1355: ' and th.asset_id = '||g_asset_id||
1356: ' and en.application_id in ('||l_appid||',140)
1357: and en.ledger_id = '||g_sob_id||

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

1361: ' and ev.application_id in ('||l_appid||',140)
1362: and ev.entity_id = en.entity_id
1363: union
1364: select ev.event_id
1365: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1366: where th.book_type_code = '||'''' || g_source_book || ''''||
1367: ' and th.asset_id = '||g_asset_id||
1368: ' and th.transaction_type_code in (''REINSTATEMENT'')
1369: and en.application_id in ('||l_appid||',140)

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

1375: ' and ev.application_id in ('||l_appid||',140)
1376: and ev.entity_id = en.entity_id
1377: union
1378: select ev.event_id
1379: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1380: where th.book_type_code = '||'''' || g_source_book || ''''||
1381: ' and th.asset_id = '||g_asset_id||
1382: ' and th.transaction_type_code in (''UNIT ADJUSTMENT'',''TRANSFER OUT'',''TRANSFER'',''RECLASS'')
1383: and en.application_id in ('||l_appid||',140)

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

1388: ' and ev.application_id in ('||l_appid||',140)
1389: and ev.entity_id = en.entity_id
1390: union
1391: select ev.event_id
1392: from fa_transaction_headers th, xla_transaction_entities en, xla_events ev
1393: where th.book_type_code = '||'''' || g_book || ''''||
1394: ' and th.asset_id = '||g_asset_id||
1395: ' and en.application_id in ('||l_appid||',140)
1396: and en.ledger_id = '||g_sob_id||