DBA Data[Home] [Help]

APPS.INV_SALESORDER dependencies on OE_ORDER_HEADERS

Line 400: from oe_order_headers_all

396: BEGIN
397:
398: Select header_id
399: into l_header_id
400: from oe_order_headers_all
401: where order_number = p_order_number AND
402: order_type_id IN (select tl.transaction_type_id
403: from oe_transaction_types_tl tl,
404: oe_transaction_types_all ta

Line 548: FROM oe_order_headers a,

544: FORALL i IN 1..P_ERROR_REC.header_id.COUNT
545: DELETE from mtl_sales_orders
546: WHERE (segment1, segment2) IN
547: (select to_char(a.order_number),b.name
548: FROM oe_order_headers a,
549: oe_order_types_v b
550: WHERE a.header_id = p_error_rec.header_id(i)
551: AND a.order_type_id = b.order_type_id);
552: