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.WMS_SHIPPING_INTERFACE_GRP dependencies on DUAL

Line 173: FROM dual

169:
170: BEGIN
171: SELECT 1
172: INTO l_cd_exists
173: FROM dual
174: WHERE exists (
175: SELECT mtrl.line_id
176: FROM mtl_txn_request_lines mtrl
177: , mtl_material_transactions_temp mmtt

Line 208: from dual

204:
205: BEGIN
206: select 1
207: into l_exists
208: from dual
209: where exists(
210: select move_order_line_id
211: from mtl_material_transactions_temp mmtt
212: where -- first case, line is loaded into same lpn or has the same carton

Line 241: from dual

237: END IF;
238: BEGIN
239: select 1
240: into l_exists
241: from dual
242: where exists(
243: select move_order_line_id
244: from mtl_material_transactions_temp mmtt
245: where mmtt.transfer_lpn_id is null

Line 839: FROM dual

835:
836: BEGIN
837: SELECT 1
838: INTO l_delivery_status
839: FROM dual
840: WHERE EXISTS ( SELECT lpn_context
841: FROM wms_license_plate_numbers wlpn
842: , wms_shipping_transaction_temp wstt
843: WHERE wlpn.lpn_id = wstt.outermost_lpn_id

Line 890: select 'Y' into l_return from dual where exists

886: is
887: l_return varchar2(1):='N';
888: begin
889: begin
890: select 'Y' into l_return from dual where exists
891: (select 1 from wms_wp_wave_lines
892: where delivery_detail_id = p_delivery_detail_id
893: and nvl(remove_from_wave_flag, 'N') <> 'Y');
894: exception