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.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on FA_ADDITIONS

Line 534: fa_additions c,

530: SELECT a.retirement_id,a.asset_id asset_id,
531: b.transaction_header_id transaction_header_id,
532: rpad(c.asset_number||'-'||substr(c.description,1,30),45,' ') asset_desc
533: FROM fa_books d,
534: fa_additions c,
535: fa_transaction_headers b,
536: fa_retirements a
537: WHERE a.book_type_code = p_book_type_code
538: AND a.transaction_header_id_in = b.transaction_header_id

Line 737: fa_additions c,

733: SELECT a.retirement_id retirement_id,a.asset_id asset_id,
734: b.transaction_header_id transaction_header_id,
735: rpad(c.asset_number||'-'||substr(c.description,1,30),45,' ') asset_desc
736: FROM fa_books d,
737: fa_additions c,
738: fa_transaction_headers b,
739: fa_retirements a
740: WHERE a.book_type_code = p_book_type_code
741: AND a.transaction_header_id_out = b.transaction_header_id

Line 934: fa_additions b

930: a.period_adjustment_amount adjst_amount,
931: b.asset_category_id asset_category,
932: rpad(b.asset_number||'-'||substr(b.description,1,30),45,' ') asset_desc
933: FROM jl_zz_fa_retiremnt_adjs a,
934: fa_additions b
935: WHERE a.book_type_code = p_book_type_code
936: AND a.period_counter = g_previous_period_counter
937: AND a.asset_id = b.asset_id
938: AND NOT EXISTS (SELECT 1

Line 1151: fa_additions b,

1147: UNION
1148: SELECT nvl(sum(a.period_adjustment_amount),0) adjst_amount,
1149: c.reval_reserve_account_ccid ccid, 2 ident
1150: FROM fa_category_books c,
1151: fa_additions b,
1152: jl_zz_fa_retiremnt_adjs a
1153: WHERE a.book_type_code = p_book_type_code
1154: AND a.period_counter = g_period_counter1
1155: AND a.status = 'N'