DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 585: SELECT 1 INTO l_count FROM mtl_sales_orders mso, oe_order_headers_all oeha

581: END;
582:
583: l_count := 0;
584: BEGIN
585: SELECT 1 INTO l_count FROM mtl_sales_orders mso, oe_order_headers_all oeha
586: WHERE oeha.header_id = l_so_header_id
587: AND oeha.order_number = mso.segment1
588: AND mso.sales_order_id = p_mtl_trx_tbl(i).transaction_source_id
589: AND NVL(START_DATE_ACTIVE, SYSDATE - 1)