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_BOOK_CONTROLS

Line 48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;

44: g_tmp_tbl t_asset_tbl;
45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;

Line 49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;

45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;

Line 50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;

46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;
54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;

Line 51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;

47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;
54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;
55: g_prorate_calendar FA_BOOK_CONTROLS.PRORATE_CALENDAR%TYPE;

Line 52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;

48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;
54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;
55: g_prorate_calendar FA_BOOK_CONTROLS.PRORATE_CALENDAR%TYPE;
56: g_mrc_enabled VARCHAR2(1);

Line 53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;

49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;
54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;
55: g_prorate_calendar FA_BOOK_CONTROLS.PRORATE_CALENDAR%TYPE;
56: g_mrc_enabled VARCHAR2(1);
57: g_jx_enabled VARCHAR2(1);

Line 54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;

50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;
54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;
55: g_prorate_calendar FA_BOOK_CONTROLS.PRORATE_CALENDAR%TYPE;
56: g_mrc_enabled VARCHAR2(1);
57: g_jx_enabled VARCHAR2(1);
58: g_chk_cnt BOOLEAN;

Line 55: g_prorate_calendar FA_BOOK_CONTROLS.PRORATE_CALENDAR%TYPE;

51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;
52: g_fiscal_year FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR%TYPE;
53: g_fiscal_year_name FA_BOOK_CONTROLS.FISCAL_YEAR_NAME%TYPE;
54: g_deprn_calendar FA_BOOK_CONTROLS.DEPRN_CALENDAR%TYPE;
55: g_prorate_calendar FA_BOOK_CONTROLS.PRORATE_CALENDAR%TYPE;
56: g_mrc_enabled VARCHAR2(1);
57: g_jx_enabled VARCHAR2(1);
58: g_chk_cnt BOOLEAN;
59: g_no_header VARCHAR2(1):='N';

Line 337: l_stmt :=l_stmt||' from fa_books bk, fa_book_controls bc, fa_deprn_periods dp

333: l_stmt :=l_stmt||''''||''||''''||'||bc.DEPRN_STATUS||'||''''||''||''''||'||''''||';
334: l_stmt :=l_stmt||''''||''||''''||'||bc.MASS_REQUEST_ID||'||''''||''||''''||'||''''||';
335: l_stmt :=l_stmt||''''||''||''''||'||bc.LAST_PERIOD_COUNTER||'||''''||''||''''||'||''''||';
336: l_stmt :=l_stmt||''''||''||''''||'||dp.PERIOD_COUNTER||'||''''||''||'''';
337: l_stmt :=l_stmt||' from fa_books bk, fa_book_controls bc, fa_deprn_periods dp
338: where bc.book_type_code = bk.book_type_code
339: and dp.book_type_code = bk.book_type_code
340: and dp.period_close_date is null
341: and bk.date_ineffective is null

Line 867: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS';

863: ||'WHERE asset_number =' ||''''||g_asset_number||''''||')';
864: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(*) FROM fa_mass_additions WHERE asset_number = '
865: ||''''||g_asset_number||'''' ||' OR add_to_asset_id = '||g_asset_id;
866: l_idx:= l_idx+ 1;
867: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS';
868: l_options_tbl(l_idx).l_gen_select := 'Y';
869: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';
870: l_idx:= l_idx+ 1;
871: l_options_tbl(l_idx).l_tbl :='FA_MC_BOOK_CONTROLS';

Line 869: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';

865: ||''''||g_asset_number||'''' ||' OR add_to_asset_id = '||g_asset_id;
866: l_idx:= l_idx+ 1;
867: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS';
868: l_options_tbl(l_idx).l_gen_select := 'Y';
869: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';
870: l_idx:= l_idx+ 1;
871: l_options_tbl(l_idx).l_tbl :='FA_MC_BOOK_CONTROLS';
872: l_options_tbl(l_idx).l_gen_select := 'Y';
873: l_options_tbl(l_idx).l_add_clause := ' FROM FA_MC_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';

Line 885: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS_HISTORY';

881: l_options_tbl(l_idx).l_lc_header := fparse_header('REPORTING_SET_OF_BOOKS_ID');
882: l_options_tbl(l_idx).l_num_cols := 1;
883: l_options_tbl(l_idx).l_add_clause := ' FROM GL_MC_REPORTING_OPTIONS WHERE fa_book_type_code = '||''''||g_book||'''';
884: l_idx:= l_idx+ 1;
885: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS_HISTORY';
886: l_options_tbl(l_idx).l_gen_select := 'Y';
887: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS_HISTORY WHERE book_type_code = '||''''||g_book||''''||' ORDER BY date_active';
888: l_idx:= l_idx+ 1;
889: l_options_tbl(l_idx).l_tbl := 'FA_CATEGORIES_B';

Line 887: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS_HISTORY WHERE book_type_code = '||''''||g_book||''''||' ORDER BY date_active';

883: l_options_tbl(l_idx).l_add_clause := ' FROM GL_MC_REPORTING_OPTIONS WHERE fa_book_type_code = '||''''||g_book||'''';
884: l_idx:= l_idx+ 1;
885: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS_HISTORY';
886: l_options_tbl(l_idx).l_gen_select := 'Y';
887: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS_HISTORY WHERE book_type_code = '||''''||g_book||''''||' ORDER BY date_active';
888: l_idx:= l_idx+ 1;
889: l_options_tbl(l_idx).l_tbl := 'FA_CATEGORIES_B';
890: l_options_tbl(l_idx).l_gen_select := 'Y';
891: l_options_tbl(l_idx).l_lcs := 'CATEGORY_ID';

Line 1001: l_tbl_cols(l_idx).cTbl := 'FA_BOOK_CONTROLS';l_tbl_cols(l_idx).cCol := 'FLEXBUILDER_DEFAULTS_CCID';

997: l_tbl_cols(l_idx).cTbl := 'XLA_AE_LINES';l_tbl_cols(l_idx).cCol := 'CODE_COMBINATION_ID';
998: l_idx:= l_idx+ 1;
999: l_tbl_cols(l_idx).cTbl := 'FA_DISTRIBUTION_HISTORY';l_tbl_cols(l_idx).cCol := 'CODE_COMBINATION_ID';
1000: l_idx:= l_idx+ 1;
1001: l_tbl_cols(l_idx).cTbl := 'FA_BOOK_CONTROLS';l_tbl_cols(l_idx).cCol := 'FLEXBUILDER_DEFAULTS_CCID';
1002: l_idx:= l_idx+ 1;
1003: l_tbl_cols(l_idx).cTbl :='FA_DISTRIBUTION_ACCOUNTS'; l_tbl_cols(l_idx).cCol :='ASSET_COST_ACCOUNT_CCID';
1004: l_idx:= l_idx+ 1;
1005: l_tbl_cols(l_idx).cTbl :='FA_DISTRIBUTION_ACCOUNTS';l_tbl_cols(l_idx).cCol :='ASSET_CLEARING_ACCOUNT_CCID';

Line 1126: ELSIF l_tbl_cols(i).cTbl = 'FA_BOOK_CONTROLS' THEN

1122: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1123: (SELECT code_combination_id FROM fa_distribution_history
1124: WHERE asset_id = '||g_asset_id||' AND transaction_header_id_out IS NULL) ORDER BY code_combination_id';
1125: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1126: ELSIF l_tbl_cols(i).cTbl = 'FA_BOOK_CONTROLS' THEN
1127: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1128: (SELECT FLEXBUILDER_DEFAULTS_CCID FROM fa_book_controls WHERE book_type_code = '||''''||g_book||''''||')';
1129: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1130: ELSIF l_tbl_cols(i).cTbl='FA_DISTRIBUTION_ACCOUNTS' THEN

Line 1128: (SELECT FLEXBUILDER_DEFAULTS_CCID FROM fa_book_controls WHERE book_type_code = '||''''||g_book||''''||')';

1124: WHERE asset_id = '||g_asset_id||' AND transaction_header_id_out IS NULL) ORDER BY code_combination_id';
1125: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1126: ELSIF l_tbl_cols(i).cTbl = 'FA_BOOK_CONTROLS' THEN
1127: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1128: (SELECT FLEXBUILDER_DEFAULTS_CCID FROM fa_book_controls WHERE book_type_code = '||''''||g_book||''''||')';
1129: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1130: ELSIF l_tbl_cols(i).cTbl='FA_DISTRIBUTION_ACCOUNTS' THEN
1131: l_options_tbl(l_idx).l_lc_header := l_options_tbl(l_idx).l_lc_header||fparse_header('DISTRIBUTION_ID');
1132: l_options_tbl(l_idx).l_leading_cols := l_options_tbl(l_idx).l_leading_cols||fafsc('DISTRIBUTION_ID');

Line 1169: ||' FA_BOOK_CONTROLS FABC, FND_ID_FLEX_STRUCTURES_VL STRU WHERE SEG.flex_value_set_id = SETS.flex_value_set_id(+)'

1165: l_options_tbl(l_idx).l_lc_header := fparse_header('ID_FLEX_CODE');
1166: l_options_tbl(l_idx).l_leading_cols := fafsc('SEG.ID_FLEX_CODE');
1167: l_options_tbl(l_idx).l_num_cols := 2;
1168: l_options_tbl(l_idx).l_add_clause := ' FROM FND_ID_FLEX_SEGMENTS_VL SEG, FND_FLEX_VALUE_SETS SETS, FND_SEGMENT_ATTRIBUTE_VALUES VAL,'
1169: ||' FA_BOOK_CONTROLS FABC, FND_ID_FLEX_STRUCTURES_VL STRU WHERE SEG.flex_value_set_id = SETS.flex_value_set_id(+)'
1170: ||' AND SEG.id_flex_code in (''LOC#'',''CAT#'',''KEY#'',''GL#'') AND SEG.id_flex_code = VAL.id_flex_code(+)'
1171: ||' AND SEG.id_flex_num = VAL.id_flex_num(+) AND SEG.application_column_name = VAL.application_column_name(+)'
1172: ||' AND VAL.attribute_value(+) = ''Y'' AND VAL.segment_attribute_type(+) <> ''GL_GLOBAL'' AND SEG.id_flex_num = FABC.accounting_flex_structure'
1173: ||' AND FABC.book_type_code = '||'''' || g_book || ''''||' AND STRU.id_flex_code = SEG.id_flex_code AND STRU.id_flex_num = SEG.id_flex_num'

Line 1403: from xla_transaction_entities en, xla_events ev, fa_book_controls bc

1399: and ev.application_id in ('||l_appid||',140)
1400: and ev.entity_id = en.entity_id
1401: union
1402: select ev.event_id
1403: from xla_transaction_entities en, xla_events ev, fa_book_controls bc
1404: where bc.book_type_code = '||'''' || g_book || ''''||
1405: ' and en.application_id in ('||l_appid||',140)
1406: and en.ledger_id = '||g_sob_id||
1407: ' and en.entity_code in (''MANUAL'', ''DEPRECIATION'',''DEFERRED_DEPRECIATION'')