DBA Data[Home] [Help]

APPS.OKL_DEAL_ASSET_PVT dependencies on OKX_AST_LOCS_V

Line 716: okx_ast_locs_v ast_loc,

712: okc_line_styles_b lse_fa,
713: okl_k_lines kle_fa,
714: okc_k_lines_b cleb_fa,
715: okl_asset_key_lov_uv ast_key,
716: okx_ast_locs_v ast_loc,
717: okc_k_items cim_fa
718: WHERE cleb_fa.id = kle_fa.id
719: AND lse_fa.id = cleb_fa.lse_id
720: AND lse_fa.lty_code = 'FIXED_ASSET'

Line 827: okx_ast_locs_v loc,

823: loc.id1 fa_location_id,
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