[Home] [Help]
573: select count(*)
574: into l_count
575: from fa_books corp_bk,
576: fa_deprn_periods dp,
577: fa_transaction_headers corp_th
578: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
579: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
580: and corp_bk.asset_id = p_asset_id
581: and corp_bk.book_type_code = dp.book_type_code
968: decode(tax_bk.period_counter_fully_reserved,null,
969: (nvl(tax_bk.period_counter_life_complete,0)), 0),
970: tax_bk.group_asset_id
971: from fa_asset_history ah,
972: fa_transaction_headers corp_th,
973: fa_additions_b ad,
974: fa_books corp_bk_new,
975: fa_books corp_bk_old,
976: fa_books tax_bk
1179: -- check fully retired in tax (done in api)
1180: -- check if manual retirements were ever entered in tax
1181: select count (*)
1182: into l_count
1183: from fa_transaction_headers th
1184: where th.book_type_code = p_tax_book
1185: and th.asset_id = l_asset_id
1186: and th.transaction_type_code in
1187: ('FULL RETIREMENT', 'PARTIAL RETIREMENT', 'REINSTATEMENT'
1456: -- corporate change and use it here
1457:
1458: select m.amortization_start_date
1459: into l_trans_rec.amortization_start_date
1460: from fa_transaction_headers m
1461: where m.transaction_header_id = p_corp_thid;
1462:
1463: -- set the group asset id for tax
1464: l_asset_fin_rec_adj.group_asset_id := nvl(l_corp_new_group_asset_id, FND_API.G_MISS_NUM);
1681: corp_rt.itc_recapture_id,
1682: corp_rt.reference_num,
1683: corp_rt.sold_to,
1684: corp_rt.trade_in_asset_id
1685: from fa_transaction_headers corp_th,
1686: fa_books corp_bk,
1687: fa_books tax_bk,
1688: fa_retirements corp_rt,
1689: fa_additions_b ad,
1826: l_transaction_type_code = 'FULL RETIREMENT') then
1827:
1828: select count(*)
1829: into l_count
1830: from fa_transaction_headers th,
1831: fa_retirements ret
1832: where th.book_type_code = p_tax_book
1833: and th.asset_id = p_asset_id
1834: and ret.book_type_code(+) = p_tax_book
1841: else
1842:
1843: select count(*)
1844: into l_count
1845: from fa_transaction_headers
1846: where asset_id = p_asset_id
1847: and book_type_code = p_tax_book
1848: and transaction_type_code not in ('ADDITION/VOID', 'CIP ADDITION VOID')
1849: and transaction_date_entered > l_trx_date_entered;
1962: -- combine with the cursor???
1963: select count(*)
1964: into l_count
1965: from fa_retirements rt,
1966: fa_transaction_headers th
1967: where rt.transaction_header_id_out = p_corp_thid
1968: and th.book_type_code = p_tax_book
1969: and th.asset_id = p_asset_id
1970: and th.transaction_type_code in
2052:
2053: -- verify there have never been any manual retirements
2054: select count(*)
2055: into l_count
2056: from fa_transaction_headers th
2057: where th.book_type_code = p_tax_book
2058: and th.asset_id = p_asset_id
2059: and th.transaction_type_code in
2060: ('FULL RETIREMENT', 'PARTIAL RETIREMENT', 'REINSTATEMENT'
2720: corp_th.transaction_type_code,
2721: corp_bk_old.group_asset_id old_group_asset_id,
2722: corp_bk.group_asset_id new_group_asset_id
2723: from fa_additions_b ad,
2724: fa_transaction_headers corp_th,
2725: fa_books corp_bk,
2726: fa_books corp_bk_old,
2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
2728: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2737: and corp_bk.transaction_header_id_in = corp_th.transaction_header_id
2738: and corp_bk_old.asset_id(+) = corp_th.asset_id
2739: and corp_bk_old.book_type_code(+) = corp_th.book_type_code
2740: and corp_bk_old.transaction_header_id_out(+) = corp_th.transaction_header_id) assets,
2741: fa_transaction_headers tax_th,
2742: fa_books tax_bk,
2743: fa_category_book_defaults cbd
2744: where tax_th.book_type_code(+) = p_book_type_code
2745: and tax_th.asset_id(+) = assets.asset_id