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

Line 110: from fa_transaction_headers

106: p_corp_book varchar2,
107: p_start_thid number,
108: p_end_thid number) is
109: select transaction_header_id
110: from fa_transaction_headers
111: where asset_id = p_asset_id
112: and book_type_code = p_corp_book
113: and transaction_type_code = 'ADDITION/VOID'
114: and transaction_header_id > p_start_thid

Line 121: from fa_transaction_headers

117:
118: -- Bug 5864939
119: cursor c_last_copied_trx (p_asset_id number) is
120: select source_transaction_header_id
121: from fa_transaction_headers
122: where book_type_code = p_book_type_code
123: and asset_id = p_asset_id
124: and source_transaction_header_id is not null
125: order by transaction_header_id desc;

Line 308: from fa_transaction_headers

304: end if;
305:
306: select source_transaction_header_id
307: into l_orig_src_trx_header_id
308: from fa_transaction_headers
309: where transaction_header_id = l_tax_thid(l_loop_count);
310:
311: -- Bug 5864939 start
312: -- If l_orig_src_trx_header_id is null populate it with the

Line 805: fa_transaction_headers corp_th

801: select count(*)
802: into l_count
803: from fa_books corp_bk,
804: fa_deprn_periods dp,
805: fa_transaction_headers corp_th
806: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
807: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
808: and corp_bk.asset_id = p_asset_id
809: and corp_bk.book_type_code = dp.book_type_code

Line 1226: fa_transaction_headers corp_th,

1222: decode(tax_bk.period_counter_fully_reserved,null,
1223: (nvl(tax_bk.period_counter_life_complete,0)), 0),
1224: tax_bk.group_asset_id
1225: from fa_asset_history ah,
1226: fa_transaction_headers corp_th,
1227: fa_additions_b ad,
1228: fa_books corp_bk_new,
1229: fa_books corp_bk_old,
1230: fa_books tax_bk

Line 1244: from FA_TRX_REFERENCES ref, fa_transaction_headers th

1240: and tax_bk.date_ineffective is null;
1241:
1242: cursor c_trx_subtype is
1243: select ref.src_transaction_subtype
1244: from FA_TRX_REFERENCES ref, fa_transaction_headers th
1245: where th.transaction_header_id = p_corp_thid
1246: and ref.trx_reference_id = th.trx_reference_id;
1247:
1248: BEGIN

Line 1465: from fa_transaction_headers th

1461: -- check fully retired in tax (done in api)
1462: -- check if manual retirements were ever entered in tax
1463: select count (*)
1464: into l_count
1465: from fa_transaction_headers th
1466: where th.book_type_code = p_tax_book
1467: and th.asset_id = l_asset_id
1468: and th.transaction_type_code in
1469: ('FULL RETIREMENT', 'PARTIAL RETIREMENT', 'REINSTATEMENT')

Line 1761: from fa_transaction_headers m

1757: -- corporate change and use it here
1758:
1759: select m.amortization_start_date
1760: into l_trans_rec.amortization_start_date
1761: from fa_transaction_headers m
1762: where m.transaction_header_id = p_corp_thid;
1763:
1764: -- set the group asset id for tax
1765: l_asset_fin_rec_adj.group_asset_id := nvl(l_corp_new_group_asset_id, FND_API.G_MISS_NUM);

Line 1979: from fa_transaction_headers corp_th,

1975: corp_rt.itc_recapture_id,
1976: corp_rt.reference_num,
1977: corp_rt.sold_to,
1978: corp_rt.trade_in_asset_id
1979: from fa_transaction_headers corp_th,
1980: fa_books corp_bk,
1981: fa_books tax_bk,
1982: fa_retirements corp_rt,
1983: fa_additions_b ad,

Line 2124: from fa_transaction_headers th,

2120: l_transaction_type_code = 'FULL RETIREMENT') then
2121:
2122: select count(*)
2123: into l_count
2124: from fa_transaction_headers th,
2125: fa_retirements ret
2126: where th.book_type_code = p_tax_book
2127: and th.asset_id = p_asset_id
2128: and ret.book_type_code(+) = p_tax_book

Line 2139: from fa_transaction_headers

2135: else
2136:
2137: select count(*)
2138: into l_count
2139: from fa_transaction_headers
2140: where asset_id = p_asset_id
2141: and book_type_code = p_tax_book
2142: and transaction_type_code not in ('ADDITION/VOID', 'CIP ADDITION VOID')
2143: and transaction_date_entered > l_trx_date_entered;

Line 2282: from fa_retirements rt, fa_transaction_headers th,

2278: -- HH: 8364239
2279: BEGIN
2280: select rtx.transaction_header_id_out
2281: into l_tax_reinst_thid
2282: from fa_retirements rt, fa_transaction_headers th,
2283: fa_retirements rtx
2284: where rt.transaction_header_id_out = p_corp_thid
2285: and th.book_type_code = p_tax_book
2286: and th.asset_id = p_asset_id

Line 2388: from fa_transaction_headers th

2384:
2385: -- verify there have never been any manual retirements
2386: select count(*)
2387: into l_count
2388: from fa_transaction_headers th
2389: where th.book_type_code = p_tax_book
2390: and th.asset_id = p_asset_id
2391: and th.transaction_type_code in
2392: ('FULL RETIREMENT', 'PARTIAL RETIREMENT', 'REINSTATEMENT')

Line 3050: fa_transaction_headers corp_th,

3046: corp_th.transaction_type_code,
3047: corp_bk_old.group_asset_id old_group_asset_id,
3048: corp_bk.group_asset_id new_group_asset_id
3049: from fa_additions_b ad,
3050: fa_transaction_headers corp_th,
3051: fa_books corp_bk,
3052: fa_books corp_bk_old,
3053: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
3054: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

Line 3067: fa_transaction_headers tax_th,

3063: and corp_bk.transaction_header_id_in = corp_th.transaction_header_id
3064: and corp_bk_old.asset_id(+) = corp_th.asset_id
3065: and corp_bk_old.book_type_code(+) = corp_th.book_type_code
3066: and corp_bk_old.transaction_header_id_out(+) = corp_th.transaction_header_id) assets,
3067: fa_transaction_headers tax_th,
3068: fa_books tax_bk,
3069: fa_category_book_defaults cbd
3070: where tax_th.book_type_code(+) = p_book_type_code
3071: and tax_th.asset_id(+) = assets.asset_id