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 MTL_MATERIAL_TRANSACTIONS_TEMP

Line 177: , mtl_material_transactions_temp mmtt

173: FROM dual
174: WHERE exists (
175: SELECT line_id
176: FROM mtl_txn_request_lines mtrl
177: , mtl_material_transactions_temp mmtt
178: , wms_wsh_wdd_gtemp wwwg
179: , mtl_txn_request_headers mtrh
180: WHERE mmtt.move_order_line_id =
181: wwwg.move_order_line_id

Line 211: from mtl_material_transactions_temp mmtt

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
213: mmtt.transfer_lpn_id is not null and -- the line is loaded
214: mmtt.transfer_lpn_id in -- loaded into a LPN which is included in the inputted lines
215: (Select nvl(transfer_lpn_id,cartonization_id)

Line 216: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg

212: where -- first case, line is loaded into same lpn or has the same carton
213: mmtt.transfer_lpn_id is not null and -- the line is loaded
214: mmtt.transfer_lpn_id in -- loaded into a LPN which is included in the inputted lines
215: (Select nvl(transfer_lpn_id,cartonization_id)
216: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg
217: Where mmtt1.move_order_line_id = wwwg.move_order_line_id
218: and nvl(mmtt1.transfer_lpn_id,mmtt1.cartonization_id) is not null)
219: and not exists( select 1
220: from WMS_WSH_WDD_GTEMP www

Line 244: from mtl_material_transactions_temp mmtt

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
246: and mmtt.cartonization_id in
247: (Select nvl(transfer_lpn_id,cartonization_id)
248: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg

Line 248: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg

244: from mtl_material_transactions_temp mmtt
245: where mmtt.transfer_lpn_id is null
246: and mmtt.cartonization_id in
247: (Select nvl(transfer_lpn_id,cartonization_id)
248: From mtl_material_transactions_temp mmtt1,WMS_WSH_WDD_GTEMP wwwg
249: Where mmtt1.move_order_line_id = wwwg.move_order_line_id
250: and nvl(mmtt1.transfer_lpn_id,mmtt1.cartonization_id) is not null)
251: and not exists( select 1
252: from WMS_WSH_WDD_GTEMP www