APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_SALES_ORDERS

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)

Line 966: mtl_sales_orders WHERE

962:
963:
964: BEGIN
965: SELECT COUNT(1) INTO l_count FROM
966: mtl_sales_orders WHERE
967: sales_order_id = p_mtl_trx_tbl(i).transaction_source_id;
968:
969: EXCEPTION
970: WHEN no_data_found THEN