DBA Data[Home] [Help]

APPS.OKL_DEAL_ASSET_PVT dependencies on OKX_AST_LOCS_V

Line 758: okx_ast_locs_v ast_loc,

754: okc_line_styles_b lse_fa,
755: okl_k_lines kle_fa,
756: okc_k_lines_b cleb_fa,
757: okl_asset_key_lov_uv ast_key,
758: okx_ast_locs_v ast_loc,
759: okc_k_items cim_fa
760: WHERE cleb_fa.id = kle_fa.id
761: AND lse_fa.id = cleb_fa.lse_id
762: AND lse_fa.lty_code = 'FIXED_ASSET'

Line 876: okx_ast_locs_v loc,

872: loc.id1 fa_location_id,
873: fa.manufacturer_name,
874: fa.model_number
875: from fa_distribution_history fa_hist,
876: okx_ast_locs_v loc,
877: fa_additions_b fa
878: where fa.asset_id = fa_hist.asset_id
879: and fa_hist.location_id = loc.location_id
880: and fa.asset_number = p_asset_number