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 317: l_stmt :=l_stmt||' from fa_books bk, fa_book_controls bc, fa_deprn_periods dp

313: l_stmt :=l_stmt||''''||''||''''||'||bc.DEPRN_STATUS||'||''''||''||''''||'||''''||';
314: l_stmt :=l_stmt||''''||''||''''||'||bc.MASS_REQUEST_ID||'||''''||''||''''||'||''''||';
315: l_stmt :=l_stmt||''''||''||''''||'||bc.LAST_PERIOD_COUNTER||'||''''||''||''''||'||''''||';
316: l_stmt :=l_stmt||''''||''||''''||'||dp.PERIOD_COUNTER||'||''''||''||'''';
317: l_stmt :=l_stmt||' from fa_books bk, fa_book_controls bc, fa_deprn_periods dp
318: where bc.book_type_code = bk.book_type_code
319: and dp.book_type_code = bk.book_type_code
320: and dp.period_close_date is null
321: and bk.date_ineffective is null

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

835: ||'WHERE asset_number =' ||''''||g_asset_number||''''||')';
836: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(*) FROM fa_mass_additions WHERE asset_number = '
837: ||''''||g_asset_number||'''' ||' OR add_to_asset_id = '||g_asset_id;
838: l_idx:= l_idx+ 1;
839: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS';
840: l_options_tbl(l_idx).l_gen_select := 'Y';
841: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';
842: l_idx:= l_idx+ 1;
843: l_options_tbl(l_idx).l_tbl :='FA_MC_BOOK_CONTROLS';

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

837: ||''''||g_asset_number||'''' ||' OR add_to_asset_id = '||g_asset_id;
838: l_idx:= l_idx+ 1;
839: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS';
840: l_options_tbl(l_idx).l_gen_select := 'Y';
841: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';
842: l_idx:= l_idx+ 1;
843: l_options_tbl(l_idx).l_tbl :='FA_MC_BOOK_CONTROLS';
844: l_options_tbl(l_idx).l_gen_select := 'Y';
845: l_options_tbl(l_idx).l_add_clause := ' FROM FA_MC_BOOK_CONTROLS WHERE book_type_code = '||''''||g_book||'''';

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

853: l_options_tbl(l_idx).l_lc_header := fparse_header('REPORTING_SET_OF_BOOKS_ID');
854: l_options_tbl(l_idx).l_num_cols := 1;
855: l_options_tbl(l_idx).l_add_clause := ' FROM GL_MC_REPORTING_OPTIONS WHERE fa_book_type_code = '||''''||g_book||'''';
856: l_idx:= l_idx+ 1;
857: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS_HISTORY';
858: l_options_tbl(l_idx).l_gen_select := 'Y';
859: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS_HISTORY WHERE book_type_code = '||''''||g_book||''''||' ORDER BY date_active';
860: l_idx:= l_idx+ 1;
861: l_options_tbl(l_idx).l_tbl := 'FA_CATEGORIES_B';

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

855: l_options_tbl(l_idx).l_add_clause := ' FROM GL_MC_REPORTING_OPTIONS WHERE fa_book_type_code = '||''''||g_book||'''';
856: l_idx:= l_idx+ 1;
857: l_options_tbl(l_idx).l_tbl :='FA_BOOK_CONTROLS_HISTORY';
858: l_options_tbl(l_idx).l_gen_select := 'Y';
859: l_options_tbl(l_idx).l_add_clause := ' FROM FA_BOOK_CONTROLS_HISTORY WHERE book_type_code = '||''''||g_book||''''||' ORDER BY date_active';
860: l_idx:= l_idx+ 1;
861: l_options_tbl(l_idx).l_tbl := 'FA_CATEGORIES_B';
862: l_options_tbl(l_idx).l_gen_select := 'Y';
863: l_options_tbl(l_idx).l_lcs := 'CATEGORY_ID';

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

966: l_tbl_cols(l_idx).cTbl := 'XLA_AE_LINES';l_tbl_cols(l_idx).cCol := 'CODE_COMBINATION_ID';
967: l_idx:= l_idx+ 1;
968: l_tbl_cols(l_idx).cTbl := 'FA_DISTRIBUTION_HISTORY';l_tbl_cols(l_idx).cCol := 'CODE_COMBINATION_ID';
969: l_idx:= l_idx+ 1;
970: l_tbl_cols(l_idx).cTbl := 'FA_BOOK_CONTROLS';l_tbl_cols(l_idx).cCol := 'FLEXBUILDER_DEFAULTS_CCID';
971: l_idx:= l_idx+ 1;
972: l_tbl_cols(l_idx).cTbl :='FA_DISTRIBUTION_ACCOUNTS'; l_tbl_cols(l_idx).cCol :='ASSET_COST_ACCOUNT_CCID';
973: l_idx:= l_idx+ 1;
974: l_tbl_cols(l_idx).cTbl :='FA_DISTRIBUTION_ACCOUNTS';l_tbl_cols(l_idx).cCol :='ASSET_CLEARING_ACCOUNT_CCID';

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

1091: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1092: (SELECT code_combination_id FROM fa_distribution_history
1093: WHERE asset_id = '||g_asset_id||' AND transaction_header_id_out IS NULL) ORDER BY code_combination_id';
1094: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1095: ELSIF l_tbl_cols(i).cTbl = 'FA_BOOK_CONTROLS' THEN
1096: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1097: (SELECT FLEXBUILDER_DEFAULTS_CCID FROM fa_book_controls WHERE book_type_code = '||''''||g_book||''''||')';
1098: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1099: ELSIF l_tbl_cols(i).cTbl='FA_DISTRIBUTION_ACCOUNTS' THEN

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

1093: WHERE asset_id = '||g_asset_id||' AND transaction_header_id_out IS NULL) ORDER BY code_combination_id';
1094: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1095: ELSIF l_tbl_cols(i).cTbl = 'FA_BOOK_CONTROLS' THEN
1096: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1097: (SELECT FLEXBUILDER_DEFAULTS_CCID FROM fa_book_controls WHERE book_type_code = '||''''||g_book||''''||')';
1098: l_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1099: ELSIF l_tbl_cols(i).cTbl='FA_DISTRIBUTION_ACCOUNTS' THEN
1100: l_options_tbl(l_idx).l_add_clause := ' FROM GL_CODE_COMBINATIONS WHERE code_combination_id IN
1101: (SELECT '||l_tbl_cols(i).cCol||' from fa_distribution_accounts WHERE distribution_id IN

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

1132: l_options_tbl(l_idx).l_lc_header := fparse_header('ID_FLEX_CODE');
1133: l_options_tbl(l_idx).l_leading_cols := fafsc('SEG.ID_FLEX_CODE');
1134: l_options_tbl(l_idx).l_num_cols := 2;
1135: 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,'
1136: ||' FA_BOOK_CONTROLS FABC, FND_ID_FLEX_STRUCTURES_VL STRU WHERE SEG.flex_value_set_id = SETS.flex_value_set_id(+)'
1137: ||' AND SEG.id_flex_code in (''LOC#'',''CAT#'',''KEY#'',''GL#'') AND SEG.id_flex_code = VAL.id_flex_code(+)'
1138: ||' AND SEG.id_flex_num = VAL.id_flex_num(+) AND SEG.application_column_name = VAL.application_column_name(+)'
1139: ||' AND VAL.attribute_value(+) = ''Y'' AND VAL.segment_attribute_type(+) <> ''GL_GLOBAL'' AND SEG.id_flex_num = FABC.accounting_flex_structure'
1140: ||' 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 1334: from xla_transaction_entities en, xla_events ev, fa_book_controls bc

1330: and ev.application_id = l_appid
1331: and ev.entity_id = en.entity_id
1332: union
1333: select ev.event_id, en.entity_code
1334: from xla_transaction_entities en, xla_events ev, fa_book_controls bc
1335: where bc.book_type_code = g_book
1336: and en.application_id = l_appid
1337: and en.ledger_id = g_sob_id
1338: and en.entity_code = 'DEPRECIATION'