APPS.QA_FLEX_UTIL dependencies on MTL_SALES_ORDERS

Line 403: -- mtl_sales_orders is a superset of all sales orders. Further,

399: -- is not supported.
400: -- bso Fri Mar 3 15:56:03 PST 2000
401: --
402: -- Completely eliminated oe table(s) from the query because
403: -- mtl_sales_orders is a superset of all sales orders. Further,
404: -- 3rd party sales orders can be alphanumeric, changed from
405: -- a numeric function to a varchar2 function.
406: -- See Bug 1982788.
407: -- bso Sun Sep 16 15:58:51 PDT 2001

Line 409: x_sales_order mtl_sales_orders.segment1%TYPE := NULL;

405: -- a numeric function to a varchar2 function.
406: -- See Bug 1982788.
407: -- bso Sun Sep 16 15:58:51 PDT 2001
408:
409: x_sales_order mtl_sales_orders.segment1%TYPE := NULL;
410: CURSOR c IS
411: SELECT segment1 order_number
412: FROM mtl_sales_orders
413: WHERE sales_order_id = x_id;

Line 412: FROM mtl_sales_orders

408:
409: x_sales_order mtl_sales_orders.segment1%TYPE := NULL;
410: CURSOR c IS
411: SELECT segment1 order_number
412: FROM mtl_sales_orders
413: WHERE sales_order_id = x_id;
414:
415: BEGIN
416: IF x_id IS NULL THEN