DBA Data[Home] [Help]

APPS.OE_PROCESS_REQUISITION_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 692: from oe_order_headers_all

688: END IF;
689:
690: select order_number, last_update_date
691: into g_sales_order_number, g_order_cancellation_date
692: from oe_order_headers_all
693: where header_id = p_header_id;
694:
695: g_reason := OE_GLOBALS.G_REASON_CODE;
696: -- 'OE_GLOBALS.G_REASON_COMMENTS'

Line 751: from oe_order_headers_all

747: END IF;
748:
749: select order_number
750: into g_sales_order_number
751: from oe_order_headers_all
752: where header_id = p_header_id;
753:
754: -- Added for bug #8920840
755: -- select SubStr(Value,-1,1) into l_separator from v$parameter

Line 843: from oe_order_headers_all

839: END IF;
840:
841: select order_number
842: into g_sales_order_number
843: from oe_order_headers_all
844: where header_id = p_header_id;
845:
846: -- Added for bug #8920840
847: -- select SubStr(Value,-1,1) into l_separator from v$parameter