[Home] [Help]
63: l_itiv_ib_tbl OKL_ITI_PVT.itiv_tbl_type;
64: -- gboomina Added for Bug 5876083 - Start
65: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
66: l_clev_fa_id OKC_K_LINES_B.ID%TYPE;
67: l_asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE;
68: -- gboomina Added for Bug 5876083 - End
69: x_clev_fin_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
70: x_clev_model_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
71: x_clev_fa_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
804: order by cle_fin.id asc;
805: l_install_site_active_rec c_install_site_active%ROWTYPE;
806:
807: -- This cursor is used to get Asset Key from FA tables for Active Contract
808: CURSOR c_asset_key_active(p_asset_number IN fa_additions_b.asset_number%type)
809: IS
810: select faa.asset_key_ccid ccid,
811: fakw.concatenated_segments segs
812: from fa_mass_additions faa,
816: l_asset_key_active_rec c_asset_key_active%ROWTYPE;
817:
818: -- This cursor is used to get Model Number, Manufacturer and FA Location
819: -- from FA tables for Active Contract
820: CURSOR c_fa_line_active(p_asset_number IN fa_additions_b.asset_number%type)
821: IS
822: select loc.name fa_location_name,
823: loc.id1 fa_location_id,
824: fa.manufacturer_name,
824: fa.manufacturer_name,
825: fa.model_number
826: from fa_distribution_history fa_hist,
827: okx_ast_locs_v loc,
828: fa_additions_b fa
829: where fa.asset_id = fa_hist.asset_id
830: and fa_hist.location_id = loc.location_id
831: and fa.asset_number = p_asset_number
832: and fa_hist.transaction_header_id_out is null