DBA Data[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on CSI_I_ASSETS

Line 228: FROM csi_i_assets cia,

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

Line 242: FROM csi_i_assets cia,

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