APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 177: FROM mtl_material_transactions_temp

173: l_rev,
174: l_uom,
175: l_lpn_id,
176: l_qty
177: FROM mtl_material_transactions_temp
178: WHERE transaction_temp_id = p_task_trx_id;
179:
180: IF p_bus_event in (WMS_BE_PUTAWAY_DROP, WMS_BE_PICK_DROP) THEN
181: IF (l_debug = 1) THEN

Line 501: FROM mtl_material_transactions_temp mmtt,

497: SELECT
498: mtlt.lot_number lot_num,
499: mtlt.transaction_quantity lot_qty,
500: msnt.fm_serial_number ser_num
501: FROM mtl_material_transactions_temp mmtt,
502: mtl_transaction_lots_temp mtlt,
503: mtl_serial_numbers_temp msnt
504: WHERE
505: mmtt.transaction_temp_id = wdrrec.task_id

Line 1097: mtl_material_transactions_temp mmtt

1093: IF v_xml.bus_event_id = wms_be_pick_release THEN
1094: begin
1095: select To_number(wdd.source_header_number) into l_order_num from
1096: wsh_delivery_details wdd,
1097: mtl_material_transactions_temp mmtt
1098: where mmtt.transaction_temp_id = v_xml.taskid
1099: and mmtt.trx_source_line_id = wdd.source_line_id;
1100: EXCEPTION
1101: WHEN others THEN

Line 1111: mtl_material_transactions_temp mmtt

1107: ELSIF v_xml.bus_event_id = wms_be_mo_task_alloc THEN
1108: BEGIN
1109: select mtrl.header_id into l_order_num
1110: from mtl_txn_request_lines mtrl,
1111: mtl_material_transactions_temp mmtt
1112: where mmtt.move_order_line_id = mtrl.line_id
1113: and transaction_temp_id = v_xml.taskid;
1114: EXCEPTION
1115: WHEN others THEN