DBA Data[Home] [Help]

APPS.OKL_AM_OM_REMARKET_WF dependencies on MTL_SYSTEM_ITEMS_B

Line 271: mtl_system_items_b i,

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
274: and l.ship_from_org_id = i.organization_id
275: AND l.inventory_item_id = i.inventory_item_id