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.WPS_COMMON dependencies on MTL_SALES_ORDERS

Line 1440: from mtl_reservations mr , mtl_sales_orders mso

1436: into ret
1437: from dual
1438: where exists (
1439: select 1
1440: from mtl_reservations mr , mtl_sales_orders mso
1441: where mso.sales_order_id = mr.demand_source_header_id
1442: and mr.demand_source_type_id = 2
1443: and mr.supply_source_type_id = 5
1444: and mso.segment1 like p_so_name

Line 1483: mtl_sales_orders mso

1479: select mso.segment1, hp.party_name
1480: into so_name, cust_name
1481: from mtl_reservations mr, oe_order_lines_all ool,
1482: hz_cust_accounts hca, hz_parties hp,
1483: mtl_sales_orders mso
1484: where mr.demand_source_line_id = ool.line_id
1485: and mr.demand_source_type_id = 2
1486: and mr.supply_source_type_id = 5
1487: and hca.cust_account_id = ool.sold_to_org_id