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_AMORT_PVT dependencies on FA_BOOKS_MRC_V

Line 1629: from fa_books_mrc_v inbk,

1625: , inbk.deprn_limit_type
1626: , outbk.deprn_limit_type
1627: , inbk.allowed_deprn_limit
1628: , outbk.allowed_deprn_limit
1629: from fa_books_mrc_v inbk,
1630: fa_books_mrc_v outbk
1631: , fa_transaction_headers mth
1632: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1633: and inbk.asset_id = mth.asset_id

Line 1630: fa_books_mrc_v outbk

1626: , outbk.deprn_limit_type
1627: , inbk.allowed_deprn_limit
1628: , outbk.allowed_deprn_limit
1629: from fa_books_mrc_v inbk,
1630: fa_books_mrc_v outbk
1631: , fa_transaction_headers mth
1632: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1633: and inbk.asset_id = mth.asset_id
1634: and outbk.asset_id(+) = inbk.asset_id

Line 2585: from fa_books_mrc_v inbk,

2581: CURSOR c_get_mc_deltas IS
2582: select inbk.salvage_value - nvl(outbk.salvage_value, 0)
2583: , nvl(inbk.allowed_deprn_limit_amount, 0) -
2584: nvl(outbk.allowed_deprn_limit_amount, 0)
2585: from fa_books_mrc_v inbk,
2586: fa_books_mrc_v outbk
2587: where outbk.asset_id(+) = inbk.asset_id
2588: and outbk.book_type_code(+) = inbk.book_type_code
2589: and inbk.transaction_header_id_in = p_trans_rec.member_transaction_header_id

Line 2586: fa_books_mrc_v outbk

2582: select inbk.salvage_value - nvl(outbk.salvage_value, 0)
2583: , nvl(inbk.allowed_deprn_limit_amount, 0) -
2584: nvl(outbk.allowed_deprn_limit_amount, 0)
2585: from fa_books_mrc_v inbk,
2586: fa_books_mrc_v outbk
2587: where outbk.asset_id(+) = inbk.asset_id
2588: and outbk.book_type_code(+) = inbk.book_type_code
2589: and inbk.transaction_header_id_in = p_trans_rec.member_transaction_header_id
2590: and outbk.transaction_header_id_out(+) = inbk.transaction_header_id_in;

Line 8459: fa_books_mrc_v inbk,

8455: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
8456: nvl(outbk.allowed_deprn_limit_amount, 0))
8457: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8458: from fa_transaction_headers th,
8459: fa_books_mrc_v inbk,
8460: fa_books_mrc_v outbk
8461: where inbk.asset_id = p_asset_hdr_rec.asset_id
8462: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
8463: and outbk.asset_id(+) = p_asset_hdr_rec.asset_id

Line 8460: fa_books_mrc_v outbk

8456: nvl(outbk.allowed_deprn_limit_amount, 0))
8457: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8458: from fa_transaction_headers th,
8459: fa_books_mrc_v inbk,
8460: fa_books_mrc_v outbk
8461: where inbk.asset_id = p_asset_hdr_rec.asset_id
8462: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
8463: and outbk.asset_id(+) = p_asset_hdr_rec.asset_id
8464: and outbk.book_type_code(+) = p_asset_hdr_rec.book_type_code

Line 8907: from fa_books_mrc_v

8903: , global_attribute18
8904: , global_attribute19
8905: , global_attribute20
8906: , global_attribute_category
8907: from fa_books_mrc_v
8908: where asset_id = p_asset_hdr_rec.asset_id
8909: and book_type_code = p_asset_hdr_rec.book_type_code
8910: and (transaction_header_id_out = p_trans_rec.transaction_header_id
8911: or (transaction_header_id_in < p_trans_rec.transaction_header_id and

Line 9019: from fa_books_mrc_v

9015: , global_attribute18
9016: , global_attribute19
9017: , global_attribute20
9018: , global_attribute_category
9019: from fa_books_mrc_v
9020: where asset_id = p_asset_hdr_rec.asset_id
9021: and book_type_code = p_asset_hdr_rec.book_type_code
9022: and (transaction_header_id_out = p_init_transaction_header_id
9023: or (p_init_transaction_header_id > transaction_header_id_in and

Line 9414: from fa_books_mrc_v inbk,

9410: , inbk.global_attribute18
9411: , inbk.global_attribute19
9412: , inbk.global_attribute20
9413: , inbk.global_attribute_category
9414: from fa_books_mrc_v inbk,
9415: fa_books_mrc_v outbk
9416: where inbk.asset_id = c_asset_id
9417: and inbk.asset_id = outbk.asset_id(+)
9418: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 9415: fa_books_mrc_v outbk

9411: , inbk.global_attribute19
9412: , inbk.global_attribute20
9413: , inbk.global_attribute_category
9414: from fa_books_mrc_v inbk,
9415: fa_books_mrc_v outbk
9416: where inbk.asset_id = c_asset_id
9417: and inbk.asset_id = outbk.asset_id(+)
9418: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
9419: and inbk.book_type_code = outbk.book_type_code(+)

Line 9741: from fa_books_mrc_v inbk,

9737: , inbk.global_attribute18
9738: , inbk.global_attribute19
9739: , inbk.global_attribute20
9740: , inbk.global_attribute_category
9741: from fa_books_mrc_v inbk,
9742: fa_books_mrc_v outbk
9743: where inbk.asset_id = c_asset_id
9744: and inbk.asset_id = outbk.asset_id(+)
9745: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 9742: fa_books_mrc_v outbk

9738: , inbk.global_attribute19
9739: , inbk.global_attribute20
9740: , inbk.global_attribute_category
9741: from fa_books_mrc_v inbk,
9742: fa_books_mrc_v outbk
9743: where inbk.asset_id = c_asset_id
9744: and inbk.asset_id = outbk.asset_id(+)
9745: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
9746: and inbk.book_type_code = outbk.book_type_code(+)

Line 14637: from fa_books_mrc_v bk

14633: l_asset_fin_rec.rate_adjustment_factor,
14634: l_asset_fin_rec.prorate_date,
14635: l_asset_fin_rec.deprn_start_date,
14636: l_asset_fin_rec.date_placed_in_service
14637: from fa_books_mrc_v bk
14638: where bk.book_type_code = p_asset_hdr_rec.book_type_code
14639: and bk.asset_id = p_asset_hdr_rec.asset_id
14640: and bk.transaction_header_id_in = p_add_txn_id;
14641: else