DBA Data[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on CSI_I_ASSETS

Line 224: FROM csi_i_assets cia,

220: CURSOR asset_cur(p_csi_txn_id IN number, p_po_dist_id in number) IS
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

Line 238: FROM csi_i_assets cia,

234: UNION
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