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_GAINLOSS_DPR_PKG dependencies on FA_BOOKS

Line 129: from fa_books fbks1,

125: l_rate_change_flag varchar2(1);
126:
127: Cursor c_rate_change_flag is
128: select 'Y'
129: from fa_books fbks1,
130: fa_books fbks2
131: where fbks1.book_type_code = dpr.book
132: and fbks1.asset_id = dpr.asset_id
133: and fbks2.book_type_code = fbks1.book_type_code

Line 130: fa_books fbks2

126:
127: Cursor c_rate_change_flag is
128: select 'Y'
129: from fa_books fbks1,
130: fa_books fbks2
131: where fbks1.book_type_code = dpr.book
132: and fbks1.asset_id = dpr.asset_id
133: and fbks2.book_type_code = fbks1.book_type_code
134: and fbks2.asset_id = fbks2.asset_id

Line 157: from fa_books fbks1,

153: Cursor c_rate_details is
154: select fbks1.adjusted_rate,fbks1.transaction_header_id_in,fbks1.deprn_method_code,
155: fbks2.adjusted_rate,fbks2.transaction_header_id_in,fbks2.deprn_method_code,
156: fbks1.life_in_months, fbks2.life_in_months -- Bug 6983060: Fetch life also
157: from fa_books fbks1,
158: fa_books fbks2
159: where fbks1.book_type_code=dpr.book
160: and fbks1.asset_id=dpr.asset_id
161: and fbks2.book_type_code =fbks1.book_type_code

Line 158: fa_books fbks2

154: select fbks1.adjusted_rate,fbks1.transaction_header_id_in,fbks1.deprn_method_code,
155: fbks2.adjusted_rate,fbks2.transaction_header_id_in,fbks2.deprn_method_code,
156: fbks1.life_in_months, fbks2.life_in_months -- Bug 6983060: Fetch life also
157: from fa_books fbks1,
158: fa_books fbks2
159: where fbks1.book_type_code=dpr.book
160: and fbks1.asset_id=dpr.asset_id
161: and fbks2.book_type_code =fbks1.book_type_code
162: and fbks2.asset_id =fbks2.asset_id

Line 493: from fa_books inbk

489: select outbk.salvage_value - inbk.salvage_value
490: , nvl(outbk.allowed_deprn_limit_amount, 0) -
491: nvl(inbk.allowed_deprn_limit_amount, 0),
492: outbk.unrevalued_cost - inbk.unrevalued_cost
493: from fa_books inbk
494: , fa_books outbk
495: where inbk.transaction_header_id_in = ret.th_id_in
496: and outbk.asset_id = ret.asset_id
497: and outbk.book_type_code = ret.book

Line 494: , fa_books outbk

490: , nvl(outbk.allowed_deprn_limit_amount, 0) -
491: nvl(inbk.allowed_deprn_limit_amount, 0),
492: outbk.unrevalued_cost - inbk.unrevalued_cost
493: from fa_books inbk
494: , fa_books outbk
495: where inbk.transaction_header_id_in = ret.th_id_in
496: and outbk.asset_id = ret.asset_id
497: and outbk.book_type_code = ret.book
498: and outbk.transaction_header_id_out = ret.th_id_in;