DBA Data[Home] [Help]

APPS.OE_RMA_WF dependencies on OE_ORDER_LINES_ALL

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;