APPS.OKL_AM_OM_REMARKET_WF dependencies on OE_ORDER_HEADERS_ALL

Line 269: FROM oe_order_headers_all h,

265: -- different order header Ids
266: --Changed following queries to directly use base tables instead of uv for performance --dkagrawa
267: CURSOR l_assetsale_csr(p_item_id NUMBER) IS
268: SELECT ar.id art_id ,l.ordered_quantity ordered_quantity
269: FROM oe_order_headers_all h,
270: oe_order_lines_all l,
271: mtl_system_items_b i,
272: okl_asset_returns_b ar
273: WHERE h.header_id = l.header_id