APPS.EAM_CAP_MAIN_COST_PVT dependencies on CSI_I_ASSETS

Line 42: csi_i_assets cia

38: pc_inventory_item_id IN NUMBER) IS
39: SELECT cia.fa_asset_id,
40: cia.fa_book_type_code
41: FROM csi_item_instances cii,
42: csi_i_assets cia
43: WHERE cii.instance_id = cia.instance_id
44: AND cii.inventory_item_id = NVL(pc_asset_group_id,pc_rebuild_item_id)
45: AND cii.instance_number = NVL(pc_asset_number, pc_rebuild_serial_number)
46: AND cia.asset_quantity > 0

Line 108: -- Get the asset information from CSI_I_ASSETS

104: l_asset_number := NULL;
105: l_in_use_flag := NULL;
106: l_add_to_asset := TRUE;
107: l_post_asset_category_id := NULL;
108: -- Get the asset information from CSI_I_ASSETS
109: OPEN c_inst_asset_info(p_eam_wo_bills_tbl(i).asset_group_id,
110: p_eam_wo_bills_tbl(i).rebuild_item_id,
111: p_eam_wo_bills_tbl(i).asset_number,
112: p_eam_wo_bills_tbl(i).rebuild_serial_number,