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.

[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 225: csi_item_instances_h ciih

221: SELECT cia.fa_asset_id fa_id,
222: cia.fa_book_type_code fa_book_type_code,
223: 'FA' fa_state
224: FROM csi_i_assets cia,
225: csi_item_instances_h ciih
226: WHERE ciih.transaction_id = p_csi_txn_id
227: AND cia.instance_id = ciih.instance_id
228: AND cia.fa_asset_id is not null
229: AND EXISTS (

Line 239: csi_item_instances_h ciih

235: SELECT cia.fa_mass_addition_id fa_id,
236: cia.fa_book_type_code fa_book_type_code,
237: 'FMA' fa_state
238: FROM csi_i_assets cia,
239: csi_item_instances_h ciih
240: WHERE ciih.transaction_id = p_csi_txn_id
241: AND cia.instance_id = ciih.instance_id
242: AND cia.fa_asset_id is null
243: AND EXISTS (

Line 256: FROM csi_item_instances_h ciih,

252: fma.asset_category_id,
253: fma.book_type_code,
254: fma.date_placed_in_service,
255: fmd.units
256: FROM csi_item_instances_h ciih,
257: fa_mass_additions fma,
258: fa_massadd_distributions fmd
259: WHERE ciih.transaction_id = p_csi_txn_id
260: AND fma.reviewer_comments = to_char(ciih.instance_id)