DBA Data[Home] [Help]

APPS.OKL_AM_OM_REMARKET_WF dependencies on OKL_ASSET_RETURNS_ALL_B

Line 285: okl_asset_returns_all_b oar,

281: -- This cursor is used to get the Original Asset Return Quantity for an inventory item.
282: CURSOR l_assetreturns_csr(p_id NUMBER) IS
283: SELECT cim.number_of_items quantity, oar.ars_code ars_code
284: FROM okc_k_lines_b kle,
285: okl_asset_returns_all_b oar,
286: okc_k_lines_b kle2,
287: okc_line_styles_b lse,
288: okc_k_items cim
289: WHERE oar.kle_id = kle.id