APPS.OE_RMA_WF dependencies on OE_ORDER_LINES

Line 282: FROM mtl_system_items m, oe_order_lines_all l

278: SELECT DECODE(l.shippable_flag,NULL,m.shippable_item_flag ,
279: l.shippable_flag),
280: mtl_transactions_enabled_flag
281: INTO l_shippable_flag,l_transactable_flag
282: FROM mtl_system_items m, oe_order_lines_all l
283: WHERE m.inventory_item_id = l.inventory_item_id
284: AND l.line_id = to_number(itemkey)
285: AND m.organization_id = l.ship_from_org_id;
286:

Line 391: UPDATE OE_ORDER_LINES_ALL

387: -- end data fix project
388: app_exception.raise_exception;
389: END IF;
390: ELSE
391: UPDATE OE_ORDER_LINES_ALL
392: SET flow_status_code = 'AWAITING_RETURN'
393: WHERE line_id = to_number(itemkey);
394:
395: END IF;

Line 472: FROM oe_order_lines l

468: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
469:
470: CURSOR return_lines IS
471: SELECT line_id,wias.item_type,wias.item_key
472: FROM oe_order_lines l
473: ,WF_ITEM_ACTIVITY_STATUSES WIAS
474: ,WF_PROCESS_ACTIVITIES WPA
475: WHERE l.header_id = To_Number(itemkey)
476: AND l.line_category_code = 'RETURN'

Line 563: FROM oe_order_lines l

559: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
560:
561: CURSOR return_lines IS
562: SELECT line_id,wias.item_type,wias.item_key
563: FROM oe_order_lines l
564: ,WF_ITEM_ACTIVITY_STATUSES WIAS
565: ,WF_PROCESS_ACTIVITIES WPA
566: WHERE l.header_id = To_Number(itemkey)
567: AND l.line_category_code = 'RETURN'