DBA Data[Home] [Help]

APPS.OKL_AM_OM_REMARKET_WF dependencies on OKC_K_LINES_B

Line 284: FROM okc_k_lines_b kle,

280:
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

Line 286: okc_k_lines_b kle2,

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
290: AND kle.id = kle2.cle_id