DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 347: FROM OE_ORDER_HEADERS_ALL

343: END IF;
344: --R12.MOAC
345: SELECT nvl(ORDER_SOURCE_ID,0),nvl(SOURCE_DOCUMENT_TYPE_ID,0),org_id
346: INTO l_order_source_id,l_source_document_type_id,l_ou_id
347: FROM OE_ORDER_HEADERS_ALL
348: WHERE HEADER_ID = l_drop_ship_line_rec.header_id;
349:
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add('Order source id for this order is '||to_char ( l_order_source_id ) , 5 ) ;