DBA Data[Home] [Help]

APPS.OKL_AM_OM_REMARKET_WF dependencies on OE_ORDER_LINES_ALL

Line 252: FROM oe_order_lines_all

248: /* -- SECHAWLA 21-OCT-04 3924244
249: -- This cursor is used to get all the Order Lines for a given Order
250: CURSOR l_orderlines_csr(p_id NUMBER) IS
251: SELECT line_id, inventory_item_id
252: FROM oe_order_lines_all
253: WHERE header_id = p_id;
254: */
255:
256: -- SECHAWLA 21-OCT-04 3924244

Line 260: FROM oe_order_lines_all

256: -- SECHAWLA 21-OCT-04 3924244
257: -- This cursor is used to get all the Order Lines for a given Order
258: CURSOR l_orderlines_csr(cp_line_id NUMBER) IS
259: SELECT inventory_item_id
260: FROM oe_order_lines_all
261: WHERE line_id = cp_line_id;
262:
263: -- This cursor is used to get the ordered quantity for all the orders booked against a given inventory item
264: -- For a given inventory Item, this cursor will return all rows with same asset return Id (art_id) and possibly

Line 270: oe_order_lines_all l,

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

Line 448: FROM oe_order_lines_all

444: /* -- SECHAWLA 21-OCT-04 3924244
445: -- This cursor is used to get all the Order Lines for a given Order
446: CURSOR l_orderlines_csr(p_id NUMBER) IS
447: SELECT line_id, inventory_item_id
448: FROM oe_order_lines_all
449: WHERE header_id = p_id;
450: */
451:
452: --ADDED BY AKRANGAN FOR SETTING THE CONTEXT FOR THE WF CALL