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_BOOKS

Line 216: FROM fa_books

212: g_asset_id := l_asset_id;
213:
214: SELECT count(*)
215: INTO l_count
216: FROM fa_books
217: WHERE asset_id = g_asset_id
218: AND book_type_code = g_book;
219:
220: if l_count = 0 then

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 534: l_options_tbl(l_idx).l_tbl := 'FA_BOOKS';

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;
534: l_options_tbl(l_idx).l_tbl := 'FA_BOOKS';
535: l_options_tbl(l_idx).l_gen_select := 'Y';
536: l_options_tbl(l_idx).l_lcs := 'TRANSACTION_HEADER_ID_IN';
537: l_options_tbl(l_idx).l_leading_cols := fafsc('TRANSACTION_HEADER_ID_IN');
538: l_options_tbl(l_idx).l_order_by := 'TRANSACTION_HEADER_ID_IN';

Line 733: l_options_tbl(l_idx).l_tbl := 'FA_BOOKS_SUMMARY';

729: l_options_tbl(l_idx).l_cnt_stmt := 'SELECT count(1) FROM FA_TRX_REFERENCES WHERE book_type_code = '||''''||g_book||''''
730: ||' and (member_asset_id = '||g_asset_id||' or src_asset_id = '||g_asset_id||' or dest_asset_id = '||g_asset_id||')';
731: l_options_tbl(l_idx).l_cnt_stmt := 'Select count(1) '||l_options_tbl(l_idx).l_add_clause;
732: l_idx:= l_idx+ 1;
733: l_options_tbl(l_idx).l_tbl := 'FA_BOOKS_SUMMARY';
734: l_options_tbl(l_idx).l_gen_select := 'Y';
735: l_options_tbl(l_idx).l_lcs := 'FISCAL_YEAR,PERIOD_NUM,PERIOD_COUNTER';
736: l_options_tbl(l_idx).l_leading_cols := fafsc('FISCAL_YEAR')||fafsc('PERIOD_NUM')||fafsc('PERIOD_COUNTER');
737: l_options_tbl(l_idx).l_order_by := 'PERIOD_COUNTER';

Line 1238: ' AND (CO.PRORATE_CONVENTION_CODE IN (select distinct PRORATE_CONVENTION_CODE from fa_books '||

1234: l_options_tbl(l_idx).l_fullcol_list := 'Y';
1235: l_options_tbl(l_idx).l_add_clause := ' FROM FA_CONVENTIONS CO, FA_CONVENTION_TYPES CT, FA_FISCAL_YEAR FY '
1236: ||'WHERE FY.FISCAL_YEAR BETWEEN '||(g_fiscal_year-1)||' AND '||g_fiscal_year||
1237: ' AND FY.FISCAL_YEAR_NAME = '||'''' ||g_fiscal_year_name|| ''''||
1238: ' AND (CO.PRORATE_CONVENTION_CODE IN (select distinct PRORATE_CONVENTION_CODE from fa_books '||
1239: ' where asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||') '||
1240: ' OR CO.PRORATE_CONVENTION_CODE in (select distinct RETIREMENT_PRORATE_CONVENTION from fa_retirements '||
1241: ' where asset_id = '||g_asset_id|| ' and book_type_code = '||'''' || g_book || ''''||')) '||
1242: ' AND CO.START_DATE BETWEEN FY.START_DATE AND FY.END_DATE '||

Line 1250: ' where BR.BONUS_RULE=BRL.BONUS_RULE and BR.BONUS_RULE IN (select distinct BONUS_RULE from fa_books '||

1246: l_options_tbl(l_idx).l_gen_select := 'N';
1247: l_options_tbl(l_idx).l_col_order := 'br.Bonus_Rule,br.Start_Year,br.End_Year,br.Bonus_Rate * 100,brl.ONE_TIME_FLAG';
1248: l_options_tbl(l_idx).l_fullcol_list := 'Y';
1249: l_options_tbl(l_idx).l_add_clause := ' from FA_BONUS_RATES br, FA_BONUS_RULES brl '||
1250: ' where BR.BONUS_RULE=BRL.BONUS_RULE and BR.BONUS_RULE IN (select distinct BONUS_RULE from fa_books '||
1251: ' where asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||') '||
1252: ' order by BR.Bonus_Rule,BR.Start_Year';
1253: l_options_tbl(l_idx).l_cnt_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1254: l_idx:= l_idx+ 1;

Line 1262: ' from fa_books where asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||') '

1258: ||'CL.Year_Of_Life,CL.Limit';
1259: l_options_tbl(l_idx).l_fullcol_list := 'Y';
1260: l_options_tbl(l_idx).l_add_clause := ' FROM FA_CEILINGS CL, FA_CEILING_TYPES CT '
1261: ||' WHERE cl.ceiling_name = ct.ceiling_name AND (cl.ceiling_name in (select distinct Ceiling_Name '||
1262: ' from fa_books where asset_id = '||g_asset_id||' and book_type_code = '||'''' || g_book || ''''||') '
1263: ||' OR cl.ceiling_name in (select Ceiling_Name from fa_category_book_defaults '||
1264: ' where category_id in (SELECT DISTINCT ah.category_id FROM fa_asset_history ah '||
1265: ' WHERE ah.asset_id = '||g_asset_id|| ') and book_type_code = '||'''' || g_book || ''''||'))';
1266: l_options_tbl(l_idx).l_cnt_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;

Line 1273: l_options_tbl(l_idx).l_add_clause := ' from fa_methods mt, fa_rates rt, fa_books bk, fa_calendar_periods cp'

1269: l_options_tbl(l_idx).l_gen_select := 'N';
1270: l_options_tbl(l_idx).l_col_order := 'mt.method_code,mt.name,mt.life_in_months,mt.stl_method_flag,'
1271: ||'mt.depreciate_lastyear_flag,rt.year,rt.period_placed_in_service,rt.rate';
1272: l_options_tbl(l_idx).l_fullcol_list := 'Y';
1273: l_options_tbl(l_idx).l_add_clause := ' from fa_methods mt, fa_rates rt, fa_books bk, fa_calendar_periods cp'
1274: ||' where mt.method_id = rt.method_id and mt.method_code = bk.deprn_method_code and mt.life_in_months = bk.life_in_months'
1275: ||' and bk.asset_id = '||g_asset_id||' and bk.book_type_code = '||'''' || g_book || ''''||' and cp.calendar_type = '
1276: ||'''' ||g_prorate_calendar|| ''''||' and bk.prorate_date between cp.start_date and cp.end_date'
1277: ||' and rt.PERIOD_PLACED_IN_SERVICE = cp.period_num order by mt.method_code, mt.life_in_months, rt.year';

Line 1288: ||' IN (select DEPRN_METHOD_CODE||to_char(nvl(LIFE_IN_MONTHS,99999)) from fa_books'

1284: l_options_tbl(l_idx).l_lc_header := fparse_header('METHOD_ID');
1285: l_options_tbl(l_idx).l_num_cols := 1;
1286: l_options_tbl(l_idx).l_col_order := 'METHOD_CODE,NAME,LIFE_IN_MONTHS';
1287: l_options_tbl(l_idx).l_add_clause := ' FROM fa_methods WHERE METHOD_CODE||to_char(nvl(LIFE_IN_MONTHS,99999))'
1288: ||' IN (select DEPRN_METHOD_CODE||to_char(nvl(LIFE_IN_MONTHS,99999)) from fa_books'
1289: ||' where book_type_code = '||'''' || g_book || ''''||' and asset_id = '||g_asset_id||')';
1290: l_idx:= l_idx+ 1;
1291: l_options_tbl(l_idx).l_tbl :='FA_DEPRN_BASIS_RULES';
1292: l_options_tbl(l_idx).l_add_clause := ' FROM fa_deprn_basis_rules WHERE deprn_basis_rule_id IN (SELECT deprn_basis_rule_id'

Line 1294: ||'(select DEPRN_METHOD_CODE||to_char(nvl(LIFE_IN_MONTHS,99999)) from fa_books where book_type_code = '

1290: l_idx:= l_idx+ 1;
1291: l_options_tbl(l_idx).l_tbl :='FA_DEPRN_BASIS_RULES';
1292: l_options_tbl(l_idx).l_add_clause := ' FROM fa_deprn_basis_rules WHERE deprn_basis_rule_id IN (SELECT deprn_basis_rule_id'
1293: ||' FROM fa_methods WHERE METHOD_CODE||to_char(nvl(LIFE_IN_MONTHS,99999)) IN '
1294: ||'(select DEPRN_METHOD_CODE||to_char(nvl(LIFE_IN_MONTHS,99999)) from fa_books where book_type_code = '
1295: ||'''' || g_book || ''''||' and asset_id = '||g_asset_id||'))';
1296: l_options_tbl(l_idx).l_cnt_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1297: l_idx:= l_idx+ 1;
1298: l_options_tbl(l_idx).l_tbl :='FA_FLAT_RATES';

Line 1300: ||'(SELECT to_char(mt.method_id) || to_char(basic_rate) FROM FA_METHODS mt, fa_books bk '

1296: l_options_tbl(l_idx).l_cnt_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1297: l_idx:= l_idx+ 1;
1298: l_options_tbl(l_idx).l_tbl :='FA_FLAT_RATES';
1299: l_options_tbl(l_idx).l_add_clause := ' From fa_flat_rates Where to_char(method_id) || to_char(basic_rate) in '
1300: ||'(SELECT to_char(mt.method_id) || to_char(basic_rate) FROM FA_METHODS mt, fa_books bk '
1301: ||'where mt.method_code = bk.deprn_method_code and nvl(mt.life_in_months,0) = nvl(bk.life_in_months,0) '
1302: ||'and bk.book_type_code = '||'''' || g_book || ''''||' and bk.asset_id = '||g_asset_id||')';
1303: l_options_tbl(l_idx).l_cnt_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1304: l_idx:= l_idx+ 1;

Line 1316: ||'FROM FA_METHODS mt, fa_books bk where mt.method_code = bk.deprn_method_code '

1312: ||' and fiscal_year BETWEEN '||(g_fiscal_year-1)||' AND '||g_fiscal_year||' Order by FISCAL_YEAR, START_DATE';
1313: l_idx:= l_idx+ 1;
1314: l_options_tbl(l_idx).l_tbl :='FA_FORMULAS';
1315: l_options_tbl(l_idx).l_add_clause := ' From fa_formulas Where method_id in (SELECT mt.method_id '
1316: ||'FROM FA_METHODS mt, fa_books bk where mt.method_code = bk.deprn_method_code '
1317: ||'and nvl(mt.life_in_months,0) = nvl(bk.life_in_months,0) and bk.book_type_code = '||'''' || g_book || ''''
1318: ||' and bk.asset_id = '||g_asset_id||')';
1319: l_options_tbl(l_idx).l_cnt_stmt := 'select count(1) '||l_options_tbl(l_idx).l_add_clause;
1320: