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.CSE_IPV_FA_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 229: csi_item_instances_h ciih

225: SELECT cia.fa_asset_id fa_id,
226: cia.fa_book_type_code fa_book_type_code,
227: 'FA' fa_state
228: FROM csi_i_assets cia,
229: csi_item_instances_h ciih
230: WHERE ciih.transaction_id = p_csi_txn_id
231: AND cia.instance_id = ciih.instance_id
232: AND cia.fa_asset_id is not null
233: AND EXISTS (

Line 243: csi_item_instances_h ciih

239: SELECT cia.fa_mass_addition_id fa_id,
240: cia.fa_book_type_code fa_book_type_code,
241: 'FMA' fa_state
242: FROM csi_i_assets cia,
243: csi_item_instances_h ciih
244: WHERE ciih.transaction_id = p_csi_txn_id
245: AND cia.instance_id = ciih.instance_id
246: AND cia.fa_asset_id is null
247: AND EXISTS (

Line 260: FROM csi_item_instances_h ciih,

256: fma.asset_category_id,
257: fma.book_type_code,
258: fma.date_placed_in_service,
259: fmd.units
260: FROM csi_item_instances_h ciih,
261: fa_mass_additions fma,
262: fa_massadd_distributions fmd
263: WHERE ciih.transaction_id = p_csi_txn_id
264: AND fma.reviewer_comments = to_char(ciih.instance_id)