APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 180: FROM mtl_material_transactions_temp

176: l_uom,
177: l_lpn_id,
178: l_qty,
179: l_xfr_lpn_id --Added for Bug#8512121
180: FROM mtl_material_transactions_temp
181: WHERE transaction_temp_id = p_task_trx_id;
182:
183: IF p_bus_event in (WMS_BE_PUTAWAY_DROP, WMS_BE_PICK_DROP) THEN
184: IF (l_debug = 1) THEN

Line 521: FROM mtl_material_transactions_temp mmtt,

517: SELECT
518: mtlt.lot_number lot_num,
519: mtlt.transaction_quantity lot_qty,
520: msnt.fm_serial_number ser_num
521: FROM mtl_material_transactions_temp mmtt,
522: mtl_transaction_lots_temp mtlt,
523: mtl_serial_numbers_temp msnt
524: WHERE
525: mmtt.transaction_temp_id = wdrrec.task_id

Line 1118: mtl_material_transactions_temp mmtt

1114: IF v_xml.bus_event_id = wms_be_pick_release THEN
1115: begin
1116: select To_number(wdd.source_header_number) into l_order_num from
1117: wsh_delivery_details wdd,
1118: mtl_material_transactions_temp mmtt
1119: where mmtt.transaction_temp_id = v_xml.taskid
1120: and mmtt.trx_source_line_id = wdd.source_line_id;
1121: EXCEPTION
1122: WHEN others THEN

Line 1132: mtl_material_transactions_temp mmtt

1128: ELSIF v_xml.bus_event_id = wms_be_mo_task_alloc THEN
1129: BEGIN
1130: select mtrl.header_id into l_order_num
1131: from mtl_txn_request_lines mtrl,
1132: mtl_material_transactions_temp mmtt
1133: where mmtt.move_order_line_id = mtrl.line_id
1134: and transaction_temp_id = v_xml.taskid;
1135: EXCEPTION
1136: WHEN others THEN