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_MASS_REVAL_PKG dependencies on FA_MASS_REVALUATION_RULES

Line 187: fa_mass_revaluation_rules rr,

183: DECODE(rr.override_defaults_flag,
184: 'YES', rr.revalue_cip_assets_flag,
185: g_def_revalue_cip_assets_flag)
186: FROM fa_parallel_workers pw,
187: fa_mass_revaluation_rules rr,
188: fa_additions_b ad
189: WHERE pw.request_id = p_parent_request_id
190: AND pw.worker_number = p_request_number
191: AND pw.process_status = 'UNPROCESSED'

Line 239: fa_mass_revaluation_rules rr,

235: DECODE(rr.override_defaults_flag,
236: 'YES', rr.revalue_cip_assets_flag,
237: g_def_revalue_cip_assets_flag)
238: FROM fa_parallel_workers pw,
239: fa_mass_revaluation_rules rr,
240: fa_additions_b ad
241: WHERE pw.request_id = p_parent_request_id
242: AND pw.worker_number = p_request_number
243: AND pw.process_status = 'UNPROCESSED'

Line 926: fa_mass_revaluation_rules rr

922: 1,
923: 'UNPROCESSED'
924: FROM fa_additions_b ad,
925: fa_books bk,
926: fa_mass_revaluation_rules rr
927: WHERE rr.mass_reval_id = p_mass_reval_id
928: AND rr.category_id IS NULL
929: AND rr.asset_id is not null
930: AND ad.asset_id = rr.asset_id

Line 985: fa_mass_revaluation_rules rr

981: 1,
982: 'UNPROCESSED'
983: FROM fa_additions_b ad,
984: fa_books bk,
985: fa_mass_revaluation_rules rr
986: WHERE rr.mass_reval_id = p_mass_reval_id
987: AND rr.category_id = ad.asset_category_id
988: AND rr.category_id IS not NULL
989: AND rr.asset_id is null