DBA Data[Home] [Help]

APPS.INV_SALESORDER dependencies on OE_ORDER_HEADERS

Line 387: from oe_order_headers_all

383: BEGIN
384:
385: Select header_id
386: into l_header_id
387: from oe_order_headers_all
388: where order_number = p_order_number AND
389: order_type_id IN (select tl.transaction_type_id
390: from oe_transaction_types_tl tl,
391: oe_transaction_types_all ta

Line 535: FROM oe_order_headers a,

531: FORALL i IN 1..P_ERROR_REC.header_id.COUNT
532: DELETE from mtl_sales_orders
533: WHERE (segment1, segment2) IN
534: (select to_char(a.order_number),b.name
535: FROM oe_order_headers a,
536: oe_order_types_v b
537: WHERE a.header_id = p_error_rec.header_id(i)
538: AND a.order_type_id = b.order_type_id);
539: