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.OE_BIS_CUST_SAT_SUMMARY dependencies on SO_PICKING_LINE_DETAILS

Line 137: so_picking_line_details spld

133: so_headers_all sha,
134: so_lines_all sla,
135: wsh_departures wd,
136: so_picking_lines_all spla,
137: so_picking_line_details spld
138: where sha.header_id = sla.header_id
139: and sla.line_id = spla.order_line_id
140: and spla.picking_line_id = spld.picking_line_id
141: and spld.picking_line_detail_id in -- New

Line 143: from so_picking_line_details spld1

139: and sla.line_id = spla.order_line_id
140: and spla.picking_line_id = spld.picking_line_id
141: and spld.picking_line_detail_id in -- New
142: (select min(spld1.picking_line_detail_id)
143: from so_picking_line_details spld1
144: where spla.picking_line_id = spld1.picking_line_id)
145: and spld.departure_id = wd.departure_id
146: and ( sla.promise_date is not null
147: or sla.schedule_date is not null );