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 SO_ORDER_TYPES

Line 28: FROM so_order_types sot,

24: CURSOR acursor IS
25: SELECT so.header_id
26: , so.order_number
27: , sot.name
28: FROM so_order_types sot,
29: so_headers so
30: WHERE so.order_number BETWEEN NVL(p_low_order_number,so.order_number)
31: AND NVL( p_high_order_number, so.order_number )
32: -- The time component in Order Date and Creation Date has been stripped off

Line 240: so_order_types ot

236: SELECT 'Open return for this sales order'
237: FROM so_lines sl1,
238: so_lines sl2,
239: so_headers sh,
240: so_order_types ot
241: WHERE sh.order_number = p_order_number
242: AND sh.order_type_id = ot.order_type_id
243: AND ot.name = p_order_type_name
244: AND sl1.header_id = sh.header_id