eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OEXPURGE dependencies on MTL_SALES_ORDERS

Line 135: FROM mtl_sales_orders mso,

131: p_order_type_name VARCHAR2 ) RETURN NUMBER IS
132:
133: CURSOR SO_PROBLEM_CHECK IS
134: SELECT 'Open demand for this sales order'
135: FROM mtl_sales_orders mso,
136: mtl_demand md
137: WHERE mso.segment1 = p_order_number
138: AND mso.segment2 = p_order_type_name
139: AND mso.sales_order_id = md.demand_source_header_id

Line 203: FROM mtl_sales_orders mso,

199: p_order_type_name VARCHAR2 ) RETURN NUMBER IS
200:
201: CURSOR SO_PROBLEM_CHECK IS
202: SELECT 'Open work orders for this sales order'
203: FROM mtl_sales_orders mso,
204: wip_so_allocations wsa,
205: wip_discrete_jobs wdj
206: WHERE mso.segment1 = p_order_number
207: AND mso.segment2 = p_order_type_name